Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Allow csvbox import to modify status #176

Open
wants to merge 4 commits into
base: master
Choose a base branch
from

Conversation

bohdan-vorona
Copy link
Contributor

@bohdan-vorona bohdan-vorona commented Mar 27, 2023

The sample template is attached.

Guide:

  1. 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)
  1. Edit Sheet -> Display -> Update the field Help Text. So here you can add information that there is one additional field - Status.

  2. 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.

  3. 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.

  4. 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:

csvbox-swagger

API Statuses:

csvbox-api-statuses

CSVBOX:

api-statuses-csvbox

Map columns:

csvbox-map-columns

Statuses column:

csvbox-statuses-column

Status selection:

csvbox-status-selection

Webhook data:

csvbox-webhook-data

@bohdan-vorona bohdan-vorona added the enhancement New feature or request label Mar 27, 2023
@bohdan-vorona bohdan-vorona self-assigned this Mar 27, 2023
@bohdan-vorona bohdan-vorona linked an issue Mar 27, 2023 that may be closed by this pull request
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

Successfully merging this pull request may close these issues.

Allow CSVBOX import to modify status[FEATURE]
2 participants