topic Extract JSON parameters from trestClient response in Talend Studio

Extract JSON parameters from trestClient response

Anonymous — Wed, 26 Apr 2017 11:01:46 GMT

Hello,

I receive a String containing a JSON from my tRestClient response. How I can extract a parameter from that JSON?

Thanks.

Re: Extract JSON parameters from trestClient response

Anonymous — Wed, 26 Apr 2017 11:08:17 GMT

Try to use tExtractJsonField to extract data from the json response. Let me know if you have troubles to use this component and show an example of json response.

Re: Extract JSON parameters from trestClient response

Anonymous — Wed, 26 Apr 2017 11:11:34 GMT

I don't know how to take the 'id' parameter from that json using tExtractJsonField .

Here's an example of that json:

{
"id": "cus_test",
"object": "customer",
"account_balance": 0,
"created": 1493201430,
"currency": null,
"default_source": null,
"delinquent": false,
"description": "Living",
"discount": null,
"email": "test@test.com",
"livemode": false,
"metadata": {},
"shipping": null,
"sources": {
    "object": "list",
    "data": [],
    "has_more": false,
    "total_count": 0,
    "url": "/v1/customers/cus_test/sources"
},
"subscriptions": {
    "object": "list",
    "data": [],
    "has_more": false,
    "total_count": 0,
    "url": "/v1/customers/cus_test/subscriptions"
}
}