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

Option field not returning correct value in API

(7) Share

Report

Posted on by AK-13051749-0

274

Hello, I created a Customer API page and the "Blocked" field is not returning the right value.

It should be blank, but it is returning "_x0020_".

Does anyone know how to resolve this?

Any help would be greatly appreciated, thank you!

This is how I added the Blocked field to the Customer API:

"Blocked" is set to blank on the customer card.

The API is returning "_x0020_" for the Blocked (the caption is Status) value.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Teagen Boll 1,376 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!
That is the expected behaviour for some fields. x0020 represent the space " " character as part of certain API responses. You can decode values using AL with Text.Replace like this:

procedure DecodeValue(InputText: Text): Text begin exit(InputText.Replace(' ', ' ')); end;

There is more info on Encoding here: TextEncoding property - Business Central | Microsoft Learn and File handling and text encoding - Business Central | Microsoft Learn

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Hi, This is standard behavior; I've had this problem since I tested it a long time ago.

More details:

https://yzhums.com/51363/

https://yzhums.com/46655/

Hope the following can give you some hints.

https://yzhums.com/39365/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 12,803 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello,

just means the Blocked field is blank — it’s how Business Central encodes empty enum values in OData.
You can handle it by either treating as “Not blocked” in your app or exposing a text field (e.g., BlockedText) that converts enum values to readable text.

Ref: https://learn.microsoft.com/en-us/dynamics365/business-central/power-bi-faq#advanced-questions

Regards,
Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,555 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi, good day
I hope this can help you, and give you some hints.

Custom APIs and schemaversion 2.0 – Kauffmann @ Dynamics 365 Business Central

Dynamics 365 Business Central and Power Automate: conditions on empty field values – Stefano Demiliani

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Aman Kakkar 2,977 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Source - Power BI FAQ - Business Central | Microsoft Learn

Hope this helps.

Aman K

Was this reply helpful? Yes No