Query Parameters for a Rest API

Bill Bird 81 Reputation points
2020-09-30T23:53:03.07+00:00

Hello,
I have a vendor who has an API with "query parameters" but I can't get Azure to use them. This is what I tried;

  1. in the upper left you will see the vendors definition for the API
  2. the two images to the left show two different ways I tried to introduce the parameters with no success

If I can just edit the curl I would be set...so maybe my question is how to I do that instead of trying to use this GUI to key this in

29535-image.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,082 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Anonymous
    2020-10-01T17:37:09.787+00:00

    There are size and time limits (httpRequestTimeout) as to what Data Factory will accept for any response, regardless of how many records are returned. The first thing to keep in mind is if you have a very large API response, ADF may not read in all of it.

    The built-in paging support has some caveats, in that the API you're calling must emit which are detailed at:
    https://learn.microsoft.com/en-us/azure/data-factory/connector-rest#pagination-support

    There are some solutions in another thread - https://social.msdn.microsoft.com/Forums/en-US/ab9faec5-8e08-467c-86b4-0072b871985b/unable-to-use-the-pagination-rules-in-rest-sources-in-adf?forum=AzureDataFactory

    But these may not work for you depending on the format of the API you're calling

    0 comments No comments