Hello - I know there are many questions and answers for this issue out there, but it feels as if I've tried all of the solutions offered and I'm still unable to get the REST connection work when the InfoPath 2013 form is published to the SharePoint 2013 sites.
Basically, everything works okay from within InfoPath filler or locally, but when published I get the notorious 5566 error. I've got it narrowed down to (what seems to be) the FARM account. The message states:
The following query failed: REST Web Service 2 (User: 0#.w|(domain)\(user), Form Name: TestingRest, IP: , Connection Target: , Request: (fulldomain)/TestingRest, Form ID: urn:schemas-microsoft-com:office:infopath:TestingRest:-myXSD-2016-11-11T19-09-59 Type: DataAdapterException, Exception Message: The form cannot run the specified query.
The remote server returned an error: (401) Unauthorized.)
``
In the details tab, it states the user is (domain)\(farm account)
I've set "DisableLoopbackCheck" to 1 in regedit
I've set "AllowAnonymous" in web.config to 'false'
I've restarted the server
Still nothing shows with my simple one dropdown field form.
When I type the URL into a browser it works fine, just like using in InfoPath filler or local. Example:
http://domain/_api/Web/Lists/getByTitle('ListTitle')/Items
Can anyone think of something I'm missing? The error used to be on user (domain)\IUSR, but after changing the AllowAnonymous in web.config file, the error is now on (domain)\(farm account)
Thank you, in advance.
~ l