Problem with special character format in collection run

[lucat10 (Luca)]

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

[danny-dainton]

Hey @lucat10

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?

[lucat10 (Luca)]

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” -

[michaelderekjones (Mike Jones)]

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.

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

[michaelderekjones (Mike Jones)]

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

[lucat10 (Luca)]

Thanks Mike, it works!

You’re always helpful.