Help with Bulk Write API - Accounts Module with custom layout
We are trying to update our Accounts module via Bulk Write API for the first time, to test it we prepare a CSV file with only 2 records
Layout,id,IM_Balance,Ingram_Micro_Line_of_Credit
Zoho 3.0,1118734000025841001,1.000000,1.000000
Zoho 3.0,1118734000025841001,1.000000,2.000000
We have a custom Layout called Zoho 3.0, on the CSV we have the api names of custom fields of that custom layout.
We upload the file:
Then we try to create the job but we are getting INTERNAL_SERVER_ERROR:
Full Body of the request:
- {
- "operation": "update",
- "ignore_empty": true,
- "callback": {
- "url": "https://a2ktest.free.beeceptor.com",
- "method": "post"
- },
- "resource": [
- {
- "type": "data",
- "module": "Accounts",
- "file_id": "3743390000002547001",
- "field_mappings": [
- {
- "api_name": "Layout",
- "index": 0
- },
- {
- "api_name": "id",
- "index": 1
- },
- {
- "api_name": "IM_Balance",
- "index": 2
- },
- {
- "api_name": "Ingram_Micro_Line_of_Credit",
- "index": 3
- }
- ],
- "find_by": "id"
- }
- ]
- }
Are we missing something? how do you describe the layout on the CVS file?
Thanks for the help!