Export data
export_dataRuns an Export Data job definition of the connected application (name from list_job_definitions) and returns the exported rows in one step: submit the job, wait for it, download the zip from the outbox, extract it and parse the csv. rowMembers, columnMembers and povMembers narrow the export the way the job definition allows; where keeps only the rows whose columns contain given text (for example a year in the Point-of-View column) and columns picks the columns to return. Large results are paged with offset and maxRows under the policy's cell limit, and nextOffset says where the next page starts. If the job is still running when waitSeconds is over, the result says so with the job id and file name to follow up with check_job_status and download_file. Use it to pull actuals, plan or forecast data for a whole cube region without building a grid.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"jobName": "<jobName>"
},
"name": "export_data"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| entry | No | Name of the file inside the zip to read, from the entry list. Defaults to the only entry, or the largest csv/txt. | |
| where | No | Keep only rows whose column contains the text, case-insensitive, e.g. { "Point-of-View": "FY24", "Account": "4310" }. Paging, totalRows and nextOffset then count the matching rows. | |
| offset | No | Data rows to skip before the first returned row (default 0). Use nextOffset from the previous result to page. | |
| columns | No | Columns to return, in this order, e.g. ["Account", "TP1", "Point-of-View"]. Defaults to every column. | |
| jobName | Yes | Export Data job definition name, exactly as list_job_definitions shows it, e.g. NSP_NFS_All_Data_Export | |
| maxRows | No | Rows to return per call (default 200, at most 2000). The policy cell limit can lower it. | |
| connection | No | Connection id or label from list_connections. Defaults to the user's default connection. | |
| povMembers | No | Point of view override as Oracle's povMembers parameter, e.g. NSP_Actual,FY24,Subsidiary | |
| rowMembers | No | Row members override as Oracle's rowMembers parameter, e.g. ILvl0Descendants(Account) | |
| application | No | Application name. Defaults to the connection's application. | |
| waitSeconds | No | Seconds to wait for the job before handing back the job id (default 120, at most 300) | |
| columnMembers | No | Column members override as Oracle's columnMembers parameter, e.g. TP1,TP2,TP3 | |
| exportFileName | No | Outbox file name for the export. Defaults to <jobName>_claude.zip. |