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
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:
- 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..
- 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:
\{ |
or
\{ |
instead of:
{ |
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.
