Expand my Community achievements bar.

SOLVED

How to query through an API and be able to obtain the fields of a table or dataset

Avatar

Level 1

I want to make a python application, and query an Adobe API, that returns the contents of a dataset or table to me. If this is not possible, I would like to obtain from an API the result of the execution of an already created query, that is, the fields that contain the dataset.  Thank you!!

1 Accepted Solution

Avatar

Correct answer by
Moderator

Hi @EzequielCu 

 

Not sure which data you meant by "cannot obtain the necessary data". If it is query service credential you are unable to obtain you can use Query Service API (adobe.com) endpoint or from UI you can browse to Data Management > Queries > Credentials. If it is the dataset output then you can check your syntax and error details that you face.

 

Regards,

Arijit Ghosh

View solution in original post

3 Replies

Avatar

Moderator

Hi @EzequielCu 

 

There are no API as such but a workaround would be to connect to query services via Python and store the output of your dataset query to a dataframe to use further. I think below thread would help you solve your use case.

 

Ref : Solved: Connect from Python to AEP Query services - Adobe Experience League Community - 613004

 

Regards,

Arijit Ghosh

Avatar

Level 1

Thank you so much!
I am needing more information, because I cannot obtain the necessary data. I would like to see an example, even if it is how to hit an API that returns this information to me.

Avatar

Correct answer by
Moderator

Hi @EzequielCu 

 

Not sure which data you meant by "cannot obtain the necessary data". If it is query service credential you are unable to obtain you can use Query Service API (adobe.com) endpoint or from UI you can browse to Data Management > Queries > Credentials. If it is the dataset output then you can check your syntax and error details that you face.

 

Regards,

Arijit Ghosh