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]"

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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