0 Replies Latest reply: Oct 29, 2018 1:39 PM by Den Mak RSS

    Export an app data from API engine

    Den Mak

      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.