Adding new rows through email automation and Json

Ask for Help
1

I am having continued issues with Json.

I am working with email attachements, extracted text, Ai to Json and then struggling to query into rows.

1
12474Ă—1550 88.6 KB

Untitled 2
Untitled 22464Ă—1396 112 KB

Untitled
Untitled2896Ă—1482 268 KB

1 Like
2

What do you mean by “query into rows”?
Can you explain exactly what you are trying to achieve with the Query step in your workflow?
I’m guessing that you’re trying to access one of the attributes from the Text to JSON step, but what would you then do with that?

2 Likes
3

I’m emailing an invoice to the email automation trigger. I’m passing the invoice information as text, then using the AI to JSON tool to extract key attributes and create a JSON string. I then need to query those individual JSON elements and insert them into a new row. However, it’s not letting me add a new row, and I can’t query the JSON to identify the key attribute that should go into the new row.

1 Like
4

I see. So in that case you need the Query step before the Add Row step.
And you’ll need a separate Query step for each JSON key that you want to Query. I would recommend avoiding the use of multiple word keys such as “Vendor Name”. Instead use something like “vendorName” or “Vendor_Name”. That will make them easier to reference in the Query steps.

2 Likes