https://community.databricks.com/t5/data-engineering/how-to-save-json-data-to-delta-table-parseerror-on-insert/m-p/34408#M25163 <P>I'm trying to save the returned json data from a requests API call to a Delta Table. I get a ParseError when I INSERT the response object which is in json format. The error shows the json data and a marker that states a ' or } or ) is missing. I validated the json data. Why is the INSERT process trying to parse the json data? Is there another way to INSERT the data?</P><P></P><P>json_data = response.text</P><P>query = f"INSERT INTO database.table VALUES ('{json_data}')"</P><P></P><P>spark.sql(query)</P> Wed, 17 Aug 2022 14:53:22 GMT Gabriel0007 2022-08-17T14:53:22Z https://community.databricks.com/t5/data-engineering/how-to-save-json-data-to-delta-table-parseerror-on-insert/m-p/34408#M25163 <P>I'm trying to save the returned json data from a requests API call to a Delta Table. I get a ParseError when I INSERT the response object which is in json format. The error shows the json data and a marker that states a ' or } or ) is missing. I validated the json data. Why is the INSERT process trying to parse the json data? Is there another way to INSERT the data?</P><P></P><P>json_data = response.text</P><P>query = f"INSERT INTO database.table VALUES ('{json_data}')"</P><P></P><P>spark.sql(query)</P> Wed, 17 Aug 2022 14:53:22 GMT https://community.databricks.com/t5/data-engineering/how-to-save-json-data-to-delta-table-parseerror-on-insert/m-p/34408#M25163 Gabriel0007 2022-08-17T14:53:22Z