topic Re: POST JSON with REST API in Talend Studio

POST JSON with REST API

Anonymous — Tue, 05 Feb 2019 15:27:17 GMT

Hello,

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 it to work since Talend, because it will be industrialized later but I can not do it.

Here the contents of my JSON file:
"{
"path": "/Catalogue_Produits/Respiratoire/",
"elements": [
{
"type": "input",
"value": "Respi test 1 RESTAPIxxxx",
"name": "Denom",
"language": null
},
{
"type": "input",
"value": "RESPI test 1 RESTAPIxxxxx",
"name": "Nom_Data",
"language": null
},
{
"type": "select",
"value": "NouveauProduit",
"name": "PROCESSUS_SEL",
"language": null
}
],
"className": "Product",
"parentId": 98,
"key": "Respi3000",
"published": true,
"type": "object"
}"

Here the test ok on Postman:

I am new to Talend, but I tried to add the components:
tFileInputJSON => row => tRest_Client

The setting must be wrong because it does not work.

Can you help me ?

Thank you

Re: POST JSON with REST API

Anonymous — Tue, 05 Feb 2019 16:33:42 GMT

Try using a tRest instead of a tRestClient to POST w/ a body. You can past the raw JSON directly in the HTTP body section (make sure to escape your double quotes though)

Re: POST JSON with REST API

Anonymous — Tue, 05 Feb 2019 16:47:50 GMT

it does not work, I added "\" in front of the quotation marks but it does not change anything :

The error :

The code :

Thank you for your help

Re: POST JSON with REST API

Anonymous — Tue, 05 Feb 2019 17:57:40 GMT

tFileInputJSON should only be used if you need to extract the columns from a JSON file. Because the body of the POST does not require that(i.e. you can send the raw text), then you don't have to use tFileInputJSON. You are getting those compiler warnings because you have extracted those values into a schema and tRest does not need them. Instead use a tfileInputRaw and pass the data into the body of the tRest. I tested w/ a dummy api

Re: POST JSON with REST API

Anonymous — Wed, 06 Feb 2019 13:26:42 GMT

Hello,

@evansdar, it works almost!

The data does not seem to have arrived in the correct format because I get an error.

I rechecked with POSTMAN and the contents of the JSON file is correct.

Would you have an idea?

Thank you

Re: POST JSON with REST API

Anonymous — Wed, 06 Feb 2019 13:27:36 GMT

@evansdar

The error :

Perhaps the components InputRaw :

Re: POST JSON with REST API

Anonymous — Wed, 06 Feb 2019 13:32:21 GMT

You're still using tRestClient, swap to tRest. You'll have to put a tFlowToIterate in between them to connect.

Re: POST JSON with REST API

Anonymous — Wed, 06 Feb 2019 13:36:59 GMT

@evansdar, I can not find the component tFlowTolterate in Talend

Re: POST JSON with REST API

Anonymous — Wed, 06 Feb 2019 13:41:32 GMT

@evansdar, I have found component.

The error continue :

Re: POST JSON with REST API

Anonymous — Wed, 06 Feb 2019 13:54:56 GMT

@evansdar

The data are ok in log :

Démarrage du job test10 a 14:53 06/02/2019.
[statistics] connecting to socket on port 3877
[statistics] connected
.--------------------------------------+----------.
| tLogRow_1 |
|=-------------------------------------+---------=|
|Body |ERROR_CODE|
|=-------------------------------------+---------=|
|{"success":false,"msg":"Invalid data"}|400 |
'--------------------------------------+----------'

.-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| tLogRow_2 |
|=-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------=|
|content |
|=-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------=|
|{
"path": "/Catalogue_Produits/Respiratoire/",
"elements": [
{
"type": "input",
"value": "ALEX",
"name": "Denom",
"language": null
},
{
"type": "input",
"value": "ALEX",
"name": "Nom_Data",
"language": null
},
{
"type": "select",
"value": "NouveauProduit",
"name": "PROCESSUS_SEL",
"language": null
}
],
"className": "Product",
"parentId": 51,
"key": "ALEX",
"published": true,
"type": "object"
}|
'-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------'

[statistics] disconnected

Job test10 terminé à 14:53 06/02/2019. [Code sortie=0]

Re: POST JSON with REST API

Anonymous — Wed, 06 Feb 2019 13:56:28 GMT

are you passing the row value to tRest? Show me a screenshot of that component

Re: POST JSON with REST API

Anonymous — Wed, 06 Feb 2019 13:58:54 GMT

@evansdar

I do not understand what I have to do?

Re: POST JSON with REST API

Anonymous — Wed, 06 Feb 2019 14:05:08 GMT

Your HTTP Body is empty, you should be passing the value that is sent from the tFileInputRaw. See my first Screenshot:

Where 'row1' is the row leading from tFileInputRaw and 'content' is what represents the content of the file. (Clicking the row itself, then the component button will let you see what the schema is defined as)

Re: POST JSON with REST API

Anonymous — Wed, 06 Feb 2019 14:08:15 GMT

@evansdar, it's work !!

Thank you

Re: POST JSON with REST API

Anonymous — Fri, 24 May 2019 20:24:58 GMT

tREST does not seem to accept an input. Is there a setting that needs to be changed to enable?

Re: POST JSON with REST API

LuciusHunt — Thu, 08 Oct 2020 15:59:23 GMT

To see how sending JSON via tRestClient works see the gif in my comment at the end of this post.

tMap -> tWriteJSONField -> tRestClient

Re: POST JSON with REST API

Lrmr — Mon, 22 Mar 2021 09:10:59 GMT

I followed all the steps mentioned above but I am still getting the following error.

Invalid JSON body.|400

[statistics] disconnected

The setup of the job looks as follows

Can someone please advice or help me out?

Thank you in advance