OData null values

Hi Peter,

It is possible to send NULL values by sending the following Header:

Accept: application/json; include_null_values=true

Hey Mark,

Thanks for the response but I don’t know how to translate your answer into action...

Maybe some screenshots makes it eayser for you to help me. This is the case:

When I empty the field “Opmerking” in the ERP the following result is shown in Insomnia:

The view ws_artikel from the ERP is formed by:

 select a.artikel_id
          ,a.opmerking                             
          ,ISNULL(a.status_art,0)
          ,a.produ_naam                         
          ,case when a.blokkering_igv_breuk_aantal=1 then 1 else 0 end
          ,a.magazijn
    from [cf_finas].[dbo].[artikel] a
    where a.magazijn='100'

Where do I have to activate your given solution to force the NULL-value in Opmerking to be exported ??

Hey Peter,

The correct way of adding this header can be done in the Header tab and doing the following:

On the left

Accept

And on the right

application/json; include_null_values=true

Goodmorning Mark,

I add your suggestion to my Insomnia-request but it returned an error:

When i de-activate the header with the check mark, the response is OK again.
Any suggestion ?

Hello Peter,

You are running into this problem because you’re using a very old version of Indicium.

We recommend to regularly update Indicium to the newest version in order to ensure continued support, having the latest stability and security fixes, performance improvements and new features, such as the one you are trying to use right now.

I would recommend using Indicium Universal for interfacing the web shop with the Thinkwise Platform. However, if you are using a Mobile GUI or a Windows GUI with RDBMS=indicium, then you will need Indicium (Basic) as well.

Hi Vincent,

Which (IU-)version is the earliest version in where this function is available or (better) which IU-)version do you recommend ? There is a lot of choice… 

Hello Peter,

I always recommend using the latest version of Indicium Universal, which is currently version 2021.1.17. Version 2021.1.17 does have two important changes, most notably the new .NET 5 requirement, which are described in detail in our release notes.

I could understand not wanting to update to .NET 5 right away, in which case I would recommend version 2021.1.16 of Indicium Universal instead.

Hi Vincent,

We have upgraded to 2021.1.16 but the request with this specificheader still returns a 500 error.

Hello Hugo,

Could you check Indicium logs to see what the error message is and share it here?

I don’t see anything wrong with how the header was added to Insomnia, but the screenshot below shows an example of how it should look. Perhaps an invisible character is making your value invalid. It could be worthwhile to make a new Insomnia request and carefully type the Accept header without copy-pasting anything. But we can start by looking at Indicium’s error log.