Skip to Content
avatar image
Former Member

Use Parameter From HTTP CALL ON SQL CALL (B1if)

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

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

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 05 at 02:49 AM

    Hello,

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

    thanks & best regards

    Huan Yang

    Add comment
    10|10000 characters needed 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,

  • Jul 13 at 10:44 AM

    Hello,

    Please refer to the following screenshots.

    Thanks & best regards

    Huan Yang

    Add comment
    10|10000 characters needed characters exceeded