Dandy Ling Kwong
Posts: 0
Joined: Sat Jan 10, 2015 9:06 am

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

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

Alena Prykhodko
Posts: 0
Joined: Tue Apr 09, 2013 7:36 am

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

Hello Dandy,

We will check this and update the thread asap.

Alena Prykhodko
Posts: 0
Joined: Tue Apr 09, 2013 7:36 am

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

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.

Dandy Ling Kwong
Posts: 0
Joined: Sat Jan 10, 2015 9:06 am

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

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.

Return to “Issues”