Graph API Upload a file in to Teams Channel Via Share point folder || issue with ".docx,.doc,.ppt"

Question

Graph API Upload a file in to Teams Channel Via Share point folder || issue with ".docx,.doc,.ppt"

lnarayana 16

Hi Team, I am working on uploading attachments to the team's channel by using graph API, As per the document we have uploaded files to the share point folder and then get the details of attachments and construct the attachment details as objects to send messages to team's channel.

As per my observation if we try to update txt, pdf it is working as expected but with the ".docx,.doc,.ppt etc..," we are facing an issue i.e web URL is provided by API for "pdf/txt" content if different for ".doc, .docx"

After posted to Share point folder :

txt/doc : weburl is "https://italentcorporation1.sharepoint.com/sites/ICS-DEV/Shared%20Documents/General/sample.pdf"
docx/doc : web url is "https://italentcorporation1.sharepoint.com/sites/ICS-DEV/_layouts/15/Doc.aspx?sourcedoc=%7B484E72FC-1E20-406B-92B4-B287591FA3CA%7D&file=sample1.doc&action=default&mobileredirect=true"

Steps to Reproduce the issue.

Step 1: Upload a file in to share folder drive with PUT API (https://graph.microsoft.com/v1.0/groups/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/drive/items/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*:/sample1.doc:/content
file is : sample1.doc

Once upload to share point Response is like below:

Response :
{
"@odata.context": "https://graph.microsoft.com/v1.0/$metadata#groups('ef3a57f4-ed3f-4970-a4f7-28587ab65774')/drive/items/$entity",
"@microsoft.graph.downloadUrl": "https://italentcorporation1.sharepoint.com/sites/ICS-DEV/_layouts/15/download.aspx?UniqueId=484e72fc-1e20-406b-92b4-b287591fa3ca&Translate=false&tempauth=eyJ0eXAiOiJKV1QiLCJhbGciOiJub25lIn0.eyJhdWQiOiIwMDAwMDAwMy0wMDAwLTBmZjEtY2UwMC0wMDAwMDAwMDAwMDAvaXRhbGVudGNvcnBvcmF0aW9uMS5zaGFyZXBvaW50LmNvbUBlNTVmZTA4YS1lNGUzLTQ2MjctYWQ0MC1kOTk2MWM2MTJhYWEiLCJpc3MiOiIwMDAwMDAwMy0wMDAwLTBmZjEtY2UwMC0wMDAwMDAwMDAwMDAiLCJuYmYiOiIxNjQ5MjQzNjE4IiwiZXhwIjoiMTY0OTI0NzIxOCIsImVuZHBvaW50dXJsIjoiV294eWV0Q0djc0huM0gxVEkvN280eWVBZ2REdndpUVQzNWN6dnkzTVlHMD0iLCJlbmRwb2ludHVybExlbmd0aCI6IjE0NCIsImlzbG9vcGJhY2siOiJUcnVlIiwiY2lkIjoiTlRJM1ltRmhNelF0TjJNd01TMDBObUptTFdJM01HWXRaVGhpTTJWak1EWXhZVE5pIiwidmVyIjoiaGFzaGVkcHJvb2Z0b2tlbiIsInNpdGVpZCI6IllqQXpZemN5T1RRdFpqaGpOaTAwTVdRMExXRTNaVEV0T0dSalltSmhNekk1TXpVeSIsImFwcF9kaXNwbGF5bmFtZSI6Imljc2RldmFhZCIsImdpdmVuX25hbWUiOiJMYWtzaG1pIE5hcmF5YW5hIiwiZmFtaWx5X25hbWUiOiJOYXR0ZSIsInNpZ25pbl9zdGF0ZSI6IltcImttc2lcIl0iLCJhcHBpZCI6IjhkYzAzNGZhLThhM2YtNGRjNC1hMmFhLTMzMGNlYWFlMzk0ZiIsInRpZCI6ImU1NWZlMDhhLWU0ZTMtNDYyNy1hZDQwLWQ5OTYxYzYxMmFhYSIsInVwbiI6ImxuYXJheWFuYUBpdGFsZW50ZGlnaXRhbC5jb20iLCJwdWlkIjoiMTAwMzIwMDA0MEFDOUMxRCIsImNhY2hla2V5IjoiMGguZnxtZW1iZXJzaGlwfDEwMDMyMDAwNDBhYzljMWRAbGl2ZS5jb20iLCJzY3AiOiJncm91cC5yZWFkIGdyb3VwLndyaXRlIGFsbHByb2ZpbGVzLnJlYWQgYWxscHJvZmlsZXMucmVhZCBhbGxwcm9maWxlcy53cml0ZSIsInR0IjoiMiIsInVzZVBlcnNpc3RlbnRDb29raWUiOm51bGwsImlwYWRkciI6IjIwLjE5MC4xNDUuMTcwIn0.M0NGUGdyZjZMOWxvdGdJMEtWQTcxTFF4VE9CbU5tSEluajNTekNaa3F4OD0&ApiVersion=2.0",
"createdDateTime": "2022-04-06T11:13:38Z",
"eTag": "\"{484E72FC-1E20-406B-92B4-B287591FA3CA},1\"",
"id": "01E5HGNWX4OJHEQIA6NNAJFNFSQ5MR7I6K",
"lastModifiedDateTime": "2022-04-06T11:13:38Z",
"name": "sample1.doc",
"webUrl": "https://italentcorporation1.sharepoint.com/sites/ICS-DEV/_layouts/15/Doc.aspx?sourcedoc=%7B484E72FC-1E20-406B-92B4-B287591FA3CA%7D&file=sample1.doc&action=default&mobileredirect=true",
"cTag": "\"c:{****************},1\"",
"size": 607,
"createdBy": {
"application": {
"id": "********************",
"displayName": "icsdevaad"
},
"user": {
"email": "***********************",
"id": "**********************************",
"displayName": "Lakshmi Narayana Natte"
}
},
"lastModifiedBy": {
"application": {
"id": "******************",
"displayName": "test"
},
"user": {
"email": "lnarayana8**************",
"id": "*******************",
"displayName": "Lakshmi Narayana Natte"
}
},
"parentReference": {
"driveId": "*****************",
"driveType": "documentLibrary",
"id": "*******************",
"path": "/drive/root:/General"
},
"file": {
"mimeType": "application/msword",
"hashes": {
"quickXorHash": "*****************="
}
},
"fileSystemInfo": {
"createdDateTime": "2022-04-06T11:13:38Z",
"lastModifiedDateTime": "2022-04-06T11:13:38Z"
}
}

Step 3: We have to perform a post call to send message in teams with attachement
As per document we have grab the our attachment ID is the GUID in the eTag of the driveItem, your attachment contentURL is the webUrl of the driveItem's

Request Body :

POST-https://graph.microsoft.com/v1.0/teams/fbe2bf47-16c8-47cf-b4a5-4b9b187c508b/channels/19:4a95f7d8db4c4e7fae857bcebe0623e6@thread.tacv2/messages
Content-type: application/json

{
"body": {
"contentType": "html",
"content": "Here's the latest budget. <attachment id=\"*********************\"></attachment>"
},
"attachments": [
{
"id": "*************************",
"contentType": "reference",
"contentUrl": "https://italentcorporation1.sharepoint.com/sites/ICS-DEV/_layouts/15/Doc.aspx?sourcedoc=%7B484E72FC-1E20-406B-92B4-B287591FA3CA%7D&file=sample1.doc&action=default&mobileredirect=true"",
"name": "sample1.doc"
}
]
}

Response is :

{
"error": {
"code": "BadRequest",
"message": "File contentUrl extension: '.doc&action=default&mobileredirect=true' and name extension: '.doc' do not match.",
"innerError": {
"date": "2022-04-06T11:15:02",
"request-id": "af37a0e8-9035-4c2c-89a8-376b61356b5e",
"client-request-id": "af37a0e8-9035-4c2c-89a8-376b61356b5e"
}
}
}

Answer 1

Srinivasa Rao Darna 6,461

Hi @lnarayana ,

Please use full path till document in contentUrl:https://contoso.sharepoint.com/sites/test/Shared%20Documents/General/test%20doc.docx as mentioned in the example.

Example: Send a message with file attachment

Using the snippet from example I am able to successfully post a message with file attachment.

POST https://graph.microsoft.com/v1.0/teams/fbe2bf47-16c8-47cf-b4a5-4b9b187c508b/channels/19:4a95f7d8db4c4e7fae857bcebe0623e6@thread.tacv2/messages  
Content-type: application/json  
  
{  
    "body": {  
        "contentType": "html",  
        "content": "Here's the latest budget. <attachment id=\"153fa47d-18c9-4179-be08-9879815a9f90\"></attachment>"  
    },  
    "attachments": [  
        {  
            "id": "153fa47d-18c9-4179-be08-9879815a9f90",  
            "contentType": "reference",  
            "contentUrl": "https://m365x987948.sharepoint.com/sites/test/Shared%20Documents/General/test%20doc.docx",  
            "name": "Budget.docx"  
        }  
    ]  
}

Result of my test:

Hope this helps.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have further questions about this answer, please click "Comment".

lnarayana 16 Reputation points

2022-04-07T06:29:06.187+00:00

Hi @SrinivasaRaoDarnaMSFT-7657

As mentioned in "Steps to reproduce" Please follow those steps

Step1: Try to upload a .docx/.doc file to drive we will get "https://italentcorporation1.sharepoint.com/sites/ICS-DEV/_layouts/15/Doc.aspx?sourcedoc=%7B484E72FC-1E20-406B-92B4-B287591FA3CA%7D&file=sample1.doc&action=default&mobileredirect=true" URL

Step2: Upload above mentioned URL as attachments to the message object. then we will get "Bad Request"

Please check the content URL which I mentioned in the curl request with that URL we are getting a "Bad Request"
lnarayana 16 Reputation points

2022-04-07T06:30:50.983+00:00

Hi @SrinivasaRaoDarnaMSFT-7657

We are not getting this("/Shared%20Documents/General/test%20doc.docx ") format URL after uploading to drive as ".docx/.doc" format files.
Srinivasa Rao Darna 6,461 Reputation points

2022-04-07T13:32:04.427+00:00
Hi @lnarayana ,

Thanks for your comment.
From the step1 you can use id(01E5HGNWX4OJHEQIA6NNAJFNFSQ5MR7I6K) and with below API call you can capture webUrl in https://contoso.sharepoint.com/sites/test/Shared%20Documents/General/test%20doc.docx format.

GET /groups/{group-id}/drive/items/{item-id}/listItem

Here is my test result, the webUrl returned from this can be used in contentUrl in step2.

References:
driveitem-relationships-listItem
Send a message with file attachment

Hope this helps.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have further questions about this answer, please click "Comment".
Srinivasa Rao Darna 6,461 Reputation points

2022-04-12T11:29:27.667+00:00

Hi @lnarayana , is the above answer helpful?
lnarayana 16 Reputation points

2022-04-12T17:10:02.603+00:00

@SrinivasaRaoDarnaMSFT-7657 Thanks for the answer this answer is helpful for me
Srinivasa Rao Darna 6,461 Reputation points

2022-04-13T10:28:37.533+00:00

Glad to know this answer is helpful, if you can accept the answer it will help others looking for similar problem.
Parag Jadhav 1 Reputation point

2022-07-22T14:44:36.08+00:00

Hello,

I'm getting this error while sending a file:

Url: https://graph.microsoft.com/v1.0/teams/\<teamId>/channels/<channelId>/messages

Payload: {"body":{"contentType":"html","content":"Here's the latest budget. <attachment id=\"2a504b87-6ae8-REMOVED\"></attachment>"},"attachments":[{"id":"2a504b87-6ae8-REMOVED","contentType":"reference","contentUrl":"https://mytenant.sharepoint.com/sites/myteamName/Shared%20Documents/File-Upload-Test-1/1658500011386.docx","name":"1658500011386.docx"}]}

{
"error": {
"code": "Unauthorized",
"message": "Message POST is allowed in application-only context only for import purposes. Refer to https://learn.microsoft.com/microsoftteams/platform/graph-api/import-messages/import-external-messages-to-teams for more details.",
"innerError": {
"date": "2022-07-22T14:36:30",
"request-id": "35a9ac29-dfa0-4472-80db-e140a53a9625",
"client-request-id": "35a9ac29-dfa0-4472-80db-e140a53a9625"
}
}
}

Any suggestions?
Srinivasa Rao Darna 6,461 Reputation points

2022-07-25T17:44:28.557+00:00

Hi @Parag Jadhav ,

Looking at the error message you seemed to be using client credential flow(application permission) to send a message.

Only teams that are created in migration state, are supported for sending message from an application.

Refer: import-external-messages-to-teams.
Rajitha Perera 71 Reputation points

2023-03-08T00:37:46.6233333+00:00
Hi @Srinivasa Rao Darna

This seems for channels.

GET /groups/{group-id}/drive/items/{item-id}/listItem

What about for chat in this case? Because chats use personal SharePoint?

I referred this documentation

I tried the below API but it did not work at all.

GET /me/drive/items/{item-id}/listItem

Here I pasted the error I got

It will be great help if you can provide me correct API that can be used to capture webUrl for chat file upload.

webUrl should looks like

https://dev-my.sharepoint.com/personal/test01_dev_onmicrosoft_com/Documents/Microsoft%20Teams%20Chat%20Files/sample%20(1)%204.pdf

Thanks in advance.
Rajitha Perera 71 Reputation points

2023-03-08T05:33:50.1466667+00:00
@Srinivasa Rao Darna

I found the solution for it using the below API.
BTW Thank you for the above answers which help me to find the solution.

https://graph.microsoft.com/v1.0/me/drive/items/{item_id}?select=*,webDavUrl

Graph API Upload a file in to Teams Channel Via Share point folder || issue with ".docx,.doc,.ppt"

1 answer

Activity