Troubleshooting JSON Parsing Issues in Formulas

Hey! I can't parse JSON using formulas - it's only working for one row and for the others, it doesn't (of course, for the ones that have data in the "ICP determination" response) Am I doing something wrong? Thanks!

8 comments

Channeled
APP
·
·
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Samuel R.
·
·
I just saw the error, thanks!
LuisArturo
·
·
Hey there Samuel thanks for reaching out could you post a link to the table where you are seeing this so we can take a look. This may either be size limitation issue if the cell size exceeds the limit or it may be that data type does not match what the column is expecting to see, in this case text.
Samuel R.
·
·
Hey Arturo! Thanks for your response! Well what I did was to basically reduce the size of the cell and apparently it works. It looks like it doesn't show up everything in the cell because of the cell limitations so the last string doesn't appear and that's why it didn't parse it
Arturo O.
·
·
Got it, thanks for letting us know and the update. Of course, feel free to follow up if you're still experiencing issues with the configuration!
🙏1
Channeled
APP
·
·
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
Channeled
APP
·
·
Hi Samuel R.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback Samuel R.!