Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum
Suggested answer

Kingswaysoft SSIS data migration passing dynamic parameters in URL

Posted on by 5

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 .

Eg 

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

<Totalrecords> 100 </TotalRecords>

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.

      

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,313 Super User on at
    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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,584 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,864 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans