Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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
Giga 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.