Orchestrator queue schema for field of type string not accepting values with digits only

Hi,

I defined a schema for the Orchestrator queue. One of the fields is of type string. However, when I tried uploading items using a CSV file, that field didn’t accept values consisting of digits only.

I did enclose such values with double quotes in the CSV file, e.g. “1234”, but it didn’t help. It worked when I changed the value to 1234A (with or without double quotes).

When I checked JSON Schema - string, it did mention to enclose all digits with double quotes.

Any idea how to format this correctly in the CSV file, or whether it is an issue elsewhere?

Thanks.

Hi @judewong ,
UiPath runs on .NET in the background as its scripting language. For working with JSON, you can refer to the Newtonsoft JSON Schema documentation: https://www.newtonsoft.com/jsonschema :white_check_mark:

If you’re preparing the CSV in Excel, you can:

  • Format the column as Text.

  • Use a formula: =“1234”

Else
To enclose number in quotes you need to use escape chars in studio like some_value = """1234"""

Put a single quote ' before the 1234 value.

That will end up with the value in the queue item actually having the double quotes as part of the value, which isn’t what you want and doesn’t solve the problem.

@judewong

looks like a bug any format of number is interpreted as number only and not as string

@postwick even a single quote addition is actually making it appear in queue item

for now a work around would be to add a special character so that it gets added and handle it in studio when retrieving

cheers

Unfortunately, the single quote ended up being part of the string. Thanks anyway.

What a shame. Hope this bug can be fixed soon.

1 Like

I managed to find the solution to my issue. When uploading the CSV file containing the data items, make sure the Dynamic typing option is unchecked.