What do you think would be the best way to update a table in DataVerse from the result set of a SQL server stored procedure? I have made a power automate to get a JSON file where I probably could create a csv to save into a share and then have a scheduled dataflow from DataVerse run? Or is there a good way to take the Result set and update / create the rows in the Dataverse table?
I have been manually running the procedure, copying the results out to a csv, then having the dataflow run and do its thing. I just want to fully automate this process.
Thanks for the suggestions
Hi @iskguy ,
Have you thought about using Power Automate with the SQL Connector? https://docs.microsoft.com/en-us/connectors/sql/ Some limitations exist around the output of stored procedures but hopefully these don't hinder you. You can then take the information from your stored proc results and utilize the Dataverse connector to add / update / delete etc. rows.
@iskguy, I have done something similar with the SQL Views, if you can create a view from that Stored Procedure, you can then use Dataflowas to load the data from the view into a Dataverse table. Remember that you will treat the SQL view as a Table when you are configuring the data flow.
Regards,
Ahmed
If my reply helped you, please give a 👍. And if it has solved your issue, please consider Accepting it as the Solution to help other members of the community find it more.