BLOB field not visible in ODATA web service

airamairam Member Posts: 91
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!

Answers

  • archer89archer89 Member Posts: 337
    best regards
    Franz Kalchmair, MVP
    Alias: Jonathan Archer

    please like / agree / verify my answer, if it was helpful for you. thx.
    Blog: http://moxie4nav.wordpress.com/
  • airamairam Member Posts: 91
    thanks for your prompt reply, but the problem is that with OData web services we cannot publish a codeunit.
  • archer89archer89 Member Posts: 337
    is it possible for you to load the picture with an extra call based on a soap web service ?
    best regards
    Franz Kalchmair, MVP
    Alias: Jonathan Archer

    please like / agree / verify my answer, if it was helpful for you. thx.
    Blog: http://moxie4nav.wordpress.com/
  • JuhlJuhl Member Posts: 724
    Create a text variable, and add it to the page. Then fill the variable with Base64 in OnAftergetrecord.
    Follow me on my blog juhl.blog
  • archer89archer89 Member Posts: 337
    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.
    best regards
    Franz Kalchmair, MVP
    Alias: Jonathan Archer

    please like / agree / verify my answer, if it was helpful for you. thx.
    Blog: http://moxie4nav.wordpress.com/
  • KishormKishorm Member Posts: 921
    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.
  • JuhlJuhl Member Posts: 724
    You need to do it on the fly.
    Follow me on my blog juhl.blog
Sign In or Register to comment.