web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / How to export matches
Customer experience | Sales, Customer Insights,...
Answered

How to export matches

(0) ShareShare
ReportReport
Posted on by Marijn van Haperen 5

Hi all,

When executing the unification process in Customer Insights, the matching step shows the results of the matches like in the image below.

We want to export the results for thorough analyses.

 

However, it only exports the first 100 results. Is there a way to export all the results?

We want to use it to apply de-duplication in our sources.

 

Hope you can help! Thank you!


Best Regards, 

pastedimage1610021246232v1.png

I have the same question (0)
  • Fabio Branco Profile Picture
    Fabio Branco Microsoft Employee on at

    Hi Marijn,

    Thank you for your question

    I am not aware if it's possible to export +100 matches

    Allow me to so some research and come back to you later on this topic

  • Verified answer
    tpeschat Profile Picture
    tpeschat 4,930 on at

    Hi,

    yes this should be possible.

    If you navigate to Data --> Entities you can find a system entity called ConflationMatchPairs.

    If you want to export the whole entity and not only the first 100K results, you can define a new export destination at Admin --> Export destination.

    There you can define a new export to either an azure storage account or an SFTP location and choose which entities to export.

  • Marijn van Haperen Profile Picture
    Marijn van Haperen 5 on at

    Thanks for the suggestion, but i was looking for something more simple. This is a quite comprehensive solution.

    I was looking for something more simple, directly in the step where I am doing the matching. Just like you can download directly form the overview there the 100 results to Excel. But apparently there's no other way.

    Still thanks!

  • Community Member Profile Picture
    Community Member on at

    Hi Marijn,

    The suggestions of Fabio and Thomas are correct.

    If you have > 100k records in your match procedure, you won't be able to extract them all via the CI interface.

    And unless you export to a destination like Blob or SFTP, I'm not sure there are many other options.

    What you could try is access it via the CI API (GET https://api.ci.ai.dynamics.com/v1/instances/<instanceid>/data/ConflationMatchPairs) .

    You can access the CI API documentation in CI itself (Admin > Permissions > APIs > Explore our APIs).

    I've done this before using Postman but I have never gone as far as saving the data and checking if all the records are there.

    For practical purposes you'd probably want to save the response as a table or dataframe for analysis so consider using Python and Pandas to do this.

    Good luck!

    Halen

  • Sivaraman Sekar Profile Picture
    Sivaraman Sekar 20 on at

    hi,

    we tried hitting that api to get predicted data from entity. we not able to export what we required, instead we got only count values and other meta data's. is there any other way to pull those values

    Thanks,

    Siva

  • tpeschat Profile Picture
    tpeschat 4,930 on at

    Hi,

    actually the application is quite chatty and you can see the requests in the network traffic.

    This is the request, when you download the 100K conflation match pairs from the entities:

    pastedimage1611603136571v1.png

    You can do the same via Swagger (you have the whole API definition there):

    https://prod-weu-01.api.ci.ai.dynamics.com/swagger/index.html

    You should exchange prod-weu-01, if your instance isn't hosted in western europe, though.

    Before you can try out a request, you need to authorize:

    pastedimage1611603263644v2.png

    Then locate the "EntityData" and perform a GET request, where you provide your instanceid and in the relative path fill in ConflationMatchPairs?$select=*&$top=100000.

    pastedimage1611603492133v3.png

    You could try to leave out the $top=100000, or try out other values.

    You can download the response as a json, but it is paginated, so you only get 100 records per page ...

    So also not an easy, user friendly option. The export might be easier in that case ...

    br Thomas

  • John Wiese Profile Picture
    John Wiese Microsoft Employee on at

    For prediction results we will be shipping an update soon that will allow you to export the entity to Blob storage.

  • Fortuna2518 Profile Picture
    Fortuna2518 15 on at

    Thanks for the information

  • Fortuna2518 Profile Picture
    Fortuna2518 15 on at

    Facing same issue let me know if you find any solution for this

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 151 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 134

#3
Jimmy Passeti Profile Picture

Jimmy Passeti 55 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans