How to export dataset through API from Aperture Data studio?
Hello All
I want to export one dataset in Experian through API and save it as csv file in my one drive.
Dataset exists in space which created by me, let say space name is "To_Test". In this space i enabled the "Allow publishing OData" option.
I generated the API key and tested the API in swagger UI and tested on "Retrive Dataset" API underset datset operation.
In result, it shows only table name and column name details. I didn't get actual data. i.e. all the rows(records) in the dataset.
Can someone please help me to get done this?
Comments
-
A Dataset is a container for batches of data, but is not actually the data itself. To use OData there is a different API permission:
You mention wanting a CSV specifically, in which case using a Workflow to Export the data into a file would possibly be way to go.0 -
@Josh Boxer Thanks for the support
I tried export step in workflow with SFTP server as destination and it works. But we required that we need to export the data into OneDrive or OCI bucket. since we don't have Azure Blob storage or Amazon S3.
Is that possible in anyway?0
