Inserting and Updating Tables with Aggregate Data

JSON is the accepted format for updating or inserting data for Cvent tables that contain aggregate values.

Below is an example of the HomeAddressAggregate field data from the Contacts table.

		INSERT INTO Contacts (firstName, lastName, email, HomeAddressAggregate) VALUES ('CventContactFirstName', 'CventContactLastName', '[email protected]', '{"regionCode": "TX"," "address1": "Cvent Inc.", "address2": "4001 West Parmer Lane", "address3": "PO Box 123", "city": "Austin", "countryCode": "US", "postalCode": "78727"}')