topic Re: From a database to a Rest api in Talend Studio

From a database to a Rest api

KJass1652351340 — Fri, 15 Nov 2024 22:55:08 GMT

Hello ,

Need some advice on how to insert data from a database to a Rest api (TOS),

to insert data from a database to an api rest

is it necessary to transform the data into a JSON file or is it possible to insert them directly ?

I am stuck, I do not see any logic on how to copy a table with an api

Thanks in advance for help

Re: From a database to a Rest api

Anonymous — Mon, 16 May 2022 22:06:27 GMT

If your API requires JSON, you will need to build it from the db data. This will them need to be sent to the "string" input column of a tRestClient pointing to your API. The API should provide a specification for what is required. Are you able to share that? Is it a public API?

Re: From a database to a Rest api

KJass1652351340 — Wed, 18 May 2022 16:00:40 GMT

Thank you very much for this feedback

I have made progress with this process.

it's a private api

I have a Get call to retrieve the private key that I assign to a variable and then I call a post but I get a problem "HTTP 400 Bad Request"

I have to format my select to the json format of the API I'm trying to do that with tMap, but I don't know if it's the right way !