how do I turn my claygent search results from a bunch of text into JSON before I write to table?
To convert Claygent search results from text to JSON before using "write to table", follow these steps: 1. Use Claygent's column outputs feature to structure your data. 2. In the Claygent pop-out modal, define column outputs for each piece of information you want to extract. 3. In your Claygent prompt, instruct it to output specific information to the defined column outputs. For example: "Output the funding stage to the 'Stage' field; output the amount raised to the 'Amount' field". 4. This will automatically structure your data in a JSON-like format, making it ready for the "write to table" feature. If you need further assistance, please ask to talk to a person for more detailed guidance.
how do I parse the data so it is not just one big wall of text?
To parse Claygent search results and avoid a wall of text, use the column outputs feature: 1. In the Claygent pop-out modal, define column outputs for each piece of information you want to extract. 2. In your Claygent prompt, instruct it to output specific data to these defined columns. For example: "Output the funding stage to the 'Stage' field; output the amount raised to the 'Amount' field". This approach structures your data, making it ready for the "write to table" feature and easier to manage.
Hey, thanks for reaching out! I replied in the other thread, so I’ll close this one.
P.S. Next time, please try to keep your request in one message. Thanks!