Uploading & ingesting data
There are two ways to get records into an artifact source: upload a file, or send data through the API.
CSV upload
Section titled “CSV upload”Upload a CSV directly. Admire detects the columns and adds any new ones to the source automatically, so you can start from a spreadsheet without defining the schema by hand.
API ingestion
Section titled “API ingestion”For ongoing or automated feeds, send records through the API — up to 500 records per call. This is the route for syncing data from another system on a schedule.
Deduplication
Section titled “Deduplication”Each source has an explicit external-ID column — the identifier each record carries from its origin system. Admire deduplicates on that column within the source: re-sending a record with an external ID it has already seen updates the existing row instead of creating a duplicate. That’s what makes repeated syncs — and re-uploading a corrected file — safe to run as often as you like.
With data loaded, query it to power reports and metrics.