Skip to content

Instantly share code, notes, and snippets.

@dodeja
dodeja / 0README.md
Last active August 16, 2023 21:11
Terminal49 Data Sync Schema

Terminal49 Data Sync Table Schema

These files define the models (schema) that are used to synchronize the Terminal49 data with customer's datawarehouse.

More details on https://www.terminal49.com/data-sync/

@dodeja
dodeja / zim.json
Created December 14, 2021 18:15
ZIM Shipment Tracking payload
{
"data": {
"id": "3e406661-1f85-488e-9b17-036dc82cf3ac",
"type": "shipment",
"attributes": {
"created_at": "2021-10-17T14:56:09Z",
"ref_numbers": [
"ERGO"
],
"tags": [],
@dodeja
dodeja / 0_Tracking a Shipment.md
Last active January 23, 2021 22:44
Terminal49 API Guide

Terminal49 API Guide

1. Create a tracking request Cosco Shipment (COSU6283148530) going to LA.

curl --location --request POST 'https://api.terminal49.com/v2/tracking_requests' \
--header 'Authorization: Bearer 7ZhLRrr5Kpu5T9ue5wMaGEco' \
--header 'Content-Type: application/json' \
--data-raw '{
    "data": {
        "type": "tracking_request",
@dodeja
dodeja / ross.csv
Last active January 4, 2021 20:33
ref num CONTAINER Prefix scac
LD10362 MEDUHG271461 TTNU4015305 MEDU MSCU
LD9647 EGLV143076485803 HMCU1064041 EGLV EGLV
LD9984 CMDUNBST546418 CMAU7346392 CMDU CMDU
LD10279 EGLV143076489469 DRYU4149361 EGLV EGLV
LD10272 EGLV143076485943 CAAU5344517 EGLV EGLV
LD10577 MEDUXM983508 CAXU9756970 MEDU MSCU
LD10599 MEDUNN130475 MSCU5861630 MEDU MSCU
LD10597 MEDUNN130558 MSCU5577840 MEDU MSCU
LD10677 MEDUNN130533 GLDU0438430 MEDU MSCU
@dodeja
dodeja / tracking.html
Created December 6, 2020 02:36
Terminal49 Tracking Widget Embed Code
<script src="https://kit.fontawesome.com/cd34e860ca.js" crossorigin="anonymous"></script>
<div id="terminal49-tnt-widget" data-token="REPLACE_WITH_PUBLISHABLE_KEY"></div>
<script src="https://tnt-widget.vercel.app/app.bundle.js"></script>
@dodeja
dodeja / top_100_consignees.csv
Created November 13, 2020 01:22
US Import data March 2020
Consignee # Entries # Containers
N/A 233768 592125
IKEA SUPPLY AG 7123 14246
DOLE FRESH FRUIT COMPANY 5125 16416
SOL GROUP 4091 8243
UNTO THE ORDER OF 2407 4978
TO THE ORDER OF 2190 4519
J C PENNEY PURCHASING CORP 2115 4621
SAMSUNG ELECTRONICS AMERICA INC 1930 4649
WALMART INC 1519 3971
@dodeja
dodeja / tracking_request_sample.php
Created September 18, 2020 18:24
PHP sample code to make a POST request to the Termianl49 Tracking Request API
<?php
$client = new http\Client;
$request = new http\Client\Request;
$body = new http\Message\Body;
$body->append('{"data":{"attributes":{"request_type":"bill_of_lading","request_number":"MEDUFR030802","scac":"MSCU"},"type":"tracking_request"}}');
$request->setRequestUrl('https://api.terminal49.com/v2/tracking_requests');
$request->setRequestMethod('POST');
Bill of lading Shipping Line SCAC Customer Name Reference number Destination Port Tags Destination ETA
6265577920 COSU Test Customer
6265953940 COSU Test Customer
6265945210 COSU Test Customer
6264268760 COSU Test Customer
6263803440 COSU Test Customer
6263582790 COSU Test Customer
6263583430 COSU Test Customer
6263583432 COSU Test Customer
6265579950 COSU Test Customer
bill_of_lading ref_number scac
AYU0400189 GLR537778-01 APLU
AYU0447141 GLR539729-01 APLU
AYU0447848 GLR539810-01 APLU
6259159840 GLR536639-01 COSU
6260513960 GLR537450-01 COSU
6261881840 GLR538447-01 COSU
6262689890 GLR538924-01 COSU
6263752920 GLR539649-01 COSU
6263879530 GLR539665-01 COSU
Bill of Lading ref number Product Description containers Qty of Totes Qty of Bags Qty per container product category
MEDUMY486000 BC-18J24-0201(A) Palmit 80 7 266 0 38 palmit
MEDUMI152544 INC-18K27-0202(B) Palmit 80 5 190 0 38 palmit
MEDUMI226397 INC-18K27-0301(A) Palmit 80 5 190 0 38 palmit
MEDUMI226538 INC-18K27-0301(A) Palmit 80 5 190 0 38 palmit
MEDUMY564855 BC-19B22-0354 Palmit 80 6 228 0 38 palmit
COSU6202710250 BC-18J24-0301(A) Palmit 80 5 0 4800 960 palmit
EGLV084900010194 BC-19B27-0361(B) Palmit 80 5 190 0 38 palmit
EGLV084900010186 BC-19B27-0361(B) Palmit 80 5 190 0 38 palmit
COSU6172736480 BC-19B20-0266(A) Palmit 98 6 180 0 30 palmit