Final Mile Facility Maintenance

Final Mile Facility Maintenance can currently be done only using CSV load. Maintenance screens are in the backlog for development.

Rules for creation and update of Final Mile Facilities

1. When a record is loaded with a location that is already disabled

   1. that location will not be updated and

   2. a new one will not be created.

   3. An error will occur in the database for this record

2. To update a record, the Company Code and Final Mile Facility Code must match the existing record.

CSV File Contents

The CSV File should have a header line containing the following fields. The company code and final mile facility code should be unique.

Note

If the Company Code and Final Mile Code are changed after the record has been loaded, a new record will be created which will look like a duplicate. Therefore it is important to keep them the same at all times.

CSV Fields

Load Final Mile Facility using CSV

You will need

• Client authorisation token for Production or UAT depending on the environment being updated

• CSV file in a specific format

How to load the CSV File

Swagger can be used for loading the final mile facilities. Press “Try it out”, authorise the token, select a file and press Execute.

• Production system: https://api-whiteglove.seko360.com/swagger/index.html

• UAT system: https://api-whiteglove-uat.seko360.com/swagger/index.html

Authorise

First, click Authorise to enter the credentials for the database which will be updated. This value is confidential and should not be shared under any circumstances.

...

Select Organisations

Second, select Organisations and press “Try it out”

...

Select CSV File

Select the CSV File using

...

Press Execute

...

After a while you should see some results in the black pane and any errors should also be shown.

...