Expense Report - Zoho Expense Data Target Requirement
DataBlend supports the standard API calls to Upsert Related Records within Zoho leveraging the Zoho SDK. In addition, custom fields can be added for data that is unique to your business practices.
|
DataBlend Query Object (SDK) |
Zoho Object (API) |
Required |
Notes |
|---|---|---|---|
| 8675309 | organization_id | Yes | |
| Example | report_name | Yes | |
| 123789231 | report_id | Yes | Unique ID for expense report generated by the server . This is used as identifier. |
| ER-00002 | report_number | No | |
| Submitted | status | No | Status of the report. Possible values can be draft or submitted or approved or rejected or reimbursed or recalled. |
| 2024-12-26 | approved_date | No | |
| This is an important report. | description | No | Description of the report. Applicable for Create only. |
| 2024-12-26 |
start_date
|
No | Required for Create Only. |
| 2024-12-29 |
end_date
|
No | Required for Create Only. |
| 16367000000088005 |
customer_id
|
No | Unique Id for the Customer. |
| 16367000000223045 |
project_id
|
No | |
| 16367000000223033 |
expense_id
|
No | |
| 0 |
order
|
No | Order of the expense in Report. |
| 16367000000277001 |
customfield_id
|
No |
Custom Fields related to Expense.
|
| Good |
customfield_value
|
No | Descriptor field |
|
Unique ID for Tag generated by the server.
|
tag_id
|
No | Required for Create Only. |
|
Unique ID for Tag option generated by the server.
|
tag_option_id
|
No | Required for Create Only. |
More questions about API requirements? Please visit the Zoho Expense API site https://www.zoho.com/expense/api/v1/expense-reports/#overview.