Structure/Fields order on JSON Output file

[LogSupp]

Hello,

When I use XML as output file format, it keeps the same fields order than the grammar definition and the translation secuence but when I use JSON output, the field seems to be in random order.

Is there any way to keep the same grammar and translation structure/fields order for a JSON Output File ?  

Thank you,

  

[Henk-Jan Ebbers]

no, there is not.

(bots is using a dict here, where the sequence of fields is not under control.)

kind regards,
Henk-Jan Ebbers
www.ebbersconsult.com
t: +31 6 14612879

Bots Open Source EDI Translator: http://bots.sourceforge.net
Connect edi-partners at lower costs by smarter testing: www.edi-testrobot.com

--
You received this message because you are subscribed to the Google Groups "Bots Open Source EDI Translator" group.
To unsubscribe from this group and stop receiving emails from it, send an email to botsmail+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/botsmail/e4cfc3af-6399-4ba5-8196-d84d05b5c08bn%40googlegroups.com.

[BikeMike]

Hi,

JSON is in fact unordered by design. You should not attempt to force a specific ordering, and any recipient of JSON data who expects specific ordering has a badly designed process. (eg. they have implemented their own brain-dead parser rather than using a standard library, of which there are many for all common programming languages)

Refer to RFC8259 (or 7159 or 4267) that states in the introduction: An object is an unordered collection of zero or more name/value pairs, where a name is a string and a value is a string, number, boolean, null, object, or array.

Kind Regards,

Mike

[BikeMike]

Maybe you could write a postprocessing script using OrderedDict and read/re-write the JSON output in the order the receiver wants it (but ask them first if they can fix their parser!)

[LogSupp]

Hi Mike /Henk-Jan,

Thanks for your replies, I will explore the postprocessing script using OrderedDict.

Regards,

LogSupp

[Eppye Bots]

I do have version that uses sequence as in grammar.....

if you're interested.

kind regards, Henk-Jan Ebbers

To view this discussion on the web visit https://groups.google.com/d/msgid/botsmail/3aa59f26-dd8a-4a66-86a1-a13e4dbb7d0bn%40googlegroups.com.

[LogSupp]

Hi Henk-Jan,

Yes, i'm interested on it, please let me know how we could do.

Regards,

[Eppye Bots]

see attachment (rename to .py)

kind regards, Henk-Jan Ebbers

To view this discussion on the web visit https://groups.google.com/d/msgid/botsmail/830d8596-646a-4257-9d95-1c92eff20bcdn%40googlegroups.com.

[LogSupp]

Hi  Henk-Jan,

it worked like a charm!

Thank you so much!

Regards,

LogSupp,

[BikeMike]

Probably makes sense for this to be standard Bots behavior, even though json is supposed to be unordered.

[Lee Pedley]

How do we use this structured grammar?