Hi,
My Intention : To create an Denodo REST service with POST method for inserting data to Oracle through denodo service.
I've already created Denodo derived view (Updateable) and exposed REST API which has only 3 attributes INSRD_NM, INSR_NM_MOD, STAGE
https://<<Server:Port>>/CUST_GROUP/views/CUST_GROUP
Also, IN webservices, resources tab, made all attributes as part of Input & Output with Authentication as "None" and default representation As JSON.
I'm able to retrieve data in json format even with input parameters for specified Name.
Tried following to create a service with POST method
----------------------------------------------------------------------
1. Created JSON as data source and specified URL (as above) and method as POST
2. Enabled proxy in the proxy tab
3. Add below as POST body
\{
"INSRD_NM": "<<Name>>",
"INSRD_NM_MOD": "<<Modified Name>>",
"STAGE": <<Stage #>>
\}
4. I also tried with this URL https://<<Server:Port>>/CUST_GROUP/views/CUST_GROUP?INSRD_NM=karthik&INSRD_NM_MOD=karthik&STAGE=3
5. I also tried with this
\{
"INSRD_NM": "@INSRD_NM",
"INSRD_NM_MOD": "@INSRD_MOD_NM",
"STAGE": "@STAGE"
\}
Some how I couldn't succeed. Getting HTTP 503 error with Proxy. I could able to save the jsonsource without proxy, but getting error while creating base view. But, getting error as "Unable to Obtain Data Structures"
Let me know if any additional information is required. Also, how does Denodo
Kindly help!!
Regards
