You’re offline. This is a read only version of the page.
202
I'm currently facing the problem, that I want to integrate external data into my model-driven app.
Data = The company's employees
Source = REST API (oauth)
How would you bring this data into the model-driven app?
- Virtual Table --> quite complicated today, but maybe simpler after ReleaseWave2.2022
- Dataflow --> is this possible with oauth?
- CloudFlow with HTTP action / custom connector
Thoughts and suggestions are very welcome!
This was a few years ago and at the time we used an SSIS Job with KingswaySoft to extract and store it in DV. We had the employee entity and a couple extra entities to help with structure and reporting.
If I were to do it today and source system had a REST API (it didn't at the time) I'd just use Power Automate (or Logic Apps) with a custom connector.
HTTP Action also works of course.
Regarding Virtual Tables, I have to admit I haven't kept up to date with that functionality and its roadmap features, but at the time virtual tables didn't allow for relationships with other tables in the system. So you could bring data into DV but it would be just read only and couldn't actually link it to anything. That was limiting on the reporting and processes customer was asking for, so integrating the data once a day was the obvious solution.
I would say using cloud flow with http action or custom connector should be your best approach.
Hi @Mira_Ghaly
This would be a permanent syncing. not real-time but maybe once a day.
Data is only needed read-only --> one-way sync.
Hi @joaodsantos
Thank you for your reply.
I would use the data only read in DV, so the requirement for syncing would be one-way (the same as your requirement from the past).
Did you use HTTP action in your cloud flow or did you create a custom connector for that?
I clearly see the benefit from having a native DV table for this integration. I'm not sure how limited you are with the VirtualTables with searching / relationships etc....
Hi,
I think this might depend on what you want to use the data for and how you intend to save it.
Do you want to duplicate the data from the other system? Then you'll need to at least one custom table/entity to store the Employee data and use some integration (e.g. Power Automate flow) to connect to the REST API and pull the data and save it in Dataverse. You'd then need to think about keeping it up to date but the flow could just run daily to keep records up to date.
You could just create a Virtual Table/Entity that links to the REST endpoint, you won't have to worry about integration but that comes with some limitations as well in terms of what you can do with them on the Dataverse side I think.
Having had to do something similar in the past, I just created a table structure in Dataverse and set up a daily integration to keep records up to date. The master data was the other system so that made things easier since the copied fields would be read only from the DV side.
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
