ACL required to use Import SET API InsertMultiple method

[KrithikaV]

Hi,

In our integration, we push data through Import Set API's InsertMultiple method

When I give admin privilege to the integration account, the data is pushed easily. However, when I give 
create, read, write privileges to the import table, import_admin, snc_platform_rest_api_access, rest_service, import_transformer, I get the following error:

Operation Failed: com.glide.rest.domain.ServiceException: Operation Failed: com.glide.rest.util.GlideRecordValidator.checkForErrorOrThrowDefaultError(GlideRecordValidator.java:43) com.glide.rest.service.impset.InsertMultipleHandler.insertRecord(InsertMultipleHandler.java:283) com.glide.rest.service.impset.InsertMultipleHandler.insertRecords(InsertMultipleHandler.java:250) com.glide.rest.service.impset.InsertMultipleHandler.process(InsertMultipleHandler.java:132) com.glide.rest.service.impset.InsertMultipleHandler.process(InsertMultipleHandler.java:82)

What other ACL do I need to give this integration account?

[kaushal_snow]

Hi @KrithikaV ,

Your integration user must have the import_admin and import_transformer roles ( as well as rest_service and snc_platform_rest_api_access if strict REST security is enabled) and CRUD ACLs on both your staging tables (the sys_import_set_row descendant) and the system tables (sys_import_set, sys_rest_insert_multiple, and if using column-name mapping, sys_rest_insert_multiple_column_mapping),  otherwise the insertMultiple call returns a generic failure even if other roles are present..