Skip to content

DROP response file checker

Choose the Id,Status files you are about to upload to DROP. The checker reads them in this tab and reports problems DROP would reject or that would leave work items unanswered: the header, the status codes, duplicate IDs, the file name and the size of one upload.

Wooden card-index cabinets in a national archive reading room
Card index, National Archives of Finland

Checked in this tab. The files are not uploaded anywhere.

Results appear here: one panel per file.

What is checked

  • The first line is exactly Id,Status.
  • Every row has two values, an ID of letters and digits and a status of 2, 3, 4 or 5.
  • No work item appears twice in a file.
  • The file name has the date, a broker ID and one of the six list names: NDZ, Email, Phone, MAID, NameVIN, CTVID.
  • No more than 10 files and 100 MB are chosen together, the limits of one upload request.

Which status to give each work item is explained in the status codes guide. How uploads work is in the DROP API guide.

CalDrop Compliance is an independent product of Preptics LLC. It is not affiliated with, endorsed by or operated by the State of California or the California Privacy Protection Agency (CalPrivacy). This tool explains the rules; it is not legal advice.

Questions

Something else? Write to us and a person answers within one working day.

What does a DROP response file look like?
A CSV with the header Id,Status and one row per work item: the work item ID from the batch and a status of 2 (exempted), 3 (deleted), 4 (opted out) or 5 (not found).
How should the file be named?
Like the batch file it answers: the batch date, your DROP broker ID and the list name, for example 20261120_1234_Email.csv. A suffix after the list name is allowed when you split a list.
How many files can one upload take?
Up to 10 files and 100 MB in one API request. Send larger answers in several requests.
Does a clean result mean DROP will accept it?
It means the format is right. The checker cannot know which work items were in your batch; a status missing for a work item is still a missed request. CalDrop Compliance checks that against the batch itself.

Answer your next DROP batch on time

14-day trial on every plan. Run the practice batch first if you like.