I've integrated microsoft graph API and it opens the docx of pdf files using personal account but don't when I use work or school account.

I am working on a Django project and I have integrated Microsoft Graph API. I have created the app in the azure portal using my personal Microsoft Account and assigned some permissions. This means I did everything for the created app that allows a user to log in and then perform the tasks according to the project requirements.

when I use my personal Microsoft Account to log in, it logs in and creates the access token, and refreshes the token which I store in my database.

after storing both of the tokens, I also refresh the access token while opening the file on Microsoft office.

The requirement of the website is to open the docx or pdf files on Microsoft office 365 using the access token and refresh tokens.

In the case of my personal Microsoft Account:

When I click on the file uploaded on my site, it first uploads the file on one drive and then gets the file id from the one drive, then opens the file on Microsoft word.

It means it is working fine.

It gives this FILE ID when I open it: id: 566BF74F59D4F342!375

When I log in using my personal Account, it creates this kind of access and refresh tokens:

Access token:

EwB4A8l6BAAUAOyDv0l6PcCVu89kmzvqZmkWABkAAT1q+iOXTaq1/OPmUciuOdvb7a6f7Be+WJvTcqMQsjV7kHkkqv8KXqExPNAKLidiO9IXZa/hoHQMv8NQafntW9rvOvLdp4aGYiBtq2l2lyVR2xdosPAYF9KVUMQHsDJ3G6iuWJruT/ICgA5vWdrL9zCe1gtfLYU4i0RWsEepgdnhmhAYYDXiFDq1V+eM82nmK6Dm8TDGPYzPnypctElwibEtz+Q4VclGsSK1bwz/WKPQf7q1Dnm5Lled7vhX4hpfy3vTKJCInLfBlPbhhB/sfllMCGqIZv4NA5fkgnE0lfLUZOfAySYRFY/bii6uh4fXfhZtlm7zX+NnewfP/gX/AHEDZgAACExpOEiA+5V1SALpy2vt1cxHbkSJFSUYCSSRyru9FtZ+7Vs8UIk07nDOvlCKN+Wr/PHEdyI+QnyEypa00sWpsflTebfKyNqUfZbVK5/h+P1N0V05ohBPF1i9FdJJTZ+LNrDLeFr4sIRez7LtHQ0Hv26qYY++NmhOuScrjeG4wa56CFXrTQk3hsT9unFUVBA1JDmD2sTcZ/pl4/qubppO2Uupy6JX9B83JTAZMH8iEFdoiHgGNAT74fc5OAl4Bq4ahrOPRI2nriTmgKdSQ1tpQGSKb+H1tA235AmYy4TVl8D86GeG5GHVgManJOuxr4Wqrj6YKGmGU2/9w4EJz1s+KBc+fadWIcV4uS8lgi9PdlueAjgUlbWtyAlJjYDduc4/3Cp3ylEVQh/HoyfdP+EuJWGQhJEt5TR1s7xPR2WmAbPZP2GtvUAtw7wVsQJ2CRT6xwZIZeEywtzoKWpB6wgMKE0xRXa6anMeKRb9D9Dto9/LZTlZcvaYQPU6ADFsCy4zn1KaWdg69EqmCszuiTmvAW25W477Pzvav+Cmca/2k85g0cIhFeWXHy3v51GrW2/JC5kIvBRV6MyXjANSBI9y9snH8J4nBtVwVDDoH3sHhv/Kr3cGCT8DbupyUV6OBYgI8bT9wjVHHxRoDShp8gFbNQLkKq1WklwzQVvjgSzxaJdKWBtOZZ2O13nOGxBvxzlO37HcJ0jAFASF5O5ndwpqDs86GhYuYUhF+tU+HTUU91F9DXekvqZ2NAKU4PNEteFSBehhqG3FOBlS1SkDzB30Zqzfeo4C

Refresh Token:

M.R3_BAY.-CVve1f!haI95iOqcGCTfOWPabWRSVFB7v0FOyeT37gVN57unhS8trTlecXMZHcV62F6az7VqfKsDlo1QHJFx6Q6853vqQ1PHRCHLnGy98RZ01EK0mLVcUvqVtfuf7oBYWKngEM1pU!oWA91NwODRFEQvQ3d4c48gkBsVVjYvm0*g0wo58eEzxS0bEvmHdc3xOy6oY2CqeiwFhfvQ68dyyeAGsREnZDAz8VHOnsMoSI!IrQkI5OS6cPlDfuQVppGEQWXfcE5mjJIhHAVMFSFbMMeHbgghQvb*!GEg40fpD8ODOi5ENhlSgwAkfkqXAt4ZTiKU5GK6Sg1TSH7pNWM8MJM8oRJlxe7IiCL!LFb8NTuW

