Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
EXTRACT INFO FROM A JSON
Hi Guys, i have an integration and i need to do a custom search and extract from a json the order number, Im using this formula
SUBSTR({namefield}, INSTR({namefield}, 'order'), 5)
But it is not bringing me the information i need. I tried also changing the format to text and i saw the system just cut the json like in the middle and i think thats why it did not bring me the order number, because its at the bottom of the json.
There is a way to extract this in a custom search?
0