Skip to Content
0

Use Parameter From HTTP CALL ON SQL CALL (B1if)

Feb 27 at 02:27 PM

86

avatar image
Former Member

Hi everyone,

I am working on creating a scenario triggered by an HTTP Call to display the result of an sql query in a web page , my need is to use a parameter from my HTTP Call like (CardCode). (It's work well without parameter)

My scenario is very basic :

SQL Statement : i don't know where to get my parameter

Inbound -> Channel :

Can anyone please Help me.

scenario.png (32.6 kB)
inbound.png (22.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member May 14 at 09:16 AM
0

Hi Mounir Ahanguir,

I'm facing exactly the same problem. Did you get any luck on this. Kindly share if you have found a way to solve this issue.

Thanks in advance.

Regards,

Saran

Share
10 |10000 characters needed characters left characters exceeded
Huan Yang
Jul 05 at 02:49 AM
0

Hello,

You may use a predecessor XSL transformation to define the SQL statement.

thanks & best regards

Huan Yang


sqlcall.jpg (134.8 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Huan Yang,

While I'm exciting with follow your steps , I'm simply return query only 'SELECT CARDCODE FROM OCRD WHERE CARDCODE=4'.

Here actually, I'm looking for query result, I mean <SQLStatement>4<SQLStatement>.

can you please suggest me, how to get query result in XSLT file.

Thanks,

0
Huan Yang
5 days ago
0

Hello,

Please refer to the following screenshots.

Thanks & best regards

Huan Yang


sqlresult.jpg (199.2 kB)
Share
10 |10000 characters needed characters left characters exceeded