Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

How to download data of a Dataset in csv file using API

Avatar

Level 1

Hi All,

 

Is there a way we can download a dataset in a .csv file using API?

 

As we can download it in parquet format.

 

Thanks

Gouri

5 Replies

Avatar

Level 2

Hi @gugun,

I'm not sure about API, but if you've SQL client connected with Query Service then from there you can export it in CSV format by querying your dataset, provided SQL client support export feature.

 

Regards,

Vikash

Avatar

Employee

Data Access API currently allows the file to be generated in a parquet format only. 

Avatar

Level 4

Hi @gugun ,

 

Did you try Data Access API - https://experienceleague.adobe.com/docs/experience-platform/data-access/api.html?lang=en?

 

Looking at the documentation i see it mentions about csv file format support as well (eg: profile.csv).

 

Thanks,

Chetanya

 

 

Avatar

Level 4

I was talking about this recently, if i'm not wrong it can be only in parquet format for now.  

tutorial here. 

https://experienceleague.adobe.com/docs/experience-platform/data-access/tutorials/dataset-data.html?...

Avatar

Community Advisor

Try with this API - 

https://platform.adobe.io/data/foundation/export/files/{FILE_ID}