Hi... thanks for the video. request you to post a video using batch requests for json POST api using DSS (database procedures with parameters - inside the procedure we want to validate the input received and then call DB APIs to insert data to multiple tables) the parameters will be query parameters as well as resource parameters for example : call xx_test_wso2_proc(:p_data1, :p_data2) i tried with single set of parameters its working but is not working with batch requests am trying in postman
Hi,great tutorial and thanks for your help,from my side i have this Error in my postman response "The endpoint reference (EPR) for the Operation not found is /services/Ecole_DataserviceV3/getClasse/all and the WSA Action = null. If this EPR was previously reachable, please contact the server administrator" can you help me ? i havn't found a help on internet
codeur X from the description I feel like you are trying to access either an incorrect or non-existent endpoint. Which service are you trying to create? REST or SOAP? If you can share your code, I may be able to help you better
Hi,Thanks for the video, Please share video link with input parameter My Problem Explained below: I am using excel as Data Source and created Query as Given below Select ID, Model, Classification from Products where ID=:ID It's working good while invoke Rest Get Call from WSO2 EI Console however its giving error while invoking from PostMan Method: Get Content Type : application/xml Accept : application/xml Excel: has ID,Model,Classification Columns with GenericType Rest Get URL : //Products/ EX:-//Products/123_abc Reference Doc Link : docs.wso2.com/display/EI660/Exposing+Excel+Data+as+a+Data+Service Query Mode Enabled Error: DS Code: INCOMPATIBLE_PARAMETERS_ERROR Current Params: {}
Hi Manisankar, thanks for reaching out. While I would need your data service definition for a detailed analysis, I noticed something that might be of interest to you. I believe you are expecting a JSON response. If yes, the content-type need to be application/json. Additionally as the service is returning response when invoked from console, the error should be either around passing the parameter to the service or how the DSS retrieve the parameter In order to pass to the query
@@integrationcorner268 Hi, Thanks for your Reply Rest URL Used to Invoke : --------------------------------------- /services/DSSample.HTTPEndpoint/Products/abc_value Version : 6.4.0 Content-type : application/xml (I need xml response) This video showing Rest API Get method without Input Parameter ,and if you have any video with input parameter pls share the Link If you need more details to help me pls whatsup/call : +65-90453647 Email : manisankarmail@gmail.com Service Definition ---------------------------
select ID,Model,Classification from Sheet1 where ID = ?
Error: ----------- Error processing GET request for : /services/DSSample.HTTPEndpoint/Products/abc_valueDS Code: INCOMPATIBLE_PARAMETERS_ERROR Nested Exception:- javax.xml.stream.XMLStreamException: DS Fault Message: Error in 'CallQuery.extractParams', cannot find parameter with type:query-param name:id DS Code: INCOMPATIBLE_PARAMETERS_ERROR Source Data Service:- Name: Promemoria_PROMEMORIA_Tools Location: /Promemoria_PROMEMORIA_Tools.dbs Description: Tool per permettere ad Amenta di inserire le pratiche fatte a mano. Default Namespace: ws.wso2.org/dataservice Current Request Name: _getgetproduct_id Current Params: {}
Thanks!!
I have problem getting response from service. I get Failed to submit the response. Do you know where can be problem?
HI, Thanks for the tutorial. Can you please make a video on how to add documentum as a datasource in WSO2 EI and to get the content of a socument
hi,thanks
Welcome!
Hi... thanks for the video.
request you to post a video using batch requests for json POST api using DSS
(database procedures with parameters - inside the procedure we want to validate the input received
and then call DB APIs to insert data to multiple tables)
the parameters will be query parameters as well as resource parameters
for example : call xx_test_wso2_proc(:p_data1, :p_data2)
i tried with single set of parameters its working but is not working with batch requests
am trying in postman
Hi,great tutorial and thanks for your help,from my side i have this Error in my postman response "The endpoint reference (EPR) for the Operation not found is /services/Ecole_DataserviceV3/getClasse/all and the WSA Action = null. If this EPR was previously reachable, please contact the server administrator" can you help me ? i havn't found a help on internet
codeur X from the description I feel like you are trying to access either an incorrect or non-existent endpoint. Which service are you trying to create? REST or SOAP? If you can share your code, I may be able to help you better
@@integrationcorner268 i am trying to create a rest api
codeur X I think something is not proper. For REST api we shouldn’t see SOAPAction .. could you share your api ?
Hi sir.Even if i follow this steps completely i got xml response instead of json.How can i fix this.
can you try to send HTTP header "Accept" with value "application/json" in the request ?
@@integrationcorner268 thanks sir.It worked!
@@atlayesen4438 Always happy to help :-)
i have wso2ei-6.6.0
Hi,Thanks for the video,
Please share video link with input parameter
My Problem Explained below:
I am using excel as Data Source and created Query as Given below
Select ID, Model, Classification from Products where ID=:ID
It's working good while invoke Rest Get Call from WSO2 EI Console however its giving error while invoking from PostMan
Method: Get
Content Type : application/xml
Accept : application/xml
Excel: has ID,Model,Classification Columns with GenericType
Rest Get URL : //Products/
EX:-//Products/123_abc
Reference Doc Link : docs.wso2.com/display/EI660/Exposing+Excel+Data+as+a+Data+Service
Query Mode Enabled
Error:
DS Code: INCOMPATIBLE_PARAMETERS_ERROR
Current Params: {}
Hi Manisankar, thanks for reaching out. While I would need your data service definition for a detailed analysis, I noticed something that might be of interest to you. I believe you are expecting a JSON response. If yes, the content-type need to be application/json. Additionally as the service is returning response when invoked from console, the error should be either around passing the parameter to the service or how the DSS retrieve the parameter In order to pass to the query
@@integrationcorner268
Hi,
Thanks for your Reply
Rest URL Used to Invoke :
---------------------------------------
/services/DSSample.HTTPEndpoint/Products/abc_value
Version : 6.4.0
Content-type : application/xml (I need xml response)
This video showing Rest API Get method without Input Parameter ,and if you have any video with input parameter pls share the Link
If you need more details to help me pls whatsup/call : +65-90453647
Email : manisankarmail@gmail.com
Service Definition
---------------------------
org.h2.Driver
jdbc:h2:file:./samples/database/DATA_SERV_SAMP
wso2ds
wso2ds
select ID,Model,Classification from Sheet1 where ID = ?
Error:
-----------
Error processing GET request for : /services/DSSample.HTTPEndpoint/Products/abc_valueDS Code: INCOMPATIBLE_PARAMETERS_ERROR
Nested Exception:-
javax.xml.stream.XMLStreamException: DS Fault Message: Error in 'CallQuery.extractParams', cannot find parameter with type:query-param name:id
DS Code: INCOMPATIBLE_PARAMETERS_ERROR
Source Data Service:-
Name: Promemoria_PROMEMORIA_Tools
Location: /Promemoria_PROMEMORIA_Tools.dbs
Description: Tool per permettere ad Amenta di inserire le pratiche fatte a mano.
Default Namespace: ws.wso2.org/dataservice
Current Request Name: _getgetproduct_id
Current Params: {}