POST request body REST connection

Hi Jeroen,

It looks like as if you need to set up OAUTH2 to obtain a token to connect to the API. Can you show your data source connection settings?

Hi Wouter, thanks for your reply.

We already have all the tokens we need. We do not need a get and/or refresh token, since the tokens we have do not expire. They are fixed and set to a specfic user. By providing these in the request body in a POST statement, we will get our desired output. 

In for example QS and Postman this is easy to find. However, we do not know where to put these in the CDATA connector. 

While the above may be a possible solution. It may also be possible using the normal OAuth setup in the REST provider to make it work.

The client could be a OAuth Parameter field and then it could work without using any RSD files.

@wouter.goslinga Thanks!, finally getting some results using the following rsd. However, this will require us to write the metadata for every table.

@Thomas Lind Will have a look at your suggestion too.

Hi @JeroenS 

You can pull the values from the setup by using something like

[_connection._clienttoken]

@JeroenS maybe you can do the following:

• turn on logging for the datasource
• find the get call in the log and see how the json string is parsed in the connection string
• add this as a custom connection string parameter in the data source

What I did to retrieve the metadata:

-Run the request in Postman

-Save the output as .json

-Read it in TimeXtender with schema generation

-Copy the metadata into our RSD

That is how I do it as well.