Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Is there a way to vali...
Finance | Project Operations, Human Resources, ...
Answered

Is there a way to validate data on Update_Recordset even if we skip table data methods?

(1) ShareShare
ReportReport
Posted on by JohnBright 87
Hi experts, 
I am updating a table through update_recordset. This table has mass data. To optimize the performance of updation, I have skipped the data methods through skipdataMethods option. But now, the client needs to validate records on updating. I am exploring is there any way that we could still validate the records on updating through update_Recordset even after skipping the methods? This question might be senseless. I understand validating by not skipping the data methods is the best practice. But just exploring is there any other way that we could validate without sacrificing the performance? 
 
Thanks in advacne, 
John
  • Verified answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Is there a way to validate data on Update_Recordset even if we skip table data methods?
    Hi,
    As Andre said, instead of processing all the data at once using update_recordset, you can split the data into smaller batches. After processing each batch, you can apply data methods for validation. This way, you can ensure that data is validated periodically without sacrificing too much performance.
    Best regards,
    Kevin
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,622 Super User 2024 Season 2 on at
    Is there a way to validate data on Update_Recordset even if we skip table data methods?
    Hi John,
     
    Like Layan mentioned, you would lose performance when validating the records. You can also consider running another batch job for validating the records afterwards, but that depends on the severity of the validation.
  • Suggested answer
    Layan Jwei Profile Picture
    Layan Jwei 7,255 Super User 2024 Season 2 on at
    Is there a way to validate data on Update_Recordset even if we skip table data methods?
    Hi John,
     
    I don't think it's possible. Update_recordset will fall back to record-by-record operation once you remove the skipdataMethod(true) and that's because the update method of the table will have some logic.
     
    So if you want to validate each record you want to update, I don't think it makes sense for update_recordset to work without sacrificing performance.
     
     
    Thanks,
    Layan Jweihan

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,622 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans