How to get the datatypes for the columns in a dataset

[JohnYa5]

How can programmatically get the datatypes and columns of a dataset or table in Experience Platform?

[gautham_madala]

You can you use the AEP Api and run the curls scripts that adobe provides from github collection in postman and check if it will work for your usecase

[supratim320 · Accepted solution]

To add the document link on top of @gautham_madala 's point, here you go: url

In the request you have to pass the datasetId as the input parameter along with an extra query parameter as "properties" with value="observableSchema".

Final url will look like: https://platform.adobe.io/data/foundation/catalog/dataSets/<datasetId>?properties=observableSchema

And then loop through the response.

Please note:

this process works based on the "preview dataset". If you have added a new column in the schema, but that column do not have the data yet, this response will not show up in the response