Rest Connector Problems

tmumaw — Sat, 16 Nov 2024 02:25:02 GMT

I am trying to extract data from Microsoft CRM365 which resides in the cloud. All of my extracts work fine except for this one. I can put 10000 rows through it and it runs fine. When I try and run everything through it I get this message after it processes for about 45 minutes writing data out. Any help would be appreciated.

2019-09-23 08:05:30
2019-09-23 08:05:30 QVX_UNEXPECTED_END_OF_DATA: HTTP protocol error 401 (Unauthorized):
2019-09-23 08:05:30
2019-09-23 08:05:30 'Bearer' authentication schema provided by the web-service is not supported or your credentials are not valid.
2019-09-23 08:05:30 Error: QVX_UNEXPECTED_END_OF_DATA: HTTP protocol error 401 (Unauthorized):
2019-09-23 08:05:30
2019-09-23 08:05:30 'Bearer' authentication schema provided by the web-service is not supported or your credentials are not valid.
2019-09-23 08:06:43 QVX_UNEXPECTED_END_OF_DATA: HTTP protocol error 401 (Unauthorized):
2019-09-23 08:06:43
2019-09-23 08:06:43 'Bearer' authentication schema provided by the web-service is not supported or your credentials are not valid.
2019-09-23 08:06:44 Execution Failed
2019-09-23 08:06:44 Execution finished.

Re: Rest Connector Problems

Brett_Bleess — Wed, 02 Oct 2019 14:43:13 GMT

Hey Thom, I think I would surf Microsoft CRM365 support on this one, as I am betting it is something on that side that is timing you out here. Either that or they are imposing a limit on the number of rows extracted etc.

The Web Connector package I gave you for the SFTP does have a premium connector for Microsoft Dynamics CRM, but I am not sure if this is specific to the 365 version or what. Have a look at the Help on that, it may give you something, sorry I do not have anything better:

https://help.qlik.com/en-US/connectors/Subsystems/Web_Connectors_help/Content/Connectors_QWC/Data-Source-Connectors/Microsoft-Dynamics-CRM-Connector.htm

Regards,
Brett

topic Rest Connector Problems in QlikView

Rest Connector Problems

Re: Rest Connector Problems