Kingswaysoft SSIS data migration passing dynamic parameters in URL

(0) Share

Report

Posted on by Anubhab Das

Hi Folks,

I am trying a scenario where i need to migrate a huge xml data from a api endpoint . I want to change the start and end parameters dynamically to fetch the data .

1st iteration increment by 4

https:// xyz.com ? start =1 & end = 5

Fetch data and insert into CRM

2nd iteration increment by 4

https:// xyz.com ? start =6 & end = 10

Fetch data and insert into CRM

3rd iteration increment by 4

https:// xyz.com ? start =11 & end = 15

Fetch data and insert into CRM

Can someone tell how can this be achieved ?

Also in the XML payload i have the total number of records : eg

Can i somehow read this record and adjust the start & end parameters by doing incremental batches of 5 or 10 or 15 etc

I am vey new to this so any pointer or guidance is much appreciated.

All responses (1)

Answers (0)

Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

RE: Kingswaysoft SSIS data migration passing dynamic parameters in URL

Hello,

I would recommend using For Loop to implement the cycle - www.mssqltips.com/.../

In regards to XML payload, I would recommend using XML Extract component of KingsWay soft since you use is - www.kingswaysoft.com/.../xml-extract