I want to create an script from API engine explorer to export app data into a csv file. Later I call these API scripts from python. I already made connection from python to API editor.
So my question is how to write an script from API engine explorer to export app data into a csv.
There is a method call "ExportData" which can be used to export data. But I believe there should be an step before to get the handle of the object I want to export and it's "qType" should be "GenericObject". Otherwise ExportData method can't be used. I also tried CreateSessionObject to before the ExportData to get the handle of the app. But not sure how it can be called to existing app.
{ "jsonrpc": "2.0",
"id": 2,
"method": "ExportData",
"handle": 2,
"params": [ "CSV_C", "/qHyperCubeDef", "CsvUTF8.csv" ]
}
Any advice with sample script really appreciate.