https://di.no/doc

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 29 Next »

Introduction

For integration purposes there are some APIs that are useful to import data into Plan & Go and also to be able to export.

Security / authentication

For each session, first get authenticated with /pl/api/v-1/auth/generate, then use the received token in the header for all the other calls. Like this:

# Example 1) Posting JSON (when logged in, we send the token in the header)
curl https://planandgo.di.no/pl/api/v-1/routePlan \
  -H "Content-Type:application/json" \
  -H "X-Auth-Token:olof:5f9a3609a5a295eff861d930a0c75bbee7991842" \
  -d "{ \
    \"companyId\": 1, \
    \"date\": '2015-12-04T00:00:00.000+0100', \
    \"name\": \"Utkjoring uke 9\" \
  }"


# Example 2) posting FILE (when logged in, we send the token in the header)
curl https://planandgo.di.no/pl/api/v-1/file/999999 \
  -H "Content-Type: multipart/form-data" \
  -H "X-Auth-Token: olof:5f9a3609a5a295eff861d930a0c75bbee7991842" \
  -F file=@my_import_file_in_this_dir.csv

Environments

  • DEV: https://dev-planandgo.di.no
  • STAGING: https://staging-planandgo.di.no
  • PROD: https://planandgo.di.no

API-methods

#
Endpoint / DescriptionExample - RequestExample - Response
1


POST /pl/api/v-1/auth/generate

Fetches an login-token that the application can use to gain access to the API.

Get the username/password from DI.

{
    "username": "olof",
    "password": "secret123"
}
{
	"token": "olof:5f9...842",
	"userId": 23432,
	"customerSystemId": 233,
	"roles": [...]
}
2

🔐

POST /pl/api/v-1/routePlan

Create an empty route plan (for a given distribution date).

companyId: The ID of the transport company. Ask DI for the correct value(s) to use.

NEW distrNo: A grouping mechanism used to separate different distributions during the day (for the "Customer Plus"-view).

Values:

  • 0: N/A (default, same as omitting the field)
  • 1: Night
  • 2: Morning
  • 3: Before noon
  • 4: Afternoon
  • 5: Evening

Will be used for:

  • group plans within same distribution/date
  • ensure that "use-same-route-as-last-time" for addresses don't overlap with other distributions. An address can be part of route "101" on Monday morning, but part of "203" on Monday evening. This will be remembered as long as distrNo is used. Looks for previous route on same distribution/distrNo.
{
    "companyId": 1,
    "date": "2015-12-04T00:00:00.000+0100",
	"distrNo": 0,
    "name": "Utkjoring uke 9"
}
{
	"id": 344,
	"date": "2015-12-04T00:00:00.000+0100",
	"distrNo": 0,
	"name": "Utkjoring uke 9",
	...
}
3🔐
POST /pl/api/v-1/routePlan/<rp_id>/customerSystem/<cs_id>

Create an empty file (prepare for a file-upload).

Step 1 in file upload.

rp_id: The returned routePlanId from previous call.
cs_id: Ask DI for the correct value to use (or look at the response from /auth/generate)

{
    "name": "my-file-name.csv"
}
{
	"id": 6722,
	"name": "my-file-name.csv",
	...
}
4🔐
POST /pl/api/v-1/file/<f_id>

Upload the content of the file you have prepared.

Filetypes supported:

  • .csv
  • .xls
  • .xlsx

Mimetype: multipart/form-data. Name the file-field: "file". See file specification.

Step 2 in file upload.

f_id: The returned fileId from previous call.


{
	"status": "ok"
}
5🔐
GET /pl/api/v-1/customerSystem/<cs_id>/publishedOrders/<yyyy-mm-dd>

Fetch the published orders including the routename of each order. Also added which pickupLocation the route has.

routeId and pickupLocationId is our internal IDs and will be generated for each new distribution date. Use them only for sorting/grouping if you want an integer instead of a string for that.

companyId tells you which distribution company is handling the order.

Included for each order is an estimate for WHEN the order will be delivered. It's a time interval like this: HH:MM-HH:MM.

This will return orders across many routePlans, but only from published plans for the given distribution-date.

(info) Assumes that imported customers/deliveries used the ORDER_ID field. This is your reference.

cs_id: Ask DI for the correct value to use (or look at the response from /auth/generate)


List of orders

[
	{
		"companyId": 1,
		"orderId": "768787",
		"routeName": "Sentrumruten",
		"timeWindow": "20:00-23:00",
		"estimatedTime": "16:43",
		"routeId": 6225,
		"pickupLocationId": 988,
		"pickupLocationName": "Storgata 11A, 1234 OSLO",
		"cancelled": false
	},
	...
]

Usage

When the deliveries are ready on your end

  • Generate a token for the session
  • Repeat these steps for each transport company
    • Create an empty routeplan, to get a fresh routePlanId (do this for each area that has it's own starting point)
    • Create an empty file, to get a fresh fileId
    • Generate a file (using our file-spec) and post it with the fresh fileId. Remember to fill out ORDER_ID (used as key when exporting optimized plans)
    • Look for status: 'ok' or handle errors

When the plan is optimized and published - at a agreed time

  • Generate a token for the session

  • Fetch the orders and extract the routename from there (for a given customerSystem and distribution-date)
  • No labels