BLOB field not visible in ODATA web service

airam · 2016-12-14

hi, we need to publish the Item Picture field through ODATA Web service in NAV2016, but unfortunately we are not succeeding as the field is not visible. Do you have any suggestions of how we can go around this please?

thanks in advance!

archer89 · 2016-12-14

For a solution follow http://kauffmann.nl/2012/04/04/binary-data-with-nav-web-service/

airam · 2016-12-14

thanks for your prompt reply, but the problem is that with OData web services we cannot publish a codeunit.

archer89 · 2016-12-14

is it possible for you to load the picture with an extra call based on a soap web service ?

Juhl · 2016-12-14

Create a text variable, and add it to the page. Then fill the variable with Base64 in OnAftergetrecord.

archer89 · 2016-12-16

add a text field to table item. fill it with the base64 encoded image value. this field you can access via odata. when calling the odata service read the new text field, convert the text value back to an image.

Kishorm · 2016-12-16

archer89 wrote: »

add a text field to table item. fill it with the base64 encoded image value. this field you can access via odata. when calling the odata service read the new text field, convert the text value back to an image.

The problem with this is that a Text field can only store 250 chars so won't be large enough to store a base64 encoded image.

Juhl · 2016-12-17

You need to do it on the fly.

BLOB field not visible in ODATA web service

Answers

Categories