CODEWITHSUNDEEP
azureazure-data-factoryalteryx
CodeMonkey
CodeMonkey

Reputation: 477

Azure Data Factory to call on-prem Alteryx API

I need to start a job in Alteryx (on-prem) from an ADFv2 pipeline and can't find a way to do so. The built in Web activity doesn't seem to support OAUTH 1.0 signature process that Alteryx requires. When trying to configure, I always get the error "Error calling the endpoint". I've tried using the Web Activity + HTTP Linked Service and can't figure out the correct way to do this. I need to do a POST (start job) and a GET (get job status) to an on-prem Alteryx API and I'm not even sure which activity is the best activity to do this.

Upvotes: 0

Views: 821

Answers (2)

user3780030
user3780030

Reputation: 81

I opened a ticket with Microsoft, and this was the response:

Currently the web activity can only run in ADF web role, not IR. This means the web activity does direct calls from the Azure servers to the end points, and is not capable of doing so through a self-hosted IR.

Upvotes: 0

fgbaezp
fgbaezp

Reputation: 476

U're right: web activity doesn't support more complex scenarios than just a simple request, and linked service doesn't support oAuth 1.0 auth.

From my point of view you're gonna have to extract the signature process that oAuth 1.0 requires. You could do one of the two:

  • Use a custom activity where u're going to code the signature process and also call your Alteryx job.

  • Use something like an Azure Function to do the signature process and call your job. And then use the web activity to call your function (it's like calling a normal api with some custom headers for auth).

Hope it helps.

Upvotes: 1

Related Questions