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 two 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.

If we do not escape these characters, they will be interpreted as part of the declaration of an interpolation variable in Denodo and we will receive an error message like the following when trying to create a base view on top of the data source:

Unable to obtain the data structure: Parse error ... '...': Error: could not match input

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

Path Types in Virtual DataPort -HTTP 

Disclaimer
The information provided in the Denodo Knowledge Base is intended to assist our users in advanced uses of Denodo. Please note that the results from the application of processes and configurations detailed in these documents may vary depending on your specific environment. Use them at your own discretion.
For an official guide of supported features, please refer to the User Manuals. For questions on critical systems or complex environments we recommend you to contact your Denodo Customer Success Manager.
Recommendation

Questions

Ask a question

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