How to call API using dynamic URL / Body in SSIS Web API Destination

In this post, we will learn How to call API endpoint using Dynamic URL in SSIS Web API Destination.

For example, you are reading Customers from one endpoint and passing that Customer Information to another Endpoint to get Details using SSIS?

Option-1: Pass URL / Body / Header from Upstream Column

The first method is choosing the Upstream column to make things dynamic at runtime.

Let's say you have Url or Body coming from Upstream then you can choose it like below

Option-2: Using Column Placeholders in Body, URL, Header

You can pass upstream column value directly in your URL, Body or Header as below. To refer for complete function list check this link

<%MyColumnName%>
-- OR --
<%ColumnName,FUN_SOME_FUNCTION%>

Examples

(use in URL)

https://myurl/?name=<%CompanyName%>
https://myurl/?name=<%CompanyName,FUN_URLENC%>
https://myurl/?name=<%CompanyName,TO_UPPER%>

(use in BODY)

{
name: "<%CompanyName,FUN_JSONENC%>"
}

Contact Us

If you have more question(s) feel free to contact us via Live chat or email at [e-mail]

https://zappysys.com/support/