Optimize json format when connecting to LLM

Hi Community,

I want to change & optimize my json format. Within the attached workflow, left side shows current json and the right side shows desired output (sample data). I am not an expert on the JSON Build tool and hence, asking for recommendations.

Background/context:

I am using json format as part of my API call to a LLM.

The current format has redundant fields (repeated values for company name and comments fields) and I want to optimize the json format so I can ask the LLM to process less tokens.

JSON formatting.yxmd

desired output json format.PNG

API

Optimization

Accepted answers

apathetichell

fixed/tested in a json linter. seems fine. Note --- for the nested part I totally dropped the build tool and manually built it (which is what I would normally do).

JSON formatting2.yxmd

All comments

amadra

Anyone? Is this even possible using JSON Build?

apathetichell

You have to take a step back and figure out which is your outer JSON and which is your inner JSON. I don't think my format replicates yours but the JSON should be the same.

JSON formatting.yxmd

amadra

@apathetichell- This is great! Thanks for taking the time to put this together.
The only challenge is that the output is not a valid json format. I am trying to figure it out. Once I do, ill mark your answer as the solution.

apathetichell

fixed/tested in a json linter. seems fine. Note --- for the nested part I totally dropped the build tool and manually built it (which is what I would normally do).

JSON formatting2.yxmd

amadra

Genius!!

Its even better and also valid json. Leant so much about building json in Alteryx - just looking at your workflow!
Thank you very much 🤗

apathetichell

Glad that helps.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280