How to query through an API and be able to obtain the fields of a table or dataset | Community
Skip to main content
E
EzequielCu
September 11, 2024
Solved

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

  • September 11, 2024
  • 1 reply
  • 926 views

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!!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by arijitg

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

1 reply

arijitg
Adobe Employee
arijitgAdobe Employee
Adobe Employee
September 12, 2024

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

    E
    EzequielCuAuthor
    September 13, 2024

    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.

    arijitg
    Adobe Employee
    arijitgAdobe EmployeeAccepted solution
    Adobe Employee
    September 16, 2024

    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

      Terms & ConditionsAccessibility statement

      Loading footer...