topic Re: How to call json data from http(s) in tRest or tRestclient component in Talend studio for DI in Talend Studio

How to call json data from http(s) in tRest or tRestclient component in Talend studio for DI

Anonymous — Wed, 03 May 2017 09:04:01 GMT

Hi all,

can someone solve this issues?

I'm using fiddler web debug proxy, from that I'm trying to get some JSON data through trest component in Talend open studio for DI.

Following are my credentials.

1.https link

2.Post method

3.content-type : application/json

4.Accept : application/json

5.json data as like below

{
"Commit": "false",
"Client": "AvaTaxSample",
"CompanyCode": "CYPHERTAX",
"CustomerCode": "ABC4335",
"DocCode": "INV001",
"DocType": "SalesOrder",
"DocDate": "2014-01-01",
"Addresses": [
{
"AddressCode": "01",
"Line1": "2345 Carlmont Drive",
"Line2": "Suite 100",
"Line3": "ATTN Accounts Payable",
"City": "Belmont",
"Region": "CA",
"Country": "US",
"PostalCode": "94002"
}
],
"Lines": [
{
"LineNo": "1",
"DestinationCode": "01",
"OriginCode": "01",
"ItemCode": "N543",
"TaxCode": "NT",
"Description": "Red Size 7 Widget",
"Qty": "1",
"Amount": "100"
}
]
}

I couldn't get the results for this.

instead of json data I have tried with xml data its working fine.

Re: How to call json data from http(s) in tRest or tRestclient component in Talend studio for DI

TRF — Wed, 03 May 2017 09:34:08 GMT

Hi,

The error is at compile time, not at runtime.
As I can see, the body is malformed.
It should contains a Java String enclosed between ".
If it contains " they must be protected by an \ character.
Try this 1st to correct your compile error.

Re: How to call json data from http(s) in tRest or tRestclient component in Talend studio for DI

Anonymous — Wed, 03 May 2017 09:50:24 GMT

Hi,

I really don't know where to use '\'. with the same JSON data, I execute in fiddler tool and I got expected output.

Re: How to call json data from http(s) in tRest or tRestclient component in Talend studio for DI

Anonymous — Wed, 03 May 2017 10:34:14 GMT

Hi Sir,

Can You please work on that data and show with screenshots.

Re: How to call json data from http(s) in tRest or tRestclient component in Talend studio for DI

Anonymous — Wed, 03 May 2017 10:53:06 GMT

"{
\"Commit\": \"false\",
\"Client\": \"AvaTaxSample\",
\"CompanyCode\": \"CYPHERTAX\",
\"CustomerCode\": \"ABC4335\",
\"DocCode\": \"INV001\",
\"DocType\": \"SalesOrder\",
\"DocDate\": \"2014-01-01\",
\"Addresses\": [
{
\"AddressCode\": \"01\",
\"Line1\": \"2345 Carlmont Drive\",
\"Line2\": \"Suite 100\",
\"Line3\": \"ATTN Accounts Payable\",
\"City\": \"Belmont\",
\"Region\": \"CA\",
\"Country\": \"US\",
\"PostalCode\": \"94002\"
}
],
\"Lines\": [
{
\"LineNo\": \"1\",
\"DestinationCode\": \"01\",
\"OriginCode\": \"01\",
\"ItemCode\": \"N543\",
\"TaxCode\": \"NT\",
\"Description\": \"Red Size 7 Widget\",
\"Qty\": \"1\",
\"Amount\": \"100\"
}
]
}"

Re: How to call json data from http(s) in tRest or tRestclient component in Talend studio for DI

Anonymous — Wed, 03 May 2017 11:03:47 GMT

Hi,

Thanks a Lot

It works fine.

I can get my output.

Re: How to call json data from http(s) in tRest or tRestclient component in Talend studio for DI

K11 — Sat, 30 Mar 2024 09:56:58 GMT

Can we print HTTP body in the tLogRow?Is it possible?