Supply chain | Supply Chain Management, Commerce

Nice Label JSON escape character

(6) Share

Report

Posted on by CA-08101231-0

Hello Community,

Looking to see if there is a method to replace/remove the JSON escape characters (",/).

To reproduce

Warehouse management > Setup > Document routing > Label layout
Set Label layout type = License Plate Label
Under Data variables
- Set Variable name
- Set Value (with the escape characters replaced/removed)

Warehouse management
Setup
Document routing
Label layout

I have the same question (0)

All responses (7)

Answers (0)

Jonas "Jones" Melgaard 4,926 Most Valuable Professional on at

Like (0)

Report

I don't recall having seen a parameter that can do this, I'm afraid you are looking into making a customization.

But it sounds a bit odd... Can you share some of the label file with the escape character present?

Was this reply helpful? Yes No
CA-08101231-0 22 on at

Like (0)

Report
Our current dilemma is that we require the Item Name on the LP label. Example of an item = 1/4" pipe

With the layout of the label as below, the JSON created results in

"Variables": [ { "ItemId": "1000-0934", "ItemIdBC": "1000-0934", "ItemName": "1/4" Pipe", } ]

Thus, causing an error when sending.

Was this reply helpful? Yes No
Suggested answer

Jonas "Jones" Melgaard 4,926 Most Valuable Professional on at

Like (1)

Report

I see. It can be problematic having quotation marks (") in item names.

Is it out of the question to change the item name?

I was about to recommend using custom formats, but it seems that this approach is limited when it comes to strings. See here for more information: Document routing label layouts - Supply Chain Management | Dynamics 365 | Microsoft Learn

I'm afraid that my best answer is to create a display method on the WHSLicensePlateLabel table that escapes the quotation marks, and then you can add that method as an attribute.

Was this reply helpful? Yes No
Suggested answer

Anton Venter 20,345 Super User 2025 Season 2 on at

Like (1)

Report

Escaping the " character is better than removing it. It should be possible with a small customization.

https://stackoverflow.com/questions/19176024/how-to-escape-special-characters-in-building-a-json-string

Was this reply helpful? Yes No
CA-08101231-0 22 on at

Like (2)

Report

Thanks Jonas.

I dug a little further through the code and Microsoft is hard coding the format when creating the translation from the values.

Was this reply helpful? Yes No
Jonas "Jones" Melgaard 4,926 Most Valuable Professional on at

Like (1)

Report

These classes are internal, unfortunately.
Ideally, you could raise an extensibility request to Microsoft and submit it as a bug (i.e., it should be possible to select the formatting when configuring the label layouts).

But until the request is processed, since it's hard-coded, you will have to write your own display method to handle the escaping.

Was this reply helpful? Yes No
Jackson Eagle 20 on at

Like (0)

Report

Hey, I’ve run into this exact issue before — the problem is the double quote in your string ("1/4" Pipe"). JSON doesn’t like unescaped quotes, so it’s breaking the payload.

Easiest fix is to escape those quotes before sending the string. If you don’t want to write a quick script, you can just use JSON Escape tool. Paste in your text, and it’ll automatically escape the special characters.

If you want to double-check the result, you can run it through JSON Unescape tool— it converts it back so you can verify you’re not escaping too much or too little.

Once you use the escaped version in your label code, the error should go away.

1 people found this reply helpful.

Was this reply helpful? Yes No