Post reply

URL coming from variable

  • January 19, 2017 at 9:43 am

    #317562

    In SSIS how do I use the URL as a variable where THE ID1 comes from the database one at a time  and the rest are constant
    https://www.MYAPI.com/api/v3/folders/ID1/tasks?&fields=%5B"parentIds","superParentIds","subTaskIds","responsibleIds","description","recurrent","authorIds","attachmentCount","hasAttachments","customFields","superTaskIds","metadata"]&descendants=false

    I just need to insert data into table and then use the next ID and so on .

    Thanks,
    PSB

  • January 19, 2017 at 10:18 am

    #1923782

    PSB - Thursday, January 19, 2017 9:43 AM

    In SSIS how do I use the URL as a variable where THE ID1 comes from the database one at a time  and the rest are constant
    https://www.MYAPI.com/api/v3/folders/ID1/tasks?&fields=%5B"parentIds","superParentIds","subTaskIds","responsibleIds","description","recurrent","authorIds","attachmentCount","hasAttachments","customFields","superTaskIds","metadata"]&descendants=false

    I just need to insert data into table and then use the next ID and so on .

    Thanks,
    PSB

    Create a variable with an Expression. Set the Expression to 
    "[First bit of URL]" + ID1 + "[second bit of URL]"

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply