Hi @Kumar_Saurabh_ - our company doesn't allow psql on our machines. Is there a sql query that I can use to directly convert the outputs in the query service UI? Thanks!

When using the QueryService in AEP, I realized that the timestamp is only showing datetime format as "05/08/2023, 3:10 PM".What would be the correct SQL to make the results show the seconds as well? ("05/08/2023, 3:10:54 PM") 

Thanks Madhan! This was helpful. One follow up question: AEP does not offer a direct way to fetch the most recent dataset through their APIs-> Does this require Data Distiller or Query Service for us to fetch the most recent dataset through APIs?

I am connecting to the AEP API to view/download datasets via Jupyter Notebooks. It seems like the reporting api is working, but I can only view/download the dataset by batch id. Is there a way to simply view/download the current most recent dataset? 

Hi all,We've been trying to pull data from CJA through the API.After some difficulty we were able to access some stuff like data views, dimensions, and metrics but we are unable to request anything from the /reports end point.Example of requests:res = requests.get("https://cja.adobe.io/data/dataview...