I am trying to get data from adx_externalidentity dataverse table. But it always return 0 count only. Below is my sample code.
{% fetchxml externalidentity %}
<fetch distinct="false" mapping="logical" output-format="xml-platform" version="1.0">
<entity name="adx_externalidentity">
<attribute name="adx_username"/>
<attribute name="createdon"/>
<attribute name="adx_identityprovidername"/>
<attribute name="adx_contactid"/>
<attribute name="adx_externalidentityid"/>
</entity>
</fetch>
{% endfetchxml %}
Total Records: {{externalidentity.results.entities.size}}
{% for item in externalidentity.results.entities %}
"Contactid": "{{ item.adx_contactid }}",
"adx_identityprovidername" : "{{item.adx_identityprovidername}}"
{% unless forloop.last %},{% endunless %}
{% endfor %}