Skip to Content
0
May 24, 2018 at 06:33 AM

B1if HTTP Call Multiple URL parameters with SQL Atom

699 Views Last edit May 28, 2018 at 09:20 AM 2 rev

Hello Experts,

I am very new to B1if. We have an existing scenario which fetches all Items from the OITM Table. Now we have a requirement in which we need to filter the set of items depending on some URL parameters provided.

Following are the configurations and Test example of the existing Scenario.

1) Inbound Channel Config:

2) Final Transformation:

</xsl:template><xsl:template name="transform">
<xsl:attribute name="pltype">xml</xsl:attribute>
<GetProductList> 
<ProductList>    
<xsl:for-each
select="/vpf:Msg/vpf:Body/vpf:Payload[./@id='atom1']/jdbc:ResultSet/jdbc:Row">  
<row>          
<ProductCode>         
<xsl:value-of select="./jdbc:ItemCode"></xsl:value-of>      
</ProductCode>        
<ProductName>              
<xsl:value-of select="./jdbc:ItemName"></xsl:value-of>        
</ProductName>         
</row>    
</xsl:for-each>
</ProductList>
</GetProductList>        
</xsl:template></xsl:stylesheet>

3) Test Definition

4) Debug

5) SQL Inbound Document from the above debug

The problem is I cannot find the ItemCode value that is passed during testing in the SQL Inbound Document. I have followed all the steps mentioned in the Online help section of B1. I have also done extensive search on the community to find something near to this scenario but could not find one.

My idea is, to get the URL parameter in a variable and pass it to the SQL Call like below:

#SELECT ItemCode, ItemName FROM OITM WHERE ItemCode=’$ItemNo’

I would be very thankful if you can please show me the right path to pass multiple URL parameters to a scenario and use them in a SQL atom.

I know it may be a very simple thing but as I said earlier I am very new to this, thus any help is much appreciated.

Thanks a lot in advance.

Regards,

Paul

Attachments

debug.png (13.8 kB)