How to get the datatypes for the columns in a dataset | Community
Skip to main content
J
JohnYa5
Level 2
April 10, 2025
Solved

How to get the datatypes for the columns in a dataset

  • April 10, 2025
  • 2 replies
  • 395 views

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

Best answer by supratim320

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

2 replies

gautham_madala
gautham_madala
Level 5
April 13, 2025

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

    S
    supratim320Accepted solution
    Level 5
    April 15, 2025

    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

      Terms & ConditionsAccessibility statement

      Loading footer...