How can we invoke REST API to get incremental changes using startDate and endDate query param

[Community_User]

Originally posted on September 23 2021 at 11:30 UTC

Hi Team,

We are using REST connector to integrate with Application and looking for a way to invoke REST API to get incremental changes using startDate and endDate query param, How can we pass query param values like startDate= lastExecutionTime, endDate=currentDateTime. Also can we invoke two REST API calls in a REST importUserJSON? Can we pass the unique id reqtrieved in call1 to call2 as a input param?

Thanks,

Siva

[Community_User]

Originally posted on September 24 2021 at 06:02 UTC

Hi Team,

Please provide any update on this Ticket.

Thanks,

Siva

[Community_User · Accepted solution]

Originally posted on September 24 2021 at 18:37 UTC

Siva,

The ImportUserJSON in REST connector supports multiple calls but using input from the first call to successive calls or iteration of successive calls using users pulled from the first call is also not supported right now. 

It also does not support incremental imports.

Regards,

Avinash Chhetri

[Community_User]

Originally posted on September 27 2021 at 10:57 UTC

Hi Avinash,

This is the correct format for ImportUserJSON - Multi Calls.

Please confirm me once.

{

  "call": [

    {

      "name": "call1",

      "connection": "userAuth",

      "url": "<REST API 2 URL>",

      "httpMethod": "GET",

      "httpHeaders": {

        "Authorization": "${access_token}",

        "US-Customer-Api-Key": "<CUSTOMER API KEY>"

      },

      "colsToPropsMap": {

      },

      "pagination": {

        "nextUrl": {

          "nextUrlPath": "${headers?.Link?.split(',')?.size()==2?headers?.Link?.split(',')[1]?.replace('<', '')?.replace('>; rel=\"next\"','')?.trim():headers.Link.split(',')[2].replace('<', '').replace('>; rel=\"next\"','').trim()}"

        }

      }

    },

    {

      "name": "call2",

      "connection": "userAuth",

      "url": "<REST API 2 URL>",

      "httpMethod": "GET",

      "httpHeaders": {

        "Authorization": "${access_token}",

        "US-Customer-Api-Key": "<CUSTOMER API KEY>"

      },

      "colsToPropsMap": {

      },

      "pagination": {

        "nextUrl": {

          "nextUrlPath": "${headers?.Link?.split(',')?.size()==2?headers?.Link?.split(',')[1]?.replace('<', '')?.replace('>; rel=\"next\"','')?.trim():headers.Link.split(',')[2].replace('<', '').replace('>; rel=\"next\"','').trim()}"

        }

      }

    }

  ]

}

Regards,

Sivamurthy

[Community_User]

Originally posted on September 27 2021 at 19:28 UTC

Hi Sivamurthy,

These seem to look correct based on what I see.

Regards,

Avinash Chhetri

[Community_User]

Originally posted on September 28 2021 at 23:53 UTC

Hi Sivamurthy,

The documentation on Ultipro has some samples on the using multiple calls in ImportUserJSON.

Here's the link  : https://saviynt.freshdesk.com/support/solutions/articles/43000435612-ultipro-connector-guide