Last post Mar 24, 2020 07:59 PM by bruce (sqlwork.com)
Member
1 Points
96 Posts
Mar 24, 2020 07:36 PM|rgovindarajan|LINK
Hello,
I'm currently consuming external Rest API in my application to post data over.
I am using web api controller to do that.
For any errors and failed transactions, I have to resend it again. So I'm thinking a nightly batch process using SSIS to resend the data again.
Is there any better approach to handle the failed transactions ? Please advise.
Thanks,
Raj
All-Star
55574 Points
14299 Posts
Mar 24, 2020 07:59 PM|bruce (sqlwork.com)|LINK
it all depends on the tools you have. an outage may require several hours of retrying. a daily or hourly retry is common. you can use any scheduler and code.
Member
1 Points
96 Posts
Error handling and Failed transactions in Rest API - Post
Mar 24, 2020 07:36 PM|rgovindarajan|LINK
Hello,
I'm currently consuming external Rest API in my application to post data over.
I am using web api controller to do that.
For any errors and failed transactions, I have to resend it again. So I'm thinking a nightly batch process using SSIS to resend the data again.
Is there any better approach to handle the failed transactions ? Please advise.
Thanks,
Raj
All-Star
55574 Points
14299 Posts
Re: Error handling and Failed transactions in Rest API - Post
Mar 24, 2020 07:59 PM|bruce (sqlwork.com)|LINK
it all depends on the tools you have. an outage may require several hours of retrying. a daily or hourly retry is common. you can use any scheduler and code.