Create a new (or edit the current one) CSVBOX template similar to the current one but add a new field to the end.
Column Name: Status
Column Type: Dynamic List
List Source API URL: GET https://shipwise.ngrok.io/v1/statuses
Don't check "Required" (important)
Edit Sheet -> Display -> Update the field Help Text. So here you can add information that there is one additional field - Status.
The field is optional. It means that the current template (without the field) will work as the new template (attached below; with the field) as well.
Since CSVBOX requires to have specific names for Dynamic Lists, I added the ability to change the key and the value of the statuses list in our API via GET parameters (added to the API docs). Default values = values needed for Dynamic Lists.
The sample template is attached.
Guide:
Edit Sheet -> Display -> Update the field
Help Text. So here you can add information that there is one additional field - Status.The field is optional. It means that the current template (without the field) will work as the new template (attached below; with the field) as well.
Since CSVBOX requires to have specific names for Dynamic Lists, I added the ability to change the
keyand thevalueof the statuses list in our API via GET parameters (added to the API docs). Default values = values needed for Dynamic Lists.If there will be an error pulling statuses from https://shipwise.ngrok.io/v1/statuses in the browser console, apply this -> https://stackoverflow.com/a/73271938/2964248
Order_Import_Example.csv
Swagger:
API Statuses:
CSVBOX:
Map columns:
Statuses column:
Status selection:
Webhook data: