Use Parameter From HTTP CALL ON SQL CALL (B1if)

[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.

[HuanYang]

Hello,

Please refer to the following screenshots.

Thanks & best regards

Huan Yang

[HuanYang]

Hello,

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

thanks & best regards

Huan Yang

[former_member416544]

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,

[saravanan_palani]

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