...
Booking Enquiry and Submit
Open the spreadsheet and ensure macros are enabled.
When you login to the PortConnect API Developer Portal, go to your profile and under Your Subscriptions you will see your keys. Copy the Primary Key and paste this into the Settings tab of the spreadsheet.
Start filling in the required fields with your booking details and then click Submit
...
To fill out the Hazardous field you need to enter the same BookingItem Id from under the BookingItems section that relates to the UN number and class.
You will get a “successful” message box appear.
...
The Booking API spreadsheet has an option to check the current state of a booking. We recommend using this function after you submit an update. This will let you confirm that the booking has saved in our system exactly as you have submitted it.
Go to the ‘Booking Enquiry and Submit’ sheet in the spreadsheet.
Enter the Booking Number in cell A5
Click on the ‘Retrieve Booking’ button
This will then populate all of the booking information in the spreadsheet
If the booking has not been submitted or it has been cancelled, you will receive this pop-up message:
...
Cancel macro
Cancel macro allows you to cancel your bookings in PortConnect.
...
Pre-Advise containers for LINK
Open the spreadsheet and ensure macros are enabled.
Storage Pre-Advice sheet > Enter empty container numbers and container ISO type codes into the required cells.
Select the cell of the first container number and click ‘Submit’ to pre-advise empty containers in the list to the Ports of Auckland LINK depot.
In the Response column, containers will display as successfully processed.
...