You can translate the question and the replies:

Trying to create a base view from a HTTP POST using Denodo 8.0 20220126

I have created the data source succedssfully , but when I attempt to create the base view I get the following error. Unable to obtain the data structure: com.denodo.util.exceptions.InternalErrorException: No content to map due to end-of-input at [Source: (InputStreamReader); line: 1, column: 0] The only expected output from this post call is the HTTP resonse code, and no other data, Here is the VQL of the data source. CREATE OR REPLACE DATASOURCE JSON ds_optym_terminal_update_json_copy_john FOLDER = '/1 - connectivity/1 - data sources' ROUTE HTTP 'http.CommonsHttpClientConnection,120000' POST 'https://estes-uat.driverplan.io/messages/TerminalUpdate' POSTBODY '\{ "changeType": "@{changeType}", "terminal": \{ "terminalCode": "@{terminalCode}", "terminalNumber": "@{terminalNumber}", "city": "@{city}", "type": "@{type}", "state": "@{state}", "country": "@{country}", "latitude": "@{latitude}", "longitude": "@{longitude}", "timeZoneUTCOffset": "@{timeZoneUTCOffset}", "region": "@{region}" \} \}' MIME 'application/json' HEADERS ( 'token'='hidden' ) AUTHENTICATION OFF PROXY OFF;
user
11-08-2022 17:18:26 -0400
code

1 Answer

Hello, If the REST API does not return any data for the POST method, Denodo cannot build a schema out of that, as there is no data being returned. A workaround could be to create a custom input filter. You can read through the Denodo Documentation on [Developing Custom Input Filters](https://community.denodo.com/docs/html/browse/latest/en/vdp/developer/developing_extensions/developing_custom_input_filters/developing_custom_input_filters). A similar question has been raised in the following [community question](https://community.denodo.com/answers/question/details?questionId=90670000000fyo8AAA&title=Cannot+create+base+view+on+JSON+data+source). Hope this helps!
Denodo Team
16-08-2022 06:18:11 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here