Hello Nikhil,
Thank you for using our Microsoft Advertising Learn Q&A Platform!
I understand that you have been grappling with API data ingestion and facing an error. I hope the response and resources provided here can be of some use to you.
Our support teams are also happy to discuss your account in more detail via phone, chat or email to provide review assistance, please see our support page to reach out!
The error you are encountering could be related to the way you are requesting the access tokens or handling the refresh token. Ensure that you are following the correct steps to redeem the refresh token for a new access token. According to the Microsoft Ads API documentation, when you refresh the access token, you must include the client_id, client_secret, grant_type set to refresh_token, and the refresh_token you received earlier. Additionally, you need to specify the scope and tenant parameters in your request. Make sure that the tenant is set to common if you want to support both MSA personal accounts and Azure AD work or school accounts. If you are still facing issues, refer to the Common OAuth errors guide for troubleshooting help.
You can learn more here: Get access and refresh tokens
I hope the information provided here will at least partly answer your question. If you have any additional questions please do not hesitate to reach out to our support. I have also sent you a private message asking for further details. You are more than welcome to respond to me to that I can begin the investigation on my end.
Kind regards,
Vahid | Microsoft Advertising Support Specialist | 800-518-5689