CSV Import - Check Records

Question

I am looking for help in importing a CSV file to a Company table that will check if the Company Name if it exists (text only as complete match) before importing.

This pipeline imports company data from a CSV file into a Quickbase table. It checks if a company already exists before creating a new record to prevent duplicates.

It fetches the CSV file (all+1300 rows) - This is test file and only has 3 rows

I receive the following error

Validation error: Incorrect template "{{c.company}}". ValueError: invalid literal for int() with base 10: 'company'

Attched are the pipeline steps

Thank you,

Eric

Mez · Answer

Usually this is a type mismatch. Is the "company" field a string, and is the value in the file a string? Or, is the field a number and the value on the file is being treated as a string? Can you share some more screenshots of the field and the data on this test file just to confirm?

If the value in the file should be converted to a number, you can do: {{ c.company | int }}

Sign up

Login to the community