web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Option field not retur...

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

Suggested answer

Option field not returning correct value in API

(1) Share

Report

Report

Posted on by AK-13051749-0

124

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 Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Teagen Boll 183 on at

Like (0)

Report
Option field not returning correct value in API

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('_x0020_', ' ')); 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

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 2,267

#2

Sumit Singh 2,098

#3

YUN ZHU 1,766 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans