Search code examples
azure-data-factorysquare-connect

Azure Copy Activity Rest Results Unexpected

I'm attempting to pull data from the Square Connect v1 API using ADF. I'm utilizing a Copy Activity with a REST source. I am successfully pulling back data, however, the results are unexpected.

The endpoint is /v1/{location_id}/payments. I have three parameters, shown below. Parameters

I can successfully pull this data via Postman.

enter image description here

The results are stored in a Blob and are as if I did not specify any parameters whatsoever.
enter image description here

Only when I hardcode the parameters into the relative path enter image description here

do I get correct results.

enter image description here

I feel I must be missing a setting somewhere, but which one?

Solution

  • You can try setting the values you want into a setVariable activity, and then have your copyActivity reference those variables. This will tell you whether it is an issue with the dynamic content or not. I have run into some unexpected behavior myself. The benefit of the intermediate setVariable activity is twofold. Firstly it coerces the datatype, secondly, it lets you see what the value is.

    My apologies for not using comments. I do not yet have enough points to comment.