topic Re: How can I parse the webhook payload json data ? in Talend Studio

How can I parse the webhook payload json data ?

François_T — Wed, 18 May 2022 09:50:48 GMT

Hello !

I'm trying to read the data sent to a job using the webhook URL. I see that I'm getting the payload as a json array, where I have the "data" field containing what I need.

but what I don't know how to do is :

-how can i parse this json content ? I see Json components, but based on fields or files, and I don't know how to convert my context to one of those

-once I will have this data value, how can I decode it ? It's a simple base64 encoding, so I guess a simple tjava or tjavarow, with the right function ?

Thanks in advance for any help 🙂

Re: How can I parse the webhook payload json data ?

François_T — Wed, 18 May 2022 10:18:07 GMT

I tried with a simple tjava component, with this code :

JSONObject obj=new JSONObject(context.resource_webhook_payload);

context.email_requester=obj.getString("data");

but it's refusing to read the json object, as there are "[]" around it. How can I read the content ?

Re: How can I parse the webhook payload json data ?

Anonymous — Thu, 19 May 2022 07:32:23 GMT

@François Tissandier , take a look at this topic, and try the code used to decode the base64 string on tJavaRow.

Regards

Shong

Re: How can I parse the webhook payload json data ?

François_T — Thu, 19 May 2022 13:01:43 GMT

Thanks for the answer ! But before being able to decode anything, I need to have the value first 🙂

ANd "context.resource_webhook_payload" contains the json payload, but with [ ] around it. So "new JSONObject(" isn't working. How can I make it read the Json part within the [ ] ?

Re: How can I parse the webhook payload json data ?

Anonymous — Fri, 20 May 2022 00:02:11 GMT

@François Tissandier , remove the [ ] from the string using expression:

JSONObject obj=new JSONObject((context.resource_webhook_payload.replaceAll("[","")).replaceAll("]",""));

Re: How can I parse the webhook payload json data ?

François_T — Mon, 23 May 2022 16:06:12 GMT

Indeed, quite simple and it's working !

Is it possible to decode the base64 content ? I can't find a simple way to do it in my tjava component 😞

Re: How can I parse the webhook payload json data ?

Anonymous — Tue, 24 May 2022 03:46:55 GMT

if the data comes from an input component, use tJavaRow instead of tJava, as showed in the topic.