Before you start
Use a published ordinary survey and a stable identity field. Review the complete file before applying changes.
Open: API integration → /api/csv-import.
Steps
- Read the published survey definition and record the question IDs for each incoming column. Keep an identity question, such as item code, in the mapping.
- Prepare the uploader request with upsert mode, the imported question IDs, identity question and complete expected row count.
- Upload the unchanged CSV, complete the upload and poll for the review summary.
- Inspect proposed inserts and updates. Decide whether blank incoming cells should clear existing values using clear_blanks.
- Apply the exact review token and verify the completed row count and a sample of changed records.
Check the result
Matching identities update the intended ordinary records and new identities create the appropriate rows.
Troubleshooting
If the review is stale, prepare a fresh preview against the changed list. Duplicate or missing identities should be corrected in the source file before applying. Keep response IDs and prior extracts for reconciliation without rewriting survey history.