Is there a way to have the output of an enrichment column be one column of the full JSON output. For example, if I am using People Data Labs > Enrich Company , instead of having the output be columns (Name, Size, Founded, etc.) that were selected in the enrichment I just want a single column with the full JSON object.
Yes, you can reference the entire enrichment as a single JSON object. When working with enrichment columns, you can access all data returned by an enrichment at once by selecting "Insert all properties" to reference the entire enrichment. This gives you access to the complete JSON response instead of individual mapped columns, allowing you to work with the full dataset from your People Data Labs enrichment in a single column.
I tried to do that using a formula but the output throws an error saying the value could not be converted to the columns data type.
This error typically occurs when there's a data type mismatch between the JSON output and your column format. To troubleshoot this issue, could you copy and paste the JSON data you're trying to reference into the chat? This will help identify any formatting issues or data type conflicts. The error often happens when the column expects a specific data type (like text) but receives a complex JSON object. Make sure your target column is set to handle the appropriate data type for the full JSON response.
