Most Captain Data workflows need inputs to run.
Add Inputs
You can either add inputs one-by-one, or upload a CSV of inputs.
If you decide to update them one by one, simply copy and paste the url for each input.
You add as many inputs as you want by clicking on "+ new".
There's always a how-to on the right-panel if you need any help 🙌
IMPORTANT NOTE: A maximum of 1000 inputs is definitely recommended.
Import from a file
If you already have a file ready for import, you can upload inputs from a file.
You can upload any .csv or .xls with any set of columns.
Important: The file needs to follow a specific formatting to be processed properly.
In our example above, we expect a column "linkedin_profile_url" to validate your file.
How-to check the required input column name?
In the Workflow Configuration, you can find the required key name by clicking on the three dots next to the first step, then input.
You can drag & drop a file in the zone.
The column is perfectly mapped and you visualize all the imported data!
If you have an error, you probably don't have the appropriate headers on your CSV file.
You can also filters columns you want to see:
Add Metadata
Additionally, to the primary column, you can add as many columns as you want as "meta".
They will be mapped as extra column:
Columns are mapped as-is, e.g. we do not change them.
⚠️ We do recommend though that you use first_name instead of First Name.
(No capital letters and no spaces)
You will find this data in the meta column, all in JSON at the first step, and last step:
You can now unstructured your metadata! To do so, you just need to activate the Metadata Iterator option in your job’s launch settings > Configure output data > Inputs Meta Mapping, which will split each metadata into single columns:
Data Validation
Some workflows require additional data validation.
For example here it absolutely needs a linkedin_profile_url to be working so it gives you an error:
If you need, you can filter only invalid inputs by click "Show X input(s) with error(s)".
And if you hit the "Clear" button while selecting only inputs in errors, it will remove only the wrong inputs:
Google Sheets
If you're working with Google Sheets, you can download the spreadsheet as a CSV.
