Error creating JSON data source with "POST Body" parameters

Applies to: Denodo 8.0 , Denodo 7.0 , Denodo 6.0
Last modified on: 10 Jun 2020
Tags: Error handling JSON data sources

Download document

You can translate the document:

Content

When creating a JSON data source using HTTP Client as Data Route and POST as HTTP Method, there are three ways of adding parameters to the body of the request that is sent to the data source:

  1. URL Parameters: when parameters are entered as part of the URL, they will be removed from the URL and sent along with the body of the request in execution time..
  2. POST Body: when this option is selected the text entered in the text area will be sent in the body of the request without modification.

For both options, it is also possible to use interpolation variables as part of the data source configuration.

When using the POST Body option the characters “\”, “@”, “{“ and “}” have to be escaped with the character “\”. If the body of the request is loaded with the Load file option, the VDP administration tool will escape these characters automatically.

To include an interpolation variable in the body, characters “@”, “{“ and “}” should not be escaped if they are part of the interpolation variable definition, for instance, @{employee_id}.

To add interpolation variables the request body should look like:

\{
"employee_id":"@employee_id"
\}

or

\{
"employee_id":"@{employee_id}"
\}

instead of:

{
"employee_id":"@{employee_id}"
}


References

Virtual DataPort Administration Guide: HTTP 

Questions

Ask a question
You must sign in to ask a question. If you do not have an account, you can register here

Featured content

DENODO TRAINING

Ready for more? Great! We offer a comprehensive set of training courses, taught by our technical instructors in small, private groups for getting a full, in-depth guided training in the usage of the Denodo Platform. Check out our training courses.

Training