REST Import set API response message is empty

sridhar722
Mega Contributor

We are in Fuji. I have created Import set web service and transform map with Coalesce filed. User I am using has Rest_service, importset_admin, importset_loader and all the roles needed for it. I created ACL to read and write to this table by this user. Everything is working fine but not receiving response. When I use admin account, I am getting the correct response. Can anyone faced this issue before. Really appreciated your help

Thanks

11 REPLIES 11

sethb
Kilo Contributor

I am having the same issue, my POST is successful, but my response is empty. Did you figure out if this was an ACL issue or missing role?


I have something similar, yesterday I have created an incident on Hi because I found https://hi.service-now.com/kb_view.do?sysparm_article=KB0596738



But when I started this morning with fresh eyes, I opened my "stage import" table (the one extending sys_import_set_row) and I found my records from yesterday but without the import_set reference field.


So I'm now investigating why the field import_set isn't fulfilled when I don't have the admin role (highly probably ACL)


Thanks for that info, gave me a good start.



When I looked at this I found I had to give the user the import_transformer role for it to return a non-blank response. Might be worth trying the same.


I had the same issue and it was Import_transformer role. Thanks for the tip Tim.


Christos
Tera Contributor

Hi @emyrold 

Did you manage to solve the issue? I have the same problem.

 

 

Thank you for your time.