Don't get Bulk Write API to work

Don't get Bulk Write API to work

Hi everyone,

I'm facing current problem.
I have csv files (+500 row) which I push into a custom module (each row is one entry).

I thought its a good idea to use the Bulk Write API (https://www.zoho.com/crm/developer/docs/api/v6/bulk-write/overview.html)

Uploading of the file was easy but I don't get the 2. step "WriteCreate Bulk Write Job" to work.bulk. I always get this error code
{"code":"INVALID_REQUEST","details":{},"message":"unable to process your request. please verify whether you have entered proper method name, parameter and parameter values.","status":"error"}


Here my code:
  1. //uploadZip is the invoke of https://content.zohoapis.com/crm/v6/upload
  2. fileID = uploadZip.get("details").get("file_id");

  4. bulkMap = Map();
  5. bulkMap.put("operation","insert");
  6. bulkMap.put("ignore_empty",true);
  7. resourceList = List();
  8. resourceMap = Map();
  9. resourceMap.put("type","data");
  10. moduleMap = Map();
  11. moduleMap.put("api_name","CustomModuleXYZ");
  12. resourceMap.put("module",moduleMap);
  13. resourceMap.put("file_id",fileID);
  14. fileNameList = List();
  15. fileNameList.add(filenname);
  16. resourceMap.put("file_names",fileNameList);
  17. fieldMappingList = List();
  18. importDateiNameMap = Map();
  19. importDateiNameMap.put("api_name","Name");
  20. importDateiNameMap.put("index",0);
  21. fieldMappingList.add(importDateiNameMap);
  22. gridSupplyMap = Map();
  23. gridSupplyMap.put("api_name","FieldX");
  24. gridSupplyMap.put("index",16);
  25. fieldMappingList.add(gridSupplyMap);
  26. gridWithdrawalMap = Map();
  27. gridWithdrawalMap.put("api_name","FieldY");
  28. gridWithdrawalMap.put("index",17);
  29. fieldMappingList.add(gridWithdrawalMap);
  30. usageMap = Map();
  31. usageMap.put("api_name","FieldZ");
  32. usageMap.put("index",18);
  33. fieldMappingList.add(usageMap);
  34. ownerConsumptionMap = Map();
  35. ownerConsumptionMap.put("api_name","FieldXY");
  36. ownerConsumptionMap.put("index",20);
  37. fieldMappingList.add(ownerConsumptionMap);
  38. pvEnergyMap = Map();
  39. pvEnergyMap.put("api_name","FieldXZ");
  40. pvEnergyMap.put("index",64);
  41. fieldMappingList.add(pvEnergyMap);

  43. //default field values link to the related file upload
  44. dataImportMap = Map();
  45. dataImportMap.put("api_name","LookupField1");
  46. dataImportMap.put("find_by","id");
  47. dataImportDVMap = Map();
  48. dataImportDVMap.put("value",dataImportID);
  49. dataImportMap.put("defaultValue",dataImportDVMap);
  50. fieldMappingList.add(dataImportMap);

  52. resourceMap.put("field_mappings",fieldMappingList);
  53. resourceList.add(resourceMap);
  54. bulkMap.put("resource",resourceList);
  55. info "bulkMap: " + bulkMap;
  56. createBulkAction = invokeurl
  57. [
  58.       url :"https://www.zohoapis.eu/crm/bulk/v6/write"
  59.       type :POST
  60.       parameters:bulkMap
  61.       connection:"bulkconnection"
  62. ];
  63. info "bulk:" + createBulkAction;

Does someone has an idea how to solve my problem

Best
Markus