In the case of my Work or School Microsoft Account:

When I try to open the file using the same access and refresh tokens that were created using my personal account, it doesn't open the file on Microsoft office 365. Also when I try to login on micrsoft account while opening the file using microsoft work account, it doesn't log me in and gives this error: That Microsoft account doesn't exist. Enter a different account orget a new one.

But when I login using my work account, it logs in but doesn't open the file. it also upload the file successfully, but gives a different and long file id.

the file ID: 01AYC7RHMAIPTX2QGX6VFKEGTM5RUEYWGU

the printed response:

Upload response : <Response [201]>

File static/documents/temp_hd6P3du.docx created and uploaded to OneDrive successfully.

It gives this error:

Failed to get file: {"error":{"code":"itemNotFound","message":"The resource could not be found.","innerError":{"date":"2023-03-06T08:23:33","request-id":"602abed6-38b1-4dd9-9371-fdc7d7018168","client-request-id":"602abed6-38b1-4dd9-9371-fdc7d7018168"}}}

the access and refresh tokens that I get when I log in using my Microsoft work account:

Access Token:

eyJ0eXAiOiJKV1QiLCJub25jZSI6IklLTERjbUdHSHBsZmF6TXpvbER6eERHeldrSHdobnE0YS1VNVNfOXRlUzQiLCJhbGciOiJSUzI1NiIsIng1dCI6Ii1LSTNROW5OUjdiUm9meG1lWm9YcWJIWkdldyIsImtpZCI6Ii1LSTNROW5OUjdiUm9meG1lWm9YcWJIWkdldyJ9.eyJhdWQiOiIwMDAwMDAwMy0wMDAwLTAwMDAtYzAwMC0wMDAwMDAwMDAwMDAiLCJpc3MiOiJodHRwczovL3N0cy53aW5kb3dzLm5ldC8zNzdmOGNkZC02Nzg3LTQ0ZTYtYTIzZi02OGMyMThmMTMwZGEvIiwiaWF0IjoxNjc4MDQ2MDc5LCJuYmYiOjE2NzgwNDYwNzksImV4cCI6MTY3ODA1MTM4NSwiYWNjdCI6MCwiYWNyIjoiMSIsImFpbyI6IkFWUUFxLzhUQUFBQTlNOVNDaXZLR0h2UHhEKzZueVFmMGIyN1l0L1hhZGdBckJpbk05dE9WVWZWc3JnOVlFWCswMHhmL295dWluQ1lFWHMxWnorMytHbGpablpxak4ydXFvR281dmF4SnZnZFNCUHkzcmdmMVlFPSIsImFtciI6WyJwd2QiLCJtZmEiXSwiYXBwX2Rpc3BsYXluYW1lIjoiVEZCUCIsImFwcGlkIjoiOGMxYWZlYTQtMTM5MS00ZDYzLTkzNDItMmZiNTRkYWRhODZkIiwiYXBwaWRhY3IiOiIxIiwiZmFtaWx5X25hbWUiOiJBYnViYWthciIsImdpdmVuX25hbWUiOiJNdWhhbW1hZCIsImlkdHlwIjoidXNlciIsImlwYWRkciI6IjM5LjQyLjQzLjk3IiwibmFtZSI6Ik11aGFtbWFkIEFidWJha2FyIiwib2lkIjoiYjQxNzVkOTQtY2I1Mi00M2MwLTgyOTktYTNkMzYyNThmMzRkIiwicGxhdGYiOiIzIiwicHVpZCI6IjEwMDMyMDAyN0ZBOUY0ODEiLCJyaCI6IjAuQVU0QTNZeF9ONGRuNWtTaVAyakNHUEV3MmdNQUFBQUFBQUFBd0FBQUFBQUFBQUNEQUZBLiIsInNjcCI6IkNhbGVuZGFycy5SZWFkV3JpdGUgRGlyZWN0b3J5LlJlYWQuQWxsIERpcmVjdG9yeS5SZWFkV3JpdGUuQWxsIEZpbGVzLlJlYWRXcml0ZS5BbGwgTm90ZXMuUmVhZFdyaXRlLkFsbCBvcGVuaWQgcHJvZmlsZSBVc2VyLlJlYWQuQWxsIFVzZXIuUmVhZFdyaXRlLkFsbCBlbWFpbCIsInN1YiI6IlhTZ0RVTkljMTdBamkxVFNuTGc4eEYzaUFkbThWc0Fqa25SQWxsdENKcDQiLCJ0ZW5hbnRfcmVnaW9uX3Njb3BlIjoiRVUiLCJ0aWQiOiIzNzdmOGNkZC02Nzg3LTQ0ZTYtYTIzZi02OGMyMThmMTMwZGEiLCJ1bmlxdWVfbmFtZSI6Ik11aGFtbWFkQWJ1YmFrYXJAZGphbmdvNjAwLm9ubWljcm9zb2Z0LmNvbSIsInVwbiI6Ik11aGFtbWFkQWJ1YmFrYXJAZGphbmdvNjAwLm9ubWljcm9zb2Z0LmNvbSIsInV0aSI6InkzWVprdExaRkVDbjB2ZFBsbzhlQUEiLCJ2ZXIiOiIxLjAiLCJ3aWRzIjpbIjYyZTkwMzk0LTY5ZjUtNDIzNy05MTkwLTAxMjE3NzE0NWUxMCIsImI3OWZiZjRkLTNlZjktNDY4OS04MTQzLTc2YjE5NGU4NTUwOSJdLCJ4bXNfc3QiOnsic3ViIjoibmI1eENyZDZqLWh4S242aVFlN1VubVp5V1U4enpiOE1qaUY0elpCdnBybyJ9LCJ4bXNfdGNkdCI6MTY3Nzg3MzM5NH0.synFEbHnJHHeUoMMD5W0QB0XLvL772NzSJvq2gMbqmpvPGZ1msX4BNU1Kt7gKN_2G78l3t_J-A3V6E3dpU2wxAyRZaxG4rZ_NMxU407RnEIs9_Na1hhBwh16d-OqPv1OsvqCt4_E4sKHkOiLp4QpA0fIpSgTHPUCHFrw4GM8ytvnvxyGSM2G-tglLwf9M_KjvjOzxm_T0lB3DnPuJQaM2QZNfxFFw1zegRlnXJSBCL3uvXS_Jmqedxx4IliPKZw_ezoMFtxk05COyFQIJHj11D5il8DteowolDcnIlrm7ivMjj_9RSQzVJmiL1uRNkQHuoYDjoJkG5nzbrGASNrjfw

