Rest Service Post Method - How to pass multiple input parameters?

[cm.kumar]

Hello,

I have a stored procedure defined in VDB, which is enabled to get deployed as rest service (war).

Stored procedure gets 3 input parameters and is defined to use rest method as http'Post'.

I'm trying to test this rest service using PostMan, where I pass the input parameters in Body as form-data. But the input parameters are not getting passed into the stored procedure.

Let me know, what I'm doing wrong.

Post URL - http://serverName:8080/AppConfig_1/Config/scg

Input parameter passed in body,

{

"userConfig":"test",

"confId":"10",

"userId":"testUser"

}

Stored procedure defined in the VDB,

SET NAMESPACE 'http://teiid.org/rest' AS REST;

CREATE VIRTUAL PROCEDURE SetUserConfig(IN userConfig string, IN confId string, IN userId string)  OPTIONS (UPDATECOUNT 0, "REST:METHOD" 'POST', "REST:URI" 'scg')

AS

BEGIN

DECLARE integer collection_id = 4 ;

INSERT INTO app_user_config(id, config_name, config_value, collection_id, user_id) VALUES (AppConfig.nextval('app_uconfig_id_seq'),confId, userConfig, collection_id, userId);

END

[rareddy]

Read about "post" methods here REST Service Through VDB · GitBook

An example of FORM based call HTML form method Attribute

The way you are doing above in your example is like single Payload, Teiid does not support any parsing capabilities on top of Payload into their respective parameters, that needs to be consumed as is, then if you want you can parse them in your stored procedure into respective parameters. See also how to do multipart/form-data html - What does enctype='multipart/form-data' mean? - Stack Overflow

[cm.kumar]

Ramesh,

Further to make myself clear, i'm having 3 parameters in my SP and I'm passing 3 parameters as form/data to call the rest service via post method.

Are you saying, I should have only one parameter in SP (which is like xml) and parse it in SP to get individual parameters and do what is needed?

Thanks.

[rareddy]

What I am saying is currently the auto-generated REST War from VDB in Teiid only accepts the "FORM" based post, and if one of the parameters large like file then you need to use multipart-form. Look at above examples to see how the payload need to be constructed. In FORM based payloads the web frameworks convert the payload into individual parameters as in GET call. You can send more than one parameter. If you want to send a single JSON document, then I suggest configuring your procedure that takes a single clob/blob then parse the contents.

Ramesh..