Connect from Python to AEP Query services

[sheejo]

@everyone 

Anyone tried to connecting from Python to AEP Query services to pull the data?

If yes, please share the sample code snippets.

Thanks

Sheejo

[arpan-garg]

Hi @sheejo - Yes we did it, we were downloading the data present in the dataset to an external system.

What's your usecase?

[EzequielCu]

Thanks for the information, I would like to see an example of how you obtain the information, I would also like to know what the api is that returns the file, and how it searches for the files.

thank you so much

[arijitg · Accepted solution]

Hi @sheejo 

There are utilities like psycopg2 

psycopg2.connect(database='<database_name_here>', user='<user_name_here>', password='<password_here', host='<host_here>', port= '<port_here')

** since it's an open source and not managed by Adobe you shall consult with your Architect & Security professionals before using.

[sheejo]

@arijitg , I am able to connect to AEP Query services and able to pull the data. Thank you all!.

[Mahesh_Srini]

@sheejo, Could you let me know how you did it.(the process)