The refresh token:

0.AU4A3Yx_N4dn5kSiP2jCGPEw2qT-GoyRE2NNk0IvtU2tqG2DAFA.AgABAAEAAAD--DLA3VO7QrddgJg7WevrAgDs_wUA9P8BZr_DCH9q1ltKeZvJKm_0a82ZBnFY8EA3F_OL1BuFSk-AYugqG1UQrrcHK8E9CrVBq7Ut8ODNjJ1F4cxIhS5RvOCNMyYTzEjj4D5Fpx37pFoUpwGHMAeBKWHEpuqC0rOBQwjuMTtX8erXHV2gV3OD1nxdcB_fKLTQLy_s70_OFnf7yhltzvjSK8iYPnIA5wzyRk6QQLdvV0fjW5zw0L1f_UYK2XbySUiS7c94y0lxwPQX7YSdrz9IEDglQw-_GUVeEGYRztLWQinC8BGyZ6zzs2aKKEi--W5Vg-4hOGvcDYAiGBKVRWkXj_6gZ58NcWceaYVL0neaXhhxk0Yk6qMhPPRmXhqQ9Rdve63zpxptBkSwll8IjoZNTW6qxI4QKRvwjmFq_zgOw0SoelAt7pWQdzZkDgC2v0SBy4A6C6P2_vWpeeIV4FhosYwoGjr0F2R4jzKDpipRgXdcQC_bRIdbLYWkHW8R8BMQHQV7qTxln6Jw0hYb4JZAFN4_jtVIzZrsTCjJqZkpGQcKPKkSb_MM0jOtyMjNJW01RAAV_b6JJTB8KUYBNacBiwPv5n6IHZ8QzGJpo-AdX-RXrQyuwyO9XlLUraPnO4yD4C9P0R1W3hq6OS9k_sDZMGIWAdk5KEeeh97oSegbZlPa8qfYxhZA52Gr1GsJrfUSIssM-9bxqtP-XNd9KS_Y9PpMPlvfRZlh-SW1R3GpQPelxySDrHaPD4oV3fxIRLxDTIGJGMqk5Xka-fMEvrowdndL_4vk3IDluYN7BJc0GOdGRcplraeNW5tKCozbuKbt9M2q4s79Iwj5db5hVGqDpdGCftWGZam2htI59zYX

Is the issue in access token and refresh tokens creation or something in my API permissions?

can anyone guide me to fix the issue so that I can open the files from all Microsoft account types in a single sign-in and use the same access and refresh tokens?

Thanks