export content.search results to excel

Question

how do i export the results of the search to excel?  In the export i would want username, modified date, created date and view count

import arcgis
from arcgis.gis import GIS

portal = "https://xyz"

gis = GIS(portal, "username", "password", verify_cert=False)
print ("Connected")

items = gis.content.search(query="owner: s*",item_type='', sort_field="numViews", sort_order= "asc", max_items=5000, outside_org=False)
for item in items:
 display(item)

NathanBaier1 · Answer

I am struggling to make the table actually display the dates in the proper format using your code. I'm new to python coding and still learning. How would you take the output of the above code and place it into the code for the output table?

Raj-Chavada · Answer

Thanks, Mehdi Pira‌! I am no expert at ArcGIS API for Python. Forgive me for silly question. Can you confirm where exactly I need to insert this function in the for loop and how I can get the updated date printed in the excel file? Thank you so much for your help..

MehdiPira1 · Answer

Adityaraj Chavada‌ The function below does the trick: import datetime def modifiedTime(index, dataframe): ts = dataframe.iloc[index].created/1000 convertedTime = datetime.datetime.utcfromtimestamp(ts).strftime('%Y-%m-%d %H:%M:%S') return convertedTime‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ This can be included in the for loop to convert the unix time. This is for the 'created' column. Same can be applied to the 'modified' column too.