Sorting JSON Objects in Excel: Claygent vs Formula
best way to sort a list of object inside of a single json in a cell? Claygent or Formula?
best way to sort a list of object inside of a single json in a cell? Claygent or Formula?
For sorting a list of objects in a JSON cell, you have two options: 1. Use the "Order a list with Clay" integration, which allows you to sort up to 100 items based on a specified sequence. 2. Use the "Filter List of Objects with Clay" integration to filter objects based on specific criteria. For complex sorting needs, Claygent is recommended as it can handle unstructured data and perform advanced operations. If you're experiencing JSON formatting issues, please copy and paste your JSON into the chat for troubleshooting.
i meant to sort bunch records inside of a single cell
To sort records inside a single JSON cell, you have two main options: 1. Use the "Order a list with Clay" integration to sort up to 100 items based on a specified sequence. 2. Use the "Filter List of Objects with Clay" integration to filter objects based on specific criteria. You can also access sorting options directly from the cell by clicking on it to open Cell Details, then hovering to the right of the list to see available actions like filtering or finding keywords. If you're experiencing JSON formatting issues, please copy and paste your JSON into the chat for troubleshooting.
but would "1. Use the "Order a list with Clay" integration to sort up to 100 items based on a specified sequence." sort the sheet by cell value?? I want to sort 10 objects inside of each cell independently for 1000 cells
To sort objects inside each JSON cell independently: 1. Click on each cell to open the Cell Details panel 2. Hover to the right of the list to access the action menu 3. Use "Filter or find keywords" option to organize the objects within that cell For more complex sorting needs across all 1000 cells, you can use: ** "Order a list with Clay" integration to sort up to 100 items based on a specified sequence ** "Filter List of Objects with Clay" integration to filter objects based on specific criteria If you're experiencing JSON formatting issues, please copy and paste your JSON into the chat for troubleshooting.