topic Re: JSON with REST API in Talend Studio

JSON with REST API

MaheswarReddy — Sat, 16 Nov 2024 04:59:59 GMT

Hi Everyone/ @evansdar,

I need to send data from a JSON file from Talend with REST API.
To verify that my file and my POST URL is working, I did the test on Postman without error, it allows to create new object in my tools.

I need this working on Talend, But unfortunately it is failing due to the below error

Here the contents of my JSON file:

----------------

{"master":[

{

"startDateTime": {

"value": "2019-08-01T08%3A00%3A00"

"endDateTime": {

"value": "2019-08-31T16%3A59%3A59"

"serviceId": "2702"

}

]}

--------------------

The json is valid but we are getting an error

<?xml version="1.0" encoding="UTF-8"?>
<Error>
<StatusCode>400</StatusCode>
<StatusText>Invalid JSON : Expected BEGIN_OBJECT but was STRING at line 1 column 2 path $</StatusText>
<InfoText></InfoText>
</Error>|400

Please suggest.

Re: JSON with REST API

TRF — Mon, 12 Aug 2019 14:37:54 GMT

Something with your tREST component?

Can your share its settings?

Re: JSON with REST API

MaheswarReddy — Mon, 12 Aug 2019 14:46:04 GMT

Hi TRF,

Attached is the screenshot.

Thanks,

Mahesh

tRest1.PNG
tRest2.PNG

Re: JSON with REST API

TRF — Mon, 12 Aug 2019 14:50:44 GMT

Your body contains the String " row6.content" (probably not what you expect).

Should be (String)globalMap.get("row6.content") if tFlowToIterate_1 use default settings.

Re: JSON with REST API

MaheswarReddy — Mon, 12 Aug 2019 14:57:04 GMT

I tried like this as you mentioned , but still throws an error.

Rest3.PNG
Rest4.PNG