Page 1 of 1

API express: How to refer to body json while writing SQL statement

Posted: Sat Jun 27, 2015 3:07 am
by Dandy Ling Kwong

My rest service update a field in my table given the primary key. How do I refer to the body json which carries the request parameter in the SQL statement?

Image

Image


API express: How to refer to body json while writing SQL statement

Posted: Mon Jun 29, 2015 2:11 pm
by Alena Prykhodko

Hello Dandy,

We will check this and update the thread asap.


API express: How to refer to body json while writing SQL statement

Posted: Tue Jun 30, 2015 12:56 pm
by Alena Prykhodko

Dandy,

You need to create parameter for body, the same procedure as with id.

prereportText=:parameterBodyName/pre

Then you will see its path in Query params

Then click Map
Parameter will appear in list and you will need to map it on parameter from request.


API express: How to refer to body json while writing SQL statement

Posted: Thu Jul 02, 2015 2:39 pm
by Dandy Ling Kwong

Oh, thank you. I thought that the create parameter is only for the primary key, and didn't know that I can create it for all the items in the response too.