On this Page
| Table of Contents | ||||
|---|---|---|---|---|
|
Snap type: | Write | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Description: | This Snap exports reports as a file to an Expensify account and displays the file content in the output.
| |||||||||||||
| Prerequisites: | [None]. | |||||||||||||
| Support and limitations: | Ultra pipelines: Works in Ultra Pipelines.Spark mode: Not supported in /wiki/spaces/SD/pages/1437917 mode | |||||||||||||
| Account: | This Snap uses account references created on the Accounts page of SnapLogic Manager to handle access to this endpoint. See Expensify Account for information on setting up this type of account. | |||||||||||||
| Views: |
| |||||||||||||
Settings | ||||||||||||||
Label | Required. The name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your pipeline. | |||||||||||||
Template | Required. Freemarker template used to format the exported data. Please refer this link on how to create template for Expensify export report Snap. | |||||||||||||
|
| |||||||||||||
Supported Attributes for Export Report operation
The details about attributes to be passed as input for export report operation can be found at following link: create report attributes.
Examples
JSON for Exporting Report
| Code Block |
|---|
{
"onReceive":{ "immediateResponse":["returnRandomFileName"] },
"inputSettings":{ "type":"combinedReportData", "reportState":"REIMBURSED", "limit":"10", "filters":{ "startDate":"2014-01-01", "endDate":"2014-02-01", "markedAsExported":"Expensify Export" }, "employeeEmail":"user@domain.com" },
"outputSettings":{ "fileExtension":"xls", "fileBasename":"myExport" },
"onFinish":[ { "actionName":"markAsExported", "label":"Expensify Export" }, { "actionName":"email", "recipients":"manager@domain.com", "message":"Your report is ready." } ] } |
See Also
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|