Hi All,
I am trying to execute a 'retrieve multiple' request from a custom page when I click a button.
I have been playing with PowerFX and ClearCollect and various other techniques without success.
Unlike a canvas app, I cannot see a FetchXML or method to call an API URL directly?
What is the best way to perform a retrieve multiple for the contact's table, for example via a custom page?
The below works to some extent - but it's not what I'm after. Is there another way?
ClearCollect(
ContactsCollection,
Contacts
)
The below don't appear to work in custom pages:?
ClearCollect(
ContactsCollection,
'https://<your_organization_name>.crm.dynamics.com/api/data/v9.1/contacts?$select=fullname,emailaddress1,telephone1'
);
ClearCollect(
ContactsCollection,
FetchXML(
"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>
<entity name='contact'>
<attribute name='firstname' />
<attribute name='lastname' />
</entity>
</fetch>"
).value
);
