idea Re: Retrieve all attributes defined in a FetchXML query in Suggest an Idea

Retrieve all attributes defined in a FetchXML query

Hoxito — Thu, 20 May 2021 17:23:09 GMT

When querying data with the Microsoft Dynamics CRM V2 connector using FetchXML, Qlik internally retrieves the first page of data. It then checks if those attributes contain data, and only those attributes containing at least one value are being made available for subsequent use within the Qlik script.

Now, in certain cases - depending on the order of the retrieved records and on how the data is populated across the records and among the attributes - not all attributes contain values in the first page. The problem: In these cases, these attributes are discarded and not made available within the Qlik script.

Thus, I would suggest to implement a feature enabling it to bypass the above-mentioned check and get every single attribute defined in the FetchXML query - regardless whether in contains data in the first page of records or not.

Re: Retrieve all attributes defined in a FetchXML query

AlexOmetis — Tue, 04 May 2021 10:23:03 GMT

Think this is a dupe of Web Connectors - Microsoft Dynamics CRM V2 - Qlik Community - 1801641

Re: Retrieve all attributes defined in a FetchXML query

Hoxito — Tue, 04 May 2021 11:25:38 GMT

Hi @AlexOmetis

Looks like it - thank you very much for pointing it out!

Best regards

Renato

Re: Retrieve all attributes defined in a FetchXML query - Status changed to: Closed - Duplicate

Meghann_MacDonald — Thu, 20 May 2021 17:24:20 GMT

Thanks all! I will close this as a duplicate and point to @johnt 's idea here:https://community.qlik.com/t5/Suggest-an-Idea/Web-Connectors-Microsoft-Dynamics-CRM-V2/idi-p/1801641

Please add your likes and comments there to show support for this request.

Meghann