Extracting JSON value from OpenAI node output into Notion
Hi all,
I have a GPT node that I'm asking to produce JSON that I would like to then use to populate the creation of a Notion page but I seem to keep running into trouble with formatting and/or accessing the object's properties in a way that Notion can accept.
I've tried setting the GPT output to a string and then using the Parse JSON node, but that just kept giving me an error of "error": "Unexpected token o in JSON at position 1".
When I've tried accessing the properties directly from the GPT node I keep getting an "undefined" error.
I suspect I just dont know how to properly setup the Notion node.
Any assistance is much appreciated.
Thank you!
Ahmad
2 Replies
Hi, could you please share the workflow file here or via support form? https://docs.buildship.com/features/copy-paste.
Hi @Gaurav Chadha , thank you for the quick response (and sorry for my delayed one).
I did finally end up figuring out what was going on...kind of a 🤦🏾♂️
For anyone that may run into the same thing, I've attached a screenshot. The issue I had was mismatch in mapping the Notion column headers to the input keys I was creating in the JSON file.
Thank you again Guarav!
