How to Parse OPENAI node response

Questions
1

How to parse the repsonse from OpenAI node. I am currently using openAI to classify Bank transactions into Category, Group, and Keyword… I have it set to return a JSON but the returned json is not formatted correctly. I haven’t been able to figure out how to use json or jmespath to correctly parse the data, so i guess my real question is how to use json or jmespath to parse this openai data:

Screenshot_20230126_051814
Screenshot_20230126_051822

I’m open to any other solution as well, as this part of the workflow is CRUICAL to my project! MUCH thanks in advanced for anyone who spend even a second helping me learn!

2

Hey @nvenhuizen14,

Try using {{ JSON.parse($json.text) }} in a set node, This will return something like this…

image
image1482×718 78.3 KB

Example workflow to produce some Pineapple based JSON…

1 Like
3

Thank you for responding!

unfortunately with {{ JSON.parse($json.text) }} i receive undefined :confused:

Screenshot_20230126_053622
Screenshot_20230126_0536221885×898 40.2 KB

4

Is this the same topic as this?

1 Like
5

yes i apologise. I did not explain my situation well in the last one and couldnt figure out how to delete it

6

Hey @nvenhuizen14, it seems like your openAI node is not returning correct JSON as it’s missing the outer {}. Try something like this:

1 Like
7

YUP THAT DID IT! thank you man! that’s been driving me crazy! lol

1 Like
8

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.