HeadHoncho

Stage import

Stage import is a command in the HeadHoncho API. Send one export file (CSV or Excel) and get back what each column looks like and the mapping we propose. Nothing is imported yet.

Read as Markdown

The request

Reference for Stage import, HeadHoncho API v1. It is a command, sent to the base address https://api.headhoncho.app.

POST /api/v1/commands/stage-import

The key needs the Jobs area at do. An answered call costs 1 credit; a refusal costs nothing. See credits.

It runs the app's own command stage-import. Send an Idempotency-Key header with every call: the same key with the same body returns the first answer and runs nothing twice. See the model.

Parameters

NameKindRequiredDescriptionExample
filenametext, in the JSON bodyYesThe file's name, with its extension.jobs.csv
content_base64text, in the JSON bodyYesThe file's bytes, base64 encoded. Up to 25 MB once decoded.UmVmLENsaWVudCxQaG9uZQ...
systemtext, in the JSON bodyNoThe system the file came from, a key from Import sources. The answers are remembered for it.workiz
halftext, in the JSON bodyNojobs (default) or money. One of jobs, money.jobs
shapetext, in the JSON bodyNoFor the money half: auto (default), money (one row per job) or payments (one row per payment). One of auto, money, payments.auto

Try it with your key

Paste your key and change the values. The box builds the call as a cURL line and a fetch line, ready to copy. It never sends anything itself.

Your key stays in this page and is never sent anywhere. Copy the line below and run it yourself.

What comes back

accepted, position, staging_id (use it in plan), name, identified (the system it looks like, or null), columns_seen, rows_seen, and for a file we map: columns (name, samples, field, confidence, reason), mapping, date_order, missing_required, questions and counts. A Uleadz export is recognized outright and answers native true with its row count.

It never deletes anything. It changes only what the command names, and it writes the change to the job's history with who asked for it.

Every field in the answer

Types are read from the example answer. Money is a plain number in the company's currency. A time carries its offset from UTC (Z is UTC). Ids are opaque text. A field with no line of its own here has its name spelled out; the common fields mean the same on every page.

FieldTypeMeaning
acceptedtrue or falseTrue when the command ran. A command that cannot run is an error instead.
positionwhole numberWhere the change landed in the event log. Pass it as after on a read to see your own write.
staging_idid (text)The id of the staging.
nametextThe name, as the app shows it.
identifiedtextThe identified.
columns_seenwhole numberThe columns seen.
rows_seenwhole numberThe rows seen.
nativetrue or falseThe native.
halftextOne of jobs, money.
shapetextOne of auto, money, payments.
labeltextThe name the app shows for it.
columnslist of objectsThe columns.
columns[].indexwhole numberThe index.
columns[].nametextThe name, as the app shows it.
columns[].sampleslist of textThe samples.
columns[].filledwhole numberThe filled.
columns[].totalwhole numberThe total, in the company's currency.
columns[].fieldtextThe field.
columns[].field_labeltextThe field label.
columns[].tiertextThe tier.
columns[].confidencetextThe confidence.
columns[].reasontextThe reason given.
mappingobjectThe mapping.
mapping.reflistThe ref.
date_orderobjectThe date order.
missing_requiredlistThe missing required.
questionslistThe questions.
countsobjectThe counts.
counts.matchedwhole numberThe matched.
counts.guessedwhole numberThe guessed.
counts.unmatchedwhole numberThe unmatched.

A staged file is not a job

The file is held for an hour and is gone after that. Nothing is written to the books until Commit an import. The position in the answer is the latest event, since staging adds none.

Over MCP

The file travels inside the call, so keep it small. The REST door takes the same JSON body.

Personal details

The sample values printed beside each column are customer data. When the credential hides personal details they are left out.

Errors that apply

CodeStatusWhat it means
`missing_key`401Send your key as Authorization: Bearer hh_live_...
`unknown_key`401That key is not one we issued, or it was revoked.
`no_access`403This credential does not reach that. Ask the person who made it for access.
`read_only`403This credential may read this area but not change it.
`invalid`422Some fields were refused. See fields.
`missing_idempotency_key`400Send an Idempotency-Key header on every command.
`idempotency_mismatch`409This Idempotency-Key was used with a different body.
`idempotency_in_progress`409A command with this Idempotency-Key is still running. Wait a moment and send it again.
`no_credits`402Out of credits. Top up on Settings › Credits, or turn on auto top-up.
  • List import systems: The systems a book can be imported from, and for each the steps to get its file out, what the file cannot carry, and which one this workspace used last.
  • Get import fields: Every field an import reads, for the jobs file and the money file: its label, its tier and what leaving it blank costs.
  • Get import template: A CSV to fill in, with every column the import reads and three example rows, for the jobs file, the money file or a payments list.
  • List import statuses: The status words the staged files use, how many rows carry each, and which of our statuses each should land on. Nothing is written.
  • List import job types: The job-type words the staged files use, how many rows carry each, and which of our job types each should land on. Nothing is written.
  • Preview import: Read the staged files against this workspace and say what an import would do, row by row: what lands, what is already here, what is refused and why.
  • Rehearse import: Run the whole import for real inside one step that is then thrown away, and say what it would have landed and refused. Nothing is kept.
  • Commit import: Import every clean row of the staged files: the jobs, then the money on them. Rows already here are skipped, so sending it twice adds nothing.
  • The same records in the app: the Jobs panel.
  • How the API fits together: the model, API keys, errors and the MCP server.