{"id":738,"date":"2020-02-11T13:26:31","date_gmt":"2020-02-11T12:26:31","guid":{"rendered":"http:\/\/daxvisionerp.com\/?p=738"},"modified":"2025-10-27T08:11:21","modified_gmt":"2025-10-27T08:11:21","slug":"excels-query-from-odata-feed-to-access-your-data-entity","status":"publish","type":"post","link":"https:\/\/daxvisionerp.com\/home\/excels-query-from-odata-feed-to-access-your-data-entity\/","title":{"rendered":"Excel’s Query ‘From OData Feed’ to access your data entity"},"content":{"rendered":"\n

In an earlier post, I described how to set up Postman to test calling your AX data entities. http:\/\/daxvisionerp.com\/call-ax-data-entity-from-postman\/<\/a> <\/p>\n\n\n\n

You can also read data from AX data entities using Excel. It is easy, no need for secret and token, etc, you just need to log in with your AAD credentials. Let me quickly show the steps using VendorsV2 entity: ‘https:\/\/usnconeboxax1aos.cloud.onebox.dynamics.com\/data\/VendorsV2’ <\/p>\n\n\n\n

\"Machine
Figure 1: VendorsV2 entity in browser<\/figcaption><\/figure>\n\n\n\n
    \n
  1. Click ‘Data\/New Query\/From Other Sources\/From OData Feed’<\/li>\n<\/ol>\n\n\n\n
    \"Machine
    Figure 2: Excel Query from OData Feed<\/figcaption><\/figure>\n\n\n\n

    2. Set data entity OData feed URL<\/p>\n\n\n\n

    \"Machine
    Figure 3: Enter the OData feed URL <\/figcaption><\/figure>\n\n\n\n

    The first time you will get a login dialog after clicking the ‘OK’ button.<\/p>\n\n\n\n

    3. Load<\/p>\n\n\n\n

    \"\"
    Figure 4: Load dialog<\/figcaption><\/figure>\n\n\n\n
    \"\"
    Figure 5: Loading data<\/figcaption><\/figure>\n\n\n\n

    4. Result in Excel, data loaded<\/p>\n\n\n\n

    \"\"
    Figure 6: Data entity OData feed, data loaded<\/figcaption><\/figure>\n\n\n\n

    So, this way you can easily load your data to Excel and get a comfortable format.<\/p>\n\n\n\n

    I used this post as reference: https:\/\/wem.io\/documentation\/tips-and-tricks\/data\/odata-excel2016\/<\/a> <\/p>\n\n\n\n

    <\/p>\n\n\n

    #MSDyn365FO<\/a>, <\/span>Data entity<\/a>, <\/span>OData<\/a><\/div>","protected":false},"excerpt":{"rendered":"

    In an earlier post, I described how to set up Postman to test calling your AX data entities. http:\/\/daxvisionerp.com\/call-ax-data-entity-from-postman\/ You can also read data from AX data entities using Excel. It is easy, no need for secret and token, etc, you just need to log in with your AAD credentials. Let me quickly show the […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"1080","footnotes":""},"categories":[19],"tags":[25,83,87],"class_list":["post-738","post","type-post","status-publish","format-standard","hentry","category-dynamics-365fo","tag-msdyn365fo","tag-data-entity","tag-odata"],"_links":{"self":[{"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/posts\/738","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/comments?post=738"}],"version-history":[{"count":1,"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/posts\/738\/revisions"}],"predecessor-version":[{"id":1384,"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/posts\/738\/revisions\/1384"}],"wp:attachment":[{"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/media?parent=738"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/categories?post=738"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/tags?post=738"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}