How to get the datatypes for the columns in a dataset

Question

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

supratim320 · Accepted Answer

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

gautham_madala · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO