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,
Facing same issue let me know if you find any solution for this
Thanks for the information
For prediction results we will be shipping an update soon that will allow you to export the entity to Blob storage.
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:
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:
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.
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
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
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
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!
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (