Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Due to some maintenance operations, stambia.org will be switched to read-only mode during the 13th November. It will be possible to read and download, but impossible to post on the forums or create new accounts. For any question please contact the support team.

Topic-icon Question JSON parameter for an SQLtoPArameter

More
25 Sep 2018 00:59 #1 by jruizfer28
jruizfer28 created the topic: JSON parameter for an SQLtoPArameter
Hello everyone,
I'm making a Process in order to be use as a Web Service. The idea is that the client send a JSON file as an input (as you can see in img1.png on the red square), after that i want to execute an SQLtoParameter component with a query (see img2.png) in order to return a row from the table. The problem is that, aparantly the query is not reonasign or there is asintaxys mistake in orden to invoke the paramater.

I hope somebody can help me.
Attachments:
More
25 Sep 2018 15:30 #2 by Thomas BLETON
Thomas BLETON replied the topic: JSON parameter for an SQLtoPArameter
Hello, the syntax used in img2.png to get the Json content does not exist in Stambia.
What you need to do is loading the json content to a temporary table, so that you can join it with the data table.
Loading the json content to a temporary table can be done with a standard mapping Json => Rdbms.