From a database to a Rest api

[KJass1652351340]

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

[Anonymous]

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?

[KJass1652351340]

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 !