HTTPS Sender url parameters in SAP CPI

[Reddy4417]

Hi Team,

Good Day...

my scenario is we need to get data from DB to SAP, i am using JDBC adapter to connect the DB directly and able to connect successfully and fetch the data from DB by using get operation from SAP by using query select * from dbo.[Table_Name] .

now my concern is customer wants to fetch the data based on month and year (response has the filed as same mnth_year>202301</mnth_year> )dynamically like below.

can you please help to achive this from cpi end.

Thnks in-advance.

BR,

Chinnu

[Former Member]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html

Questions on how to draw responses from members? Check out this discussion on how to improve questions. https://groups.community.sap.com/t5/welcome-corner-discussions/advice-from-sap-champions-questions-a...

[Reddy4417]

Hi All,

Actually I need to pass Date field as Date = '2023-01-01' from postman when I capture the parameter in cpi it is converting as Date%20=%20%272023+01-01%27.can you please suggest how to overcome this.

Thanks in-advance.

BR,

Chinnu

[MortenWittrock]

Hi Chinnu

You can get at those query parameters using the built-in header called CamelHttpQuery. You need to parse its contents in a script and then construct your database query dynamically.

When constructing the query, be very mindful that you are not opening yourself up to SQL injection. I.e. verify that the format of the parameter is as expected; don't just concatenate strings to form a SQL query.

Regards,

Morten

[Reddy4417]

Hello Morten,

Thanks you your suggestion and time.

BR,

Chinnu.