Problem with special character format in collection run

Good morning,

I’m in trouble with a special character in my json.
When my json contains the character ASCII 150 ( this character – ), the collection runner returns me a symbol with a “quotation mark” �.

Could you help me please?
Thanks in advance

Hey @lucat10 :wave:

Did you have a sample JSON file that we could see that shows this?

What is the data sent to the server during the run?

Sure!

This is a snippet

{
"Row":2,
"ProjectId":"866A",
"Classification":"A07 – APX8",
"DateTime":"2023-05-16T11:51:21"
},

The problem is in the tag “Classification”. As you can see this character – has been used, despite the “classic” -

Must be something in the format of the text file.

If I copy and paste your example into a new text file with the JSON extension, then its working ok for me.

[
    {
        "Row": 2,
        "ProjectId": "866A",
        "Classification": "A07 – APX8",
        "DateTime": "2023-05-16T11:51:21"
    }
]

You also have hyphens in the date, and they appear to be coming through ok.

How is the JSON text file being generated. Is it in ANSI or UTF format?

If you open the file in Microsoft Notepad, and then click on “Save As”, it should tell you what format its being saved as.

image

Try resaving the file as UTF-8 if its not already as that is what is working for me.

If I save as ANSI, then I can replicate the issue.

image

1 Like

Thanks Mike, it works!

You’re always helpful.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.