Skip to main content
Question

JSON Deserializer to Table issue


Forum|alt.badge.img+8
  • Navigator | Tier 3
  • 63 replies

When using JSON Deserializer to Table, AA puts the columns in the wrong order.

This AA Action doesn’t have any configuration properties so there’s no control over the column order. Why is this action putting the columns in this order?

3 replies

Forum|alt.badge.img+8
  • Navigator | Tier 3
  • 52 replies
  • June 27, 2024

Ordering matters only in JSON Array not Object. Use keys/column name to parse JSON Object?


Forum|alt.badge.img+8
  • Author
  • Navigator | Tier 3
  • 63 replies
  • June 27, 2024

Ok but what is the logic in how that AA command works? It can’t be random, right? 


Forum|alt.badge.img+8
  • Author
  • Navigator | Tier 3
  • 63 replies
  • June 27, 2024

So here’s the situation, we are moving from using a static file in the control room to fetching data from a source using an API call which brings back this JSON. We have a lot of existing code that references this the table and specific column positions. We’re trying to avoid rework by putting the JSON Array in a specific order. Why have a “JSON Deserializer to table” action if it puts things in a random or inconsistent order?

We can certainly write a lot of code that loops through the JSON, finds the keys, and populates a table the way we want, but that’s way more work than just re-coding the lines to new column positions (or using column names instead).

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings