topic Re: Alteryx Server API: Can we read data generated by Alteryx workflow via Server API? in Alteryx Server Discussions

Alteryx Server API: Can we read data generated by Alteryx workflow via Server API?

Arti2893 — Sat, 09 Mar 2024 05:48:25 GMT

Hello Community,

I am calling Alteryx API to run the workflow through Power Automate Desktop.

I want to check if it is possible to get the data which is generated by my Alteryx Workflow through Alteryx Server API's?

Instead of saving the file with the output data, I want to pass data in JSON Format.

Re: Alteryx Server API: Can we read data generated by Alteryx workflow via Server API?

arunkumark_21 — Sat, 09 Mar 2024 13:07:57 GMT

Unfortunately, I donot think there is an endpoint for this.

I think the easiest way would be to use a python tool or a json build tool at the end and store the result to a txt file.

Re: Alteryx Server API: Can we read data generated by Alteryx workflow via Server API?

fmvizcaino — Mon, 11 Mar 2024 16:00:26 GMT

Hi @Arti2893 ,

You will have to use a set of endpoints to achieve this result, but it is possible.

Access Swagger. There you have access to all the endpoints available. You can find it on the question mark icon on your Gallery. https://help.alteryx.com/20231/en/server/api-overview.html#api-overview-6422959

You have to access the V1 endpoints on Swagger and you will see this list.

1. Run the workflow and return a jobID

2. Check if the workflow was successfully run and return the OutputID if any

3. Return the file

Best,

Fernando Vizcaino

Re: Alteryx Server API: Can we read data generated by Alteryx workflow via Server API?

Arti2893 — Tue, 12 Mar 2024 04:30:43 GMT

Hi @fmvizcaino ,

Thank you for your response. The above API will return the file, instead of file can we get output data in JSON format?

Re: Alteryx Server API: Can we read data generated by Alteryx workflow via Server API?

fmvizcaino — Tue, 12 Mar 2024 14:46:14 GMT

Yes, you have a json output. The response body shows a json file to be downloaded, but you will get the raw json data as a response.

Re: Alteryx Server API: Can we read data generated by Alteryx workflow via Server API?

Arti2893 — Wed, 13 Mar 2024 06:09:58 GMT

Thank you @fmvizcaino . I tried this in postman and I am getting json as response, exactly what I needed!
Thanks for your quick response

Re: Alteryx Server API: Can we read data generated by Alteryx workflow via Server API?

francoiscortezon — Fri, 14 Mar 2025 14:50:56 GMT

Hi @fmvizcaino ,

Thanks a lot for the 3 steps you described. I have implemented a workflow that is performing the 3 steps sequentially and it works...

Except when it fails half of the time because the 2nd step starts before the workflow on the server has finished to run :-)

Would you have a way to make sure to run the 2nd step only when the workflow has finished to run on the server? Should I make some kind of iterative macro that perform the 2nd step until it gets the status "Completed"? Or do you know of an easier way?

A quick hack I did is using a Throttle tool to wait some time before launching the 2nd step, but I want to create a generic tool that launches a workflow on the server and get the output back.

Thanks again for your help.

François

Re: Alteryx Server API: Can we read data generated by Alteryx workflow via Server API?

fmvizcaino — Fri, 14 Mar 2025 15:04:36 GMT

Hi @francoiscortezon ,

Your assumption is correct; you have to create an iterative macro to check the job status until it is completed.

Best,

Fernando V.

Re: Alteryx Server API: Can we read data generated by Alteryx workflow via Server API?

francoiscortezon — Fri, 14 Mar 2025 15:13:36 GMT

Thanks @fmvizcaino .

I am now giving a try at this macro (Python inside): Use the Alteryx Server API to Run Apps/Workflows F... - Alteryx Community.

It seems it has the advantage to tackle the next part of my need: passing input data to the workflow via API.

If I can't make it work, then I will go for the Iterative Macro approach.

Thanks again!

Re: Alteryx Server API: Can we read data generated by Alteryx workflow via Server API?

fmvizcaino — Fri, 14 Mar 2025 15:16:08 GMT

Hey @francoiscortezon ,

Use this tool here: https://help.alteryx.com/current/en/designer/tools/developer/server-api-tool.html

This one was created by Alteryx.

Best,

Fernando

Re: Alteryx Server API: Can we read data generated by Alteryx workflow via Server API?

francoiscortezon — Fri, 14 Mar 2025 15:29:32 GMT

Thanks @fmvizcaino. Yep, I have implemented your 3 steps logic with various methods:

- classic Download Tools

- the v3 API Macro Pack (Alteryx Server v3 API endpoints)

- and the Server API Tool that you just mentioned

None of these is able to tell or wait when the workflow on the server has finished to run.

I think it will be either Python or the Iterative Macro that will crack this one.