REST API : getting the result of a workflow in the REST api response

Slimani

Hi dear community,

Would it be possible to get the workflow result in the RESt webservice call ?

In orther words we want to execute the reunning of a workflow through a rest web service, then we get in its response the result (it can be a file or a content of the report in JSONformat)

Thanks in advance for your reponse

Best regards

Ali

Josh Boxer

Hi Ali

You can execute a Workflow via an API https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/extend-data-studio-functionality/use-the-rest-api/#execute-and-manage-workflows

The Export step provides a file, which could be picked up programmatically from the location it is saved to.

OData can make a Snapshot available in another application via API https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/prepare-and-move-data/use-odata/

Lastly Data Studio has an SDK https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/extend-data-studio-functionality/use-the-sdk/ which can be used to write a custom Workflow step to push data via an API in a specific format to a specific application.

Slimani

thank you for your response Josh,

Is it possible to create a dataset data and fill it using API

I've found somehting interresting:

https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/extend-data-studio-functionality/use-the-rest-api/#create-and-manage-datasets
section : Create a Dataset

in the same link we have:

section : upload files

My question is,: can we use such api to upload a xlsx or a csv files and put it into a dataset data ?

Thanks a lot for your help

Best regards

Ali

Josh Boxer

Hi Ali

Yes you can use the Upload file API to load a CSV and get a 'fileKey' then use that value to call the Create Dataset API

{

"datasetName": "CSVdelete",

"externalLabel": "CSVdelete",

"space": "Challenges",

"fileKey": "0d9c2127-0d11-4867-b268-4fff9fb36ebe"

}

You can test this using the Swagger UI https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/extend-data-studio-functionality/use-the-rest-api/

Slimani

Thank you Josh

It works

Best regards