Title: FetchXML does not return anything.
Last modified: March 14, 2024

---

# FetchXML does not return anything.

 *  Resolved [ecui](https://wordpress.org/support/users/ecui/)
 * (@ecui)
 * [2 years, 2 months ago](https://wordpress.org/support/topic/fetchxml-does-not-return-anything/)
 * Hi,
 * Sorry I’m new to wordpress and dataverse integrations.
 * I’m trying to do a test fetching from one table in dataverse:
 * ![](https://wordpress.org/2eefd604-03ad-4f9c-bc04-439a849d2952)
 * The field I’m trying to pull is called EmpID with name of cr10b_EmpID. The table
   name is TestTable
 * The code I used as shown below:
 *     ```wp-block-code
       {% fetchxml collection="usersfetched" cache="PT30M" %}
       <fetch mapping='logical' returntotalrecordcount='true'>  
          <entity name='TestTable'>
             <attribute name='cr10b_EmpID'/>
          </entity>
       </fetch>
       {% endfetchxml %}
   
       {% if usersfetched.results.entities|length > 0 %}
           <ul>
           {% for customer in usersfetched.results.entities %}
             <li>{{usersfetched["cr10b_EmpID"]}}</li>
           {% endfor %}
           </ul>
       {% else %}
           <p>No usersfetched found.</p>
       {% endif %}
       ```
   
 * It does not prompt anything however I have inserted two records for testing.
 * Any hints?
 * Kind regards,
 * Eric

Viewing 1 replies (of 1 total)

 *  Thread Starter [ecui](https://wordpress.org/support/users/ecui/)
 * (@ecui)
 * [2 years, 2 months ago](https://wordpress.org/support/topic/fetchxml-does-not-return-anything/#post-17501993)
 * Hi,
 * I figured out why, my list view should changed to {entity.attribute}
 * Many thanks!

Viewing 1 replies (of 1 total)

The topic ‘FetchXML does not return anything.’ is closed to new replies.

 * ![](https://ps.w.org/integration-cds/assets/icon.svg?rev=2504995)
 * [DataPress (Dataverse Integration)](https://wordpress.org/plugins/integration-cds/)
 * [Support Threads](https://wordpress.org/support/plugin/integration-cds/)
 * [Active Topics](https://wordpress.org/support/plugin/integration-cds/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/integration-cds/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/integration-cds/reviews/)

 * 1 reply
 * 1 participant
 * Last reply from: [ecui](https://wordpress.org/support/users/ecui/)
 * Last activity: [2 years, 2 months ago](https://wordpress.org/support/topic/fetchxml-does-not-return-anything/#post-17501993)
 * Status: resolved