Small and medium business | Business Central, N...

Upload pdf files as attachment documents to Business Central Items using OData Api V4 web services

(0) Share

Report

Posted on by sina123

Hello,

I am looking for an OData web service that allows me to upload a pdf document to an Item in Business Central. I was able to get information on documents attached (uploaded from front end) using the below web service:

GET {{BaseURL}}/{{environment}}/AttachedDocuments

Now i need to basically attach or upload document to a specific Item using web services. I have tried several tables and web services but in vain.

Kindly guide me on how i can achieve this using OData web v4 services.

Thanks.

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Marco Mels Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

Hope this helps:

docs.microsoft.com/.../dynamics_attachment_update

Thanks.

Was this reply helpful? Yes No
sina123 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the response, but the documentation is regarding attachments for journallines but i need to attach document to an Item. I have tried the request but doesnt work for an item unfortunately.

Was this reply helpful? Yes No
Suggested answer

Marco Mels Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

If you run this command in Postman:

api.businesscentral.dynamics.com/.../items eq '1896-S'

This is for ATHENE Tafel in demo data, you get the following:

{

"@odata.context": "<<REMOVED>>/items",

"value": [

{

"@odata.etag": "W/\"JzIwOzEyNjE3ODgwMjUzNzkzNDc1MjExMTswMDsn\"",

"id": "4d5de349-0fe2-ec11-bb45-000d3a39a433",

"number": "1896-S",

"displayName": "ATHENE Tafel",

"type": "Inventory",

"itemCategoryId": "3304de4f-0fe2-ec11-bb45-000d3a39a433",

"itemCategoryCode": "TAFEL",

"blocked": false,

"gtin": "",

"inventory": 4,

"unitPrice": 1005.8,

"priceIncludesTax": false,

"unitCost": 784.6,

"taxGroupId": "00000000-0000-0000-0000-000000000000",

"taxGroupCode": "",

"baseUnitOfMeasureId": "d05de349-0fe2-ec11-bb45-000d3a39a433",

"baseUnitOfMeasureCode": "STUKS",

"generalProductPostingGroupId": "0d02de4f-0fe2-ec11-bb45-000d3a39a433",

"generalProductPostingGroupCode": "DET.HANDEL",

"inventoryPostingGroupId": "bd5de349-0fe2-ec11-bb45-000d3a39a433",

"inventoryPostingGroupCode": "WEDERVERK",

"lastModifiedDateTime": "2022-06-16T07:08:14.613Z"

}

]

}

There is no attachment field you can use; therefore you must create a custom API.

Thanks.

Was this reply helpful? Yes No
Suggested answer

divyeshchitte 970 on at

Like
a
(0)

Report
Copy link

Link copied!

HI Sina,

You can use base functionality of Microsoft, which is available on Inventory setup page> Import Item.

You can create a publish an API page for "Import Item Pictures" Page id 348 and then upload the items through API.

Was this reply helpful? Yes No
sina123 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, I tried the suggestion but get an error "Entity does not support insert" while sending a POST to /ImportItem endpoint created using tableid 348 Import Item Pictures.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,812 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I will suggest create a New API page and use that API page to insert the attachment and move those attachment to further to other your required table.

for more info. please refer below link

https://accelerationeconomy.com/news/demo-business-central-api-for-importing-exporting-attachment/

Thanks.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Upload pdf files as attachment documents to Business Central Items using OData Api V4 web services

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the May Top 10 Community Leaders

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Upload pdf files as attachment documents to Business Central Items using OData Api V4 web services

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the May Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates