{"info":{"_postman_id":"165d7174-d43c-4325-991b-dae25a59e007","name":"DRY API Direct Access User Guide","description":"

How to use this documentation ?

Next to each endpoint, you will find in the right panel the list of available columns. Example with Trades.

\n $\"Alt$ \n\n

You can open this documentation with Postman App. To do so, you must first install the application.

\n\n

Authentication

You are able to use our API by using Basic Authentication. It is not necessary to use login endpoint to do this.

Follow these steps to use Basic Authentication :

Encode your email and password in base64

  your_email@example.com:your_password = Y3VzdG9tZXJAZW1haWwuY29tOm1Zc3RSb25nUDRzc3cwUmQ=\n\n

Add your encoded credentials in the 'Authorization' header.
\n
```
  Authorization: {{vault:basic-auth}}\n\n
```

How can I encode in base64 ?

In python3

import base64\ntoken = base64.b64encode(str.encode(f'your_email:your_password')).decode('ascii')\n\n

In jQuery

let encodedData = btoa(\"YOUR_EMAIL:YOUR_PASSWORD\");\n/* Output */ \nencodedData = WU9VUl9FTUFJTDpZT1VSX1BBU1NXT1JE\n\n

In Node.js

let data = 'YOUR_EMAIL:YOUR_PASSWORD';\nlet buffer = Buffer.from(data);\nlet encodedData = buffer.toString('base64');\n/* Output */ \nencodedData = WU9VUl9FTUFJTDpZT1VSX1BBU1NXT1JE\n\n

For Windows Users:

Running this command in your command prompt to convert the string [YOUR_USERNAME]:[YOUR_PASSWORD] to a base64-encrypted string.

Press Windows key + R
\n
Enter cmd to open the command prompt
\n
Copy-paste the command below (changing the username/password) and run it
\n

powershell \"[convert]::ToBase64String([Text.Encoding]::UTF8.GetBytes(\\\"YOUR_USERNAME:YOUR_PASSWORD\\\"))\"\n\n

If you have any problems with this section, please do not hesitate to contact us.

Language used for snippet

You are able to generate custom code snippet by choosing your favorite language. You will find in this list all available programming languages.

","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"owner":"7260703","collectionId":"165d7174-d43c-4325-991b-dae25a59e007","publishedId":"S1a4YmuJ","public":true,"customColor":{"top-bar":"FF5349","right-sidebar":"303030","highlight":"FF5349"},"publishDate":"2023-10-20T06:45:51.000Z"},"item":[{"name":"Login","item":[{"name":"/v1/login","event":[{"listen":"test","script":{"id":"a981d822-5a6d-4814-bf4f-ebad1375f58a","exec":[""],"type":"text/javascript"}},{"listen":"prerequest","script":{"id":"47d56a25-c797-49b2-9273-ccb8568bc858","exec":[""],"type":"text/javascript"}}],"id":"39020a79-6aae-4098-b2cc-718256b9d306","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"description":"

Required [string] : Content-Type \"application/json\"

\n","key":"Content-Type","name":"Content-Type","type":"text","value":"application/json"}],"body":{"mode":"raw","raw":"{\n \"email\": \"your_mail@example.com\",\n \"password\": \"your_password\"\n}"},"url":"https://api-dry.kpler.com/v1/login","description":"

The access to our API in 2 steps by using Bearer Token:

curl --location --request POST \"https://api-dry.kpler.com/v1/login\" \\--header \"Content-Type: application/json\" \\--data \"{ \\\"email\\\": \\\"your_mail@example.com\\\", \\\"password\\\": \\\"your_password\\\"}\"
\n
GET request: to be able to query our API with the acquired token, you need to paste directly its value in the 'Authorization' header.
\n
```
Authorization: Bearer YOUR_TOKEN\n\n
```

\n","urlObject":{"protocol":"https","path":["v1","login"],"host":["api-dry","kpler","com"],"query":[],"variable":[]}},"response":[{"id":"e2e1b45c-b6ca-4e32-b44c-5e474e4e2c51","name":"Login with valid credentials","originalRequest":{"method":"POST","header":[{"description":"Required [string] : Content-Type \"application/json\"","key":"Content-Type","name":"Content-Type","type":"text","value":"application/json"}],"body":{"mode":"raw","raw":"{\n\t\"email\": \"your_mail@example.com\",\n\t\"password\": \"your_password\"\n}"},"url":"https://api-dry.kpler.com/v1/login"},"status":"OK","code":200,"_postman_previewlanguage":"Text","header":null,"cookie":[],"responseTime":null,"body":"{\n \"token\": \"76e5e86e0b1a18036fbf2541c7785d931aaaa1d75fbacb01ac54e19464dd1dd888b6b2b85b5aee2177bdf7cc280d60b13d47f611d37b153e02ef2383161fe71679329432ee36bcbeecd53c8adb94bfbe76e5e86e0b1a18036fbf2541c7785d931aaaa1d75fbacb01ac54e19464dd1dd888b6b2b85b5aee2177bdf7cc280d60b\",\n \"user\": {\n \"accounts\": [\n \"lng\",\n \"lpg\",\n \"cpp\",\n \"oil\",\n \"dry\"\n ]\n }\n}"}],"_postman_id":"39020a79-6aae-4098-b2cc-718256b9d306"}],"id":"f98eb0be-37d1-4816-bf45-1ff0557d0333","event":[{"listen":"prerequest","script":{"id":"3ea008fe-478c-4bfc-b0d6-43824d2b20cb","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"fc37d95c-dfb1-42d0-bd9d-b0ab98651b3b","type":"text/javascript","exec":[""]}}],"_postman_id":"f98eb0be-37d1-4816-bf45-1ff0557d0333","description":""},{"name":"Trades","item":[{"name":"/v1/trades","event":[{"listen":"test","script":{"id":"45357501-e865-4575-93a1-03e1f674cba6","exec":[""],"type":"text/javascript"}},{"listen":"prerequest","script":{"id":"6dbc685c-7e4f-453b-969e-879642f01de7","exec":[""],"type":"text/javascript"}}],"id":"0030a0c6-61a9-448a-8f6f-defe49ac351a","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"GET","header":[{"description":"

Required [String] : Token

\n","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":"https://api-dry.kpler.com/v1/trades?size={{size}}&vessels={{vessels}}&fromInstallations={{fromInstallations}}&toInstallations={{toInstallations}}&fromZones={{fromZones}}&toZones={{toZones}}&buyers={{buyers}}&sellers={{sellers}}&products={{products}}&startDate={{startDate}}&endDate={{endDate}}&tradeStatus={{tradeStatus}}&destinationStartDate={{destinationStartDate}}&destinationEndDate={{destinationEndDate}}&vesselTypes={{vesselTypes}}&withForecast={{withForecast}}&withIntraCountry={{withIntraCountry}}&withIntraRegion={{withIntraRegion}}&columns={{columns}}&hash={{hash}}&withProductEstimation={{withProductEstimation}}","urlObject":{"protocol":"https","path":["v1","trades"],"host":["api-dry","kpler","com"],"query":[{"description":{"content":"

Optional [Integer]: Maximum number of trades returned

\n","type":"text/plain"},"key":"size","value":"{{size}}"},{"description":{"content":"

Optional [String]: Names/IMO's of vessels

\n","type":"text/plain"},"key":"vessels","value":"{{vessels}}"},{"description":{"content":"

Optional [String]: Names of the origin installations

\n","type":"text/plain"},"key":"fromInstallations","value":"{{fromInstallations}}"},{"description":{"content":"

Optional [String]: Names of the destination installations (terminal/refinery)

\n","type":"text/plain"},"key":"toInstallations","value":"{{toInstallations}}"},{"description":{"content":"

Optional [String]: Names of the origin zones (port/region/country/continent)

\n","type":"text/plain"},"key":"fromZones","value":"{{fromZones}}"},{"description":{"content":"

Optional [String]: Names of the destination zones (port/region/country/continent)

\n","type":"text/plain"},"key":"toZones","value":"{{toZones}}"},{"description":{"content":"

Optional [String]: Buyers of the cargo

\n","type":"text/plain"},"key":"buyers","value":"{{buyers}}"},{"description":{"content":"

Optional [String]: Sellers of the cargo

\n","type":"text/plain"},"key":"sellers","value":"{{sellers}}"},{"description":{"content":"

Optional [String]: Names of products

\n","type":"text/plain"},"key":"products","value":"{{products}}"},{"description":{"content":"

Optional [Date]: Origin Date: Start of the period (YYYY-MM-DD)

\n","type":"text/plain"},"key":"startDate","value":"{{startDate}}"},{"description":{"content":"

Optional [Date]: Origin Date: End of the period (YYYY-MM-DD)

\n","type":"text/plain"},"key":"endDate","value":"{{endDate}}"},{"description":{"content":"

Optional [String]: Return only trades of a particular status [“delivered”, ”loading”, ”in transit”, ”scheduled”]

\n","type":"text/plain"},"key":"tradeStatus","value":"{{tradeStatus}}"},{"description":{"content":"

Optional [Date]: Destination Date: Start of the period (YYYY-MM-DD)

\n","type":"text/plain"},"key":"destinationStartDate","value":"{{destinationStartDate}}"},{"description":{"content":"

Optional [Date]: Destination Date: End of the period (YYYY-MM-DD)

\n","type":"text/plain"},"key":"destinationEndDate","value":"{{destinationEndDate}}"},{"description":{"content":"

Optional [String]: For given dry vessel types\n
\nUse [\"Baby Capes\", \"Capesize\", \"Handymax\", \"Handysize\", \"Newcastlemax\", \"Kamsarmax\", \"Panamax\", \"Post-Panamax\", \"Supramax\", \"Ultramax\", \"Valemax\", \"VLOC\"]\n
\nNote: Values are case sensitive

\n","type":"text/plain"},"key":"vesselTypes","value":"{{vesselTypes}}"},{"description":{"content":"

Optional [Boolean]: Default to true if not specified. Include trades predicted by our in-house model when set to \"true\". Use [\"true\", \"false\"]

\n","type":"text/plain"},"key":"withForecast","value":"{{withForecast}}"},{"description":{"content":"

Optional [Boolean]: Default to true if not specified. Takes into account the trades that originate from and are delivered to the same country. Use [\"true\", \"false\"]

\n","type":"text/plain"},"key":"withIntraCountry","value":"{{withIntraCountry}}"},{"description":{"content":"

Optional [Boolean]: Default to true if not specified. Takes into account the trades that originate from and are delivered to a specified region. Use [\"true\", \"false\"]

\n","type":"text/plain"},"key":"withIntraRegion","value":"{{withIntraRegion}}"},{"description":{"content":"

Optional [String]: Retrieve all available columns when set to \"all\"

\n","type":"text/plain"},"key":"columns","value":"{{columns}}"},{"description":{"content":"

Optional [String]: Generate your favorite set of columns using the hash ( Look at the next endpoint to learn more about how to generate the hash code )

Note: You cannot use it simultaneously with the ‘columns’ parameter

\n","type":"text/plain"},"key":"hash","value":"{{hash}}"},{"description":{"content":"

Optional [Boolean]: Default to false if not specified. Activate the product estimation feature for Iron Ore and Coal trades only. When set to true, the estimated product will overwrite the existing product information.

\n","type":"text/plain"},"key":"withProductEstimation","value":"{{withProductEstimation}}"}],"variable":[]}},"response":[{"id":"1801a5fe-c18b-41cc-aa5c-b54bd542172d","name":"List of 5 cargos exporting from Europe and going to Asia","originalRequest":{"method":"GET","header":[{"description":"Required [String] : Token","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":{"raw":"https://api-dry.kpler.com/v1/trades?size=6&columns=trade_id,vessel_name,start,end&fromZones=Europe&toZones=Asia","protocol":"https","host":["api-dry","kpler","com"],"path":["v1","trades"],"query":[{"key":"size","value":"6","description":"Optional [Integer] : Maximum number of trades returned"},{"key":"columns","value":"trade_id,vessel_name,start,end","description":"Optional [String] : Retrieve all available columns when set to \"all\""},{"key":"fromZones","value":"Europe","description":"Optional [String] : Names of the origin zones (port/region/country/continent)"},{"key":"toZones","value":"Asia","description":"Optional [String] : Names of the destination zones (port/region/country/continent)"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[],"cookie":[],"responseTime":null,"body":"Id (Trade);Vessel;Date (origin);Date (destination)\n194664;Scf Melampus;2019-08-08 04:06;\n193787;Boris Davydov;2019-08-05 08:29;2019-08-22 13:00\n194696;Christophe De Margerie;2019-08-01 21:29;\n191854;Vladimir Vize;2019-07-28 16:11;2019-08-15 16:01\n194223;Nikolay Zubov;2019-07-23 00:31;2019-08-13 06:00\n"},{"id":"d3eff521-53f2-43d2-9dc1-838226c8f47b","name":"Retrieve columns using hash","originalRequest":{"method":"GET","header":[{"description":"Required [String] : Token","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":{"raw":"https://api-dry.kpler.com/v1/trades?hash=YOUR_HASH","protocol":"https","host":["api-dry","kpler","com"],"path":["v1","trades"],"query":[{"key":"hash","value":"YOUR_HASH","description":"Optional [String]: Generate your favorite set of columns using the hash ( Look at the next endpoint to learn more about how to generate the hash code )\n\n**Note:** You cannot use it simultaneously with the ‘columns’ parameter"}]}},"_postman_previewlanguage":"Text","header":null,"cookie":[],"responseTime":null,"body":""},{"id":"ffd35f80-0313-4d3d-b99d-897020d13cbf","name":"Columns id, name, description and deprecation status","originalRequest":{"method":"GET","header":[],"url":"https://api-dry.kpler.com/v1/trades/columns"},"_postman_previewlanguage":"json","header":null,"cookie":[],"responseTime":null,"body":"{\n \"Columns by default\": [\n {\n \"id\": \"vessel_name\",\n \"shortId\": \"ven\",\n \"columnName\": \"Vessel\",\n \"description\": \"Name of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_country_name\",\n \"shortId\": \"ocn\",\n \"columnName\": \"Country (origin)\",\n \"description\": \"Name of the origin country\",\n \"deprecated\": false\n },\n {\n \"id\": \"zone_origin_name\",\n \"shortId\": \"zon\",\n \"columnName\": \"Zone Origin\",\n \"description\": \"Name of the origin area\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_origin_name\",\n \"shortId\": \"ion\",\n \"columnName\": \"Installation origin\",\n \"description\": \"Name of the origin installation\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_end\",\n \"shortId\": \"oen\",\n \"columnName\": \"End (origin)\",\n \"description\": \"End of the loading process at the origin \",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_country_name\",\n \"shortId\": \"dcn\",\n \"columnName\": \"Country (destination)\",\n \"description\": \"Name of the destination country\",\n \"deprecated\": false\n },\n {\n \"id\": \"zone_destination_name\",\n \"shortId\": \"zdn\",\n \"columnName\": \"Zone Destination\",\n \"description\": \"Name of the destination area\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_destination_name\",\n \"shortId\": \"idn\",\n \"columnName\": \"Installation Destination\",\n \"description\": \"Name of the destination installation\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_start\",\n \"shortId\": \"dsd\",\n \"columnName\": \"Start (destination)\",\n \"description\": \"Start of the discharge process at destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_family\",\n \"shortId\": \"cafam\",\n \"columnName\": \"Family\",\n \"description\": \"Product family\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_group\",\n \"shortId\": \"cagroup\",\n \"columnName\": \"Group\",\n \"description\": \"Product group\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_product\",\n \"shortId\": \"capro\",\n \"columnName\": \"Product\",\n \"description\": \"Product type\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_grade\",\n \"shortId\": \"cagrade\",\n \"columnName\": \"Grade\",\n \"description\": \"Product grade\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_id\",\n \"shortId\": \"tid\",\n \"columnName\": \"Id (Trade)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"port_call_origin_id\",\n \"shortId\": \"pcoid\",\n \"columnName\": \"Origin PortCall Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"port_call_destination_id\",\n \"shortId\": \"pcdid\",\n \"columnName\": \"Destination PortCall Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"voyage_id\",\n \"shortId\": \"voy\",\n \"columnName\": \"Id (Voyage)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"zone_origin_id\",\n \"shortId\": \"zoi\",\n \"columnName\": \"Zone Origin Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"zone_destination_id\",\n \"shortId\": \"zdi\",\n \"columnName\": \"Zone Destination Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_origin_id\",\n \"shortId\": \"ioi\",\n \"columnName\": \"Installation origin id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_destination_id\",\n \"shortId\": \"idi\",\n \"columnName\": \"Installation Destination Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"continent_destination_name\",\n \"shortId\": \"cdn\",\n \"columnName\": \"Continent Destination\",\n \"description\": \"Continent of destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"continent_origin_name\",\n \"shortId\": \"con\",\n \"columnName\": \"Continent Origin\",\n \"description\": \"Continent of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"mileage_nautical_miles\",\n \"shortId\": \"mnm\",\n \"columnName\": \"Mileage\",\n \"description\": \"Distance between origin and destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"ton_miles\",\n \"shortId\": \"tom\",\n \"columnName\": \"Ton Miles\",\n \"description\": \"Ton/mile report\",\n \"deprecated\": false\n },\n {\n \"id\": \"start\",\n \"shortId\": \"str\",\n \"columnName\": \"Date (origin)\",\n \"description\": \"Departure date of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_location_name\",\n \"shortId\": \"oln\",\n \"columnName\": \"Origin\",\n \"description\": \"Origin location of the cargo\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_reload_sts_partial\",\n \"shortId\": \"ota\",\n \"columnName\": \"Reload STS Partial (origin)\",\n \"description\": \"If field contains 'Partial' = Partial has occurred in this port call. Same logic applies for when “Reload” and 'STS' is returned for Re-loads and Ship-to-Ship transfers\",\n \"deprecated\": false\n },\n {\n \"id\": \"end\",\n \"shortId\": \"end\",\n \"columnName\": \"Date (destination)\",\n \"description\": \"Arrival date of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_location_name\",\n \"shortId\": \"dln\",\n \"columnName\": \"Destination\",\n \"description\": \"Destination location of the cargo\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_reload_sts_partial\",\n \"shortId\": \"dta\",\n \"columnName\": \"Reload STS Partial (destination)\",\n \"description\": \"If field contains 'Partial' then Partial has occurred in this port call. Same logic applies for when 'Reload' and 'STS' is returned for Re-loads and Ship-to-Ship transfers.\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_destination_location_name\",\n \"shortId\": \"fdl\",\n \"columnName\": \"Forecasted destination\",\n \"description\": \"Next destination forecasted\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_destination_location_eta\",\n \"shortId\": \"fde\",\n \"columnName\": \"Forecasted ETA\",\n \"description\": \"Next destination ETA forecasted\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_destination_confidence\",\n \"shortId\": \"fdc\",\n \"columnName\": \"Forecasted confidence\",\n \"description\": \"Confidence (in %) of the system forecast\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_origin_location_name\",\n \"shortId\": \"fol\",\n \"columnName\": \"Forecasted origin\",\n \"description\": \"Next origin forecasted\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_origin_eta\",\n \"shortId\": \"foe\",\n \"columnName\": \"Forecasted origin ETA\",\n \"description\": \"Next origin ETA forecasted\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_origin_confidence\",\n \"shortId\": \"foc\",\n \"columnName\": \"Forecasted origin confidence\",\n \"description\": \"Confidence (in %) of the system forecast\",\n \"deprecated\": false\n },\n {\n \"id\": \"status\",\n \"shortId\": \"stt\",\n \"columnName\": \"Trade status\",\n \"description\": \"'Scheduled' = cargo has not been picked up yet. 'In Transit' = cargo is in movement. 'Delivered' = cargo arrived to destination.\",\n \"deprecated\": false\n },\n {\n \"id\": \"initial_seller_name\",\n \"shortId\": \"isn\",\n \"columnName\": \"Seller (origin)\",\n \"description\": \"Company name that sold cargo at the installation of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"final_buyer_name\",\n \"shortId\": \"fbn\",\n \"columnName\": \"Buyer (destination)\",\n \"description\": \"Company name of the buyer at final destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"number_of_intermediaries\",\n \"shortId\": \"noi\",\n \"columnName\": \"Intermediaries\",\n \"description\": \"Number of intermediate players involved in the trade\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_subcontinent_name\",\n \"shortId\": \"osn\",\n \"columnName\": \"Subcontinent (origin)\",\n \"description\": \"Subcontinent of trade origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_eta_date\",\n \"shortId\": \"oed\",\n \"columnName\": \"Eta (origin)\",\n \"description\": \"Estimated time of arrival at origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_start\",\n \"shortId\": \"ost\",\n \"columnName\": \"Start (origin)\",\n \"description\": \"Start date of the trip\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_eta_source\",\n \"shortId\": \"oes\",\n \"columnName\": \"Eta source (origin)\",\n \"description\": \"Source of the Estimated Time of Arrival to the Installation of Origin information (Port, Analyst, etc.)\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_eta_source\",\n \"shortId\": \"des\",\n \"columnName\": \"Eta source (destination)\",\n \"description\": \"Source of the Estimated Time of Arrival to the Installation of Destination information (Port, Analyst, etc.)\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_subcontinent_name\",\n \"shortId\": \"dsn\",\n \"columnName\": \"Subcontinent (destination)\",\n \"description\": \"Subcontinent of trade destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_eta\",\n \"shortId\": \"ded\",\n \"columnName\": \"Eta (destination)\",\n \"description\": \"Estimated time of arrival at destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_end\",\n \"shortId\": \"den\",\n \"columnName\": \"End (destination)\",\n \"description\": \"Departure datetime from the destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_capacity_cubic_meters\",\n \"shortId\": \"vcm\",\n \"columnName\": \"Capacity (vessel m3)\",\n \"description\": \"The maximum capacity of the vessel in cubic meters\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_type\",\n \"shortId\": \"vet\",\n \"columnName\": \"Vessel type\",\n \"description\": \"Type of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_cargo_type\",\n \"shortId\": \"vct\",\n \"columnName\": \"Cargo type (vessel)\",\n \"description\": \"The specific cargo type of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_id\",\n \"shortId\": \"vid\",\n \"columnName\": \"Id (vessel)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_imo\",\n \"shortId\": \"imo\",\n \"columnName\": \"IMO (vessel)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_mmsi\",\n \"shortId\": \"msi\",\n \"columnName\": \"MMSI (vessel)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"charterer_name\",\n \"shortId\": \"chn\",\n \"columnName\": \"Charterer\",\n \"description\": \"Current Controller of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"zone_canal_transit\",\n \"shortId\": \"zct\",\n \"columnName\": \"Zone Canal Transit\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_delivery\",\n \"shortId\": \"t1d\",\n \"columnName\": \"Link1 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_type\",\n \"shortId\": \"t1t\",\n \"columnName\": \"Link1 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_seller_name\",\n \"shortId\": \"s1n\",\n \"columnName\": \"Link1 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_seller_country_name\",\n \"shortId\": \"s1c\",\n \"columnName\": \"Link1 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_buyer_name\",\n \"shortId\": \"n1b\",\n \"columnName\": \"Link1 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_buyer_country_name\",\n \"shortId\": \"b1c\",\n \"columnName\": \"Link1 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_delivery\",\n \"shortId\": \"t2d\",\n \"columnName\": \"Link2 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_type\",\n \"shortId\": \"t2t\",\n \"columnName\": \"Link2 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_seller_name\",\n \"shortId\": \"s2n\",\n \"columnName\": \"Link2 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_seller_country_name\",\n \"shortId\": \"s2c\",\n \"columnName\": \"Link2 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_buyer_name\",\n \"shortId\": \"n2b\",\n \"columnName\": \"Link2 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_buyer_country_name\",\n \"shortId\": \"b2c\",\n \"columnName\": \"Link2 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_delivery\",\n \"shortId\": \"t3d\",\n \"columnName\": \"Link3 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_type\",\n \"shortId\": \"t3t\",\n \"columnName\": \"Link3 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_seller_name\",\n \"shortId\": \"s3n\",\n \"columnName\": \"Link3 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_seller_country_name\",\n \"shortId\": \"s3c\",\n \"columnName\": \"Link3 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_buyer_name\",\n \"shortId\": \"n3b\",\n \"columnName\": \"Link3 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_buyer_country_name\",\n \"shortId\": \"b3c\",\n \"columnName\": \"Link3 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_delivery\",\n \"shortId\": \"t4d\",\n \"columnName\": \"Link4 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_type\",\n \"shortId\": \"t4t\",\n \"columnName\": \"Link4 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_seller_name\",\n \"shortId\": \"s4n\",\n \"columnName\": \"Link4 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_seller_country_name\",\n \"shortId\": \"s4c\",\n \"columnName\": \"Link4 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_buyer_name\",\n \"shortId\": \"n4b\",\n \"columnName\": \"Link4 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_buyer_country_name\",\n \"shortId\": \"b4c\",\n \"columnName\": \"Link4 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_delivery\",\n \"shortId\": \"t5d\",\n \"columnName\": \"Link5 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_type\",\n \"shortId\": \"t5t\",\n \"columnName\": \"Link5 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_seller_name\",\n \"shortId\": \"s5n\",\n \"columnName\": \"Link5 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_seller_country_name\",\n \"shortId\": \"s5c\",\n \"columnName\": \"Link5 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_buyer_name\",\n \"shortId\": \"n5b\",\n \"columnName\": \"Link5 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_buyer_country_name\",\n \"shortId\": \"b5c\",\n \"columnName\": \"Link5 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"cargo_origin_tons_split_by_product\",\n \"shortId\": \"cotsp\",\n \"columnName\": \"Cargo (tons)\",\n \"description\": \"Quantity (tons) loaded/discharged at the terminal\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_grade_api\",\n \"shortId\": \"cagradeapi\",\n \"columnName\": \"Grade API\",\n \"description\": \"API grade of the product\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_grade_sulfur\",\n \"shortId\": \"cagradesulfur\",\n \"columnName\": \"Grade Sulfur\",\n \"description\": \"Sulfur grade of the product\",\n \"deprecated\": false\n }\n ],\n \"Optional Columns\": [\n {\n \"id\": \"product_id\",\n \"shortId\": \"proid\",\n \"columnName\": \"Id (Product)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_dwt_1\",\n \"shortId\": \"dwt1\",\n \"columnName\": \"Vessel DWT\",\n \"description\": null,\n \"deprecated\": false\n }\n ]\n}"}],"_postman_id":"0030a0c6-61a9-448a-8f6f-defe49ac351a"},{"name":"/v1/trades/columns","event":[{"listen":"test","script":{"id":"45357501-e865-4575-93a1-03e1f674cba6","exec":[""],"type":"text/javascript"}},{"listen":"prerequest","script":{"id":"6dbc685c-7e4f-453b-969e-879642f01de7","exec":[""],"type":"text/javascript"}}],"id":"d8dac098-cb8e-4e82-87e5-e92df48f49fe","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"POST","header":[{"description":"

Required [String] : Token

\n","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"},{"key":"Content-Type","value":"application/json","description":"

Required [String]: application/json or text/json

\n","type":"text"}],"body":{"mode":"raw","raw":"[\n \"trade_id\",\n \"status\",\n \"origin_country_name\",\n \"destination_country_name\"\n]"},"url":"https://api-dry.kpler.com/v1/trades/columns","description":"

To prevent breaking changes, we strongly recommend you to not use the “all” or the default value for the 'column’ parameter as these may occasionally change.

Therefore we have added this endpoint which allows you to get a hash code for the set of columns that you wish to add on your query.

Note: The set of columns defined with the hash code will never change and will always remain the same.

In this example, we have created a hash code that will always return the following columns:

trade_id
status
origin_country_name
destination_country_name

\n","urlObject":{"protocol":"https","path":["v1","trades","columns"],"host":["api-dry","kpler","com"],"query":[],"variable":[]}},"response":[{"id":"0390bd27-013f-4970-a8a6-f8214ce0c792","name":"Columns id, name, description and deprecation status","originalRequest":{"method":"GET","header":[],"url":"https://api-dry.kpler.com/v1/trades/columns"},"_postman_previewlanguage":"json","header":null,"cookie":[],"responseTime":null,"body":"{\n \"Columns by default\": [\n {\n \"id\": \"vessel_name\",\n \"shortId\": \"ven\",\n \"columnName\": \"Vessel\",\n \"description\": \"Name of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_country_name\",\n \"shortId\": \"ocn\",\n \"columnName\": \"Country (origin)\",\n \"description\": \"Name of the origin country\",\n \"deprecated\": false\n },\n {\n \"id\": \"zone_origin_name\",\n \"shortId\": \"zon\",\n \"columnName\": \"Zone Origin\",\n \"description\": \"Name of the origin area\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_origin_name\",\n \"shortId\": \"ion\",\n \"columnName\": \"Installation origin\",\n \"description\": \"Name of the origin installation\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_end\",\n \"shortId\": \"oen\",\n \"columnName\": \"End (origin)\",\n \"description\": \"End of the loading process at the origin \",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_country_name\",\n \"shortId\": \"dcn\",\n \"columnName\": \"Country (destination)\",\n \"description\": \"Name of the destination country\",\n \"deprecated\": false\n },\n {\n \"id\": \"zone_destination_name\",\n \"shortId\": \"zdn\",\n \"columnName\": \"Zone Destination\",\n \"description\": \"Name of the destination area\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_destination_name\",\n \"shortId\": \"idn\",\n \"columnName\": \"Installation Destination\",\n \"description\": \"Name of the destination installation\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_start\",\n \"shortId\": \"dsd\",\n \"columnName\": \"Start (destination)\",\n \"description\": \"Start of the discharge process at destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_family\",\n \"shortId\": \"cafam\",\n \"columnName\": \"Family\",\n \"description\": \"Product family\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_group\",\n \"shortId\": \"cagroup\",\n \"columnName\": \"Group\",\n \"description\": \"Product group\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_product\",\n \"shortId\": \"capro\",\n \"columnName\": \"Product\",\n \"description\": \"Product type\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_grade\",\n \"shortId\": \"cagrade\",\n \"columnName\": \"Grade\",\n \"description\": \"Product grade\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_id\",\n \"shortId\": \"tid\",\n \"columnName\": \"Id (Trade)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"port_call_origin_id\",\n \"shortId\": \"pcoid\",\n \"columnName\": \"Origin PortCall Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"port_call_destination_id\",\n \"shortId\": \"pcdid\",\n \"columnName\": \"Destination PortCall Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"voyage_id\",\n \"shortId\": \"voy\",\n \"columnName\": \"Id (Voyage)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"zone_origin_id\",\n \"shortId\": \"zoi\",\n \"columnName\": \"Zone Origin Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"zone_destination_id\",\n \"shortId\": \"zdi\",\n \"columnName\": \"Zone Destination Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_origin_id\",\n \"shortId\": \"ioi\",\n \"columnName\": \"Installation origin id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_destination_id\",\n \"shortId\": \"idi\",\n \"columnName\": \"Installation Destination Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"continent_destination_name\",\n \"shortId\": \"cdn\",\n \"columnName\": \"Continent Destination\",\n \"description\": \"Continent of destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"continent_origin_name\",\n \"shortId\": \"con\",\n \"columnName\": \"Continent Origin\",\n \"description\": \"Continent of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"mileage_nautical_miles\",\n \"shortId\": \"mnm\",\n \"columnName\": \"Mileage\",\n \"description\": \"Distance between origin and destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"ton_miles\",\n \"shortId\": \"tom\",\n \"columnName\": \"Ton Miles\",\n \"description\": \"Ton/mile report\",\n \"deprecated\": false\n },\n {\n \"id\": \"start\",\n \"shortId\": \"str\",\n \"columnName\": \"Date (origin)\",\n \"description\": \"Departure date of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_location_name\",\n \"shortId\": \"oln\",\n \"columnName\": \"Origin\",\n \"description\": \"Origin location of the cargo\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_reload_sts_partial\",\n \"shortId\": \"ota\",\n \"columnName\": \"Reload STS Partial (origin)\",\n \"description\": \"If field contains 'Partial' = Partial has occurred in this port call. Same logic applies for when “Reload” and 'STS' is returned for Re-loads and Ship-to-Ship transfers\",\n \"deprecated\": false\n },\n {\n \"id\": \"end\",\n \"shortId\": \"end\",\n \"columnName\": \"Date (destination)\",\n \"description\": \"Arrival date of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_location_name\",\n \"shortId\": \"dln\",\n \"columnName\": \"Destination\",\n \"description\": \"Destination location of the cargo\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_reload_sts_partial\",\n \"shortId\": \"dta\",\n \"columnName\": \"Reload STS Partial (destination)\",\n \"description\": \"If field contains 'Partial' then Partial has occurred in this port call. Same logic applies for when 'Reload' and 'STS' is returned for Re-loads and Ship-to-Ship transfers.\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_destination_location_name\",\n \"shortId\": \"fdl\",\n \"columnName\": \"Forecasted destination\",\n \"description\": \"Next destination forecasted\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_destination_location_eta\",\n \"shortId\": \"fde\",\n \"columnName\": \"Forecasted ETA\",\n \"description\": \"Next destination ETA forecasted\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_destination_confidence\",\n \"shortId\": \"fdc\",\n \"columnName\": \"Forecasted confidence\",\n \"description\": \"Confidence (in %) of the system forecast\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_origin_location_name\",\n \"shortId\": \"fol\",\n \"columnName\": \"Forecasted origin\",\n \"description\": \"Next origin forecasted\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_origin_eta\",\n \"shortId\": \"foe\",\n \"columnName\": \"Forecasted origin ETA\",\n \"description\": \"Next origin ETA forecasted\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_origin_confidence\",\n \"shortId\": \"foc\",\n \"columnName\": \"Forecasted origin confidence\",\n \"description\": \"Confidence (in %) of the system forecast\",\n \"deprecated\": false\n },\n {\n \"id\": \"status\",\n \"shortId\": \"stt\",\n \"columnName\": \"Trade status\",\n \"description\": \"'Scheduled' = cargo has not been picked up yet. 'In Transit' = cargo is in movement. 'Delivered' = cargo arrived to destination.\",\n \"deprecated\": false\n },\n {\n \"id\": \"initial_seller_name\",\n \"shortId\": \"isn\",\n \"columnName\": \"Seller (origin)\",\n \"description\": \"Company name that sold cargo at the installation of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"final_buyer_name\",\n \"shortId\": \"fbn\",\n \"columnName\": \"Buyer (destination)\",\n \"description\": \"Company name of the buyer at final destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"number_of_intermediaries\",\n \"shortId\": \"noi\",\n \"columnName\": \"Intermediaries\",\n \"description\": \"Number of intermediate players involved in the trade\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_subcontinent_name\",\n \"shortId\": \"osn\",\n \"columnName\": \"Subcontinent (origin)\",\n \"description\": \"Subcontinent of trade origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_eta_date\",\n \"shortId\": \"oed\",\n \"columnName\": \"Eta (origin)\",\n \"description\": \"Estimated time of arrival at origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_start\",\n \"shortId\": \"ost\",\n \"columnName\": \"Start (origin)\",\n \"description\": \"Start date of the trip\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_eta_source\",\n \"shortId\": \"oes\",\n \"columnName\": \"Eta source (origin)\",\n \"description\": \"Source of the Estimated Time of Arrival to the Installation of Origin information (Port, Analyst, etc.)\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_eta_source\",\n \"shortId\": \"des\",\n \"columnName\": \"Eta source (destination)\",\n \"description\": \"Source of the Estimated Time of Arrival to the Installation of Destination information (Port, Analyst, etc.)\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_subcontinent_name\",\n \"shortId\": \"dsn\",\n \"columnName\": \"Subcontinent (destination)\",\n \"description\": \"Subcontinent of trade destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_eta\",\n \"shortId\": \"ded\",\n \"columnName\": \"Eta (destination)\",\n \"description\": \"Estimated time of arrival at destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_end\",\n \"shortId\": \"den\",\n \"columnName\": \"End (destination)\",\n \"description\": \"Departure datetime from the destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_capacity_cubic_meters\",\n \"shortId\": \"vcm\",\n \"columnName\": \"Capacity (vessel m3)\",\n \"description\": \"The maximum capacity of the vessel in cubic meters\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_type\",\n \"shortId\": \"vet\",\n \"columnName\": \"Vessel type\",\n \"description\": \"Type of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_cargo_type\",\n \"shortId\": \"vct\",\n \"columnName\": \"Cargo type (vessel)\",\n \"description\": \"The specific cargo type of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_id\",\n \"shortId\": \"vid\",\n \"columnName\": \"Id (vessel)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_imo\",\n \"shortId\": \"imo\",\n \"columnName\": \"IMO (vessel)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_mmsi\",\n \"shortId\": \"msi\",\n \"columnName\": \"MMSI (vessel)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"charterer_name\",\n \"shortId\": \"chn\",\n \"columnName\": \"Charterer\",\n \"description\": \"Current Controller of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"zone_canal_transit\",\n \"shortId\": \"zct\",\n \"columnName\": \"Zone Canal Transit\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_delivery\",\n \"shortId\": \"t1d\",\n \"columnName\": \"Link1 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_type\",\n \"shortId\": \"t1t\",\n \"columnName\": \"Link1 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_seller_name\",\n \"shortId\": \"s1n\",\n \"columnName\": \"Link1 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_seller_country_name\",\n \"shortId\": \"s1c\",\n \"columnName\": \"Link1 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_buyer_name\",\n \"shortId\": \"n1b\",\n \"columnName\": \"Link1 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_buyer_country_name\",\n \"shortId\": \"b1c\",\n \"columnName\": \"Link1 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_delivery\",\n \"shortId\": \"t2d\",\n \"columnName\": \"Link2 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_type\",\n \"shortId\": \"t2t\",\n \"columnName\": \"Link2 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_seller_name\",\n \"shortId\": \"s2n\",\n \"columnName\": \"Link2 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_seller_country_name\",\n \"shortId\": \"s2c\",\n \"columnName\": \"Link2 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_buyer_name\",\n \"shortId\": \"n2b\",\n \"columnName\": \"Link2 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_buyer_country_name\",\n \"shortId\": \"b2c\",\n \"columnName\": \"Link2 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_delivery\",\n \"shortId\": \"t3d\",\n \"columnName\": \"Link3 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_type\",\n \"shortId\": \"t3t\",\n \"columnName\": \"Link3 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_seller_name\",\n \"shortId\": \"s3n\",\n \"columnName\": \"Link3 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_seller_country_name\",\n \"shortId\": \"s3c\",\n \"columnName\": \"Link3 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_buyer_name\",\n \"shortId\": \"n3b\",\n \"columnName\": \"Link3 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_buyer_country_name\",\n \"shortId\": \"b3c\",\n \"columnName\": \"Link3 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_delivery\",\n \"shortId\": \"t4d\",\n \"columnName\": \"Link4 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_type\",\n \"shortId\": \"t4t\",\n \"columnName\": \"Link4 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_seller_name\",\n \"shortId\": \"s4n\",\n \"columnName\": \"Link4 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_seller_country_name\",\n \"shortId\": \"s4c\",\n \"columnName\": \"Link4 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_buyer_name\",\n \"shortId\": \"n4b\",\n \"columnName\": \"Link4 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_buyer_country_name\",\n \"shortId\": \"b4c\",\n \"columnName\": \"Link4 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_delivery\",\n \"shortId\": \"t5d\",\n \"columnName\": \"Link5 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_type\",\n \"shortId\": \"t5t\",\n \"columnName\": \"Link5 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_seller_name\",\n \"shortId\": \"s5n\",\n \"columnName\": \"Link5 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_seller_country_name\",\n \"shortId\": \"s5c\",\n \"columnName\": \"Link5 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_buyer_name\",\n \"shortId\": \"n5b\",\n \"columnName\": \"Link5 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_buyer_country_name\",\n \"shortId\": \"b5c\",\n \"columnName\": \"Link5 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"cargo_origin_tons_split_by_product\",\n \"shortId\": \"cotsp\",\n \"columnName\": \"Cargo (tons)\",\n \"description\": \"Quantity (tons) loaded/discharged at the terminal\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_grade_api\",\n \"shortId\": \"cagradeapi\",\n \"columnName\": \"Grade API\",\n \"description\": \"API grade of the product\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_grade_sulfur\",\n \"shortId\": \"cagradesulfur\",\n \"columnName\": \"Grade Sulfur\",\n \"description\": \"Sulfur grade of the product\",\n \"deprecated\": false\n }\n ],\n \"Optional Columns\": [\n {\n \"id\": \"product_id\",\n \"shortId\": \"proid\",\n \"columnName\": \"Id (Product)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_dwt_1\",\n \"shortId\": \"dwt1\",\n \"columnName\": \"Vessel DWT\",\n \"description\": null,\n \"deprecated\": false\n }\n ]\n}"},{"id":"6e34cb3f-2007-4921-969e-a1f33653af56","name":"Create a new hash","originalRequest":{"method":"POST","header":[{"description":"Required [String] : Token","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"},{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"Required [String]: **application/json** or **text/json**","type":"text"}],"body":{"mode":"raw","raw":"[\n \"trade_id\",\n \"status\",\n \"origin_country_name\",\n \"destination_country_name\"\n]","options":{"raw":{"language":"json"}}},"url":"https://api-dry.kpler.com/v1/trades/columns"},"status":"OK","code":200,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Wed, 20 May 2020 08:31:43 GMT"},{"key":"Content-Type","value":"text/plain; charset=UTF-8"},{"key":"Content-Length","value":"58"},{"key":"Connection","value":"keep-alive"},{"key":"Vary","value":"Accept-Encoding"},{"key":"Content-Encoding","value":"gzip"},{"key":"Access-Control-Allow-Origin","value":"*"}],"cookie":[],"responseTime":null,"body":"d2805bbbef7574640ff7d7db242721e1"}],"_postman_id":"d8dac098-cb8e-4e82-87e5-e92df48f49fe"},{"name":"/v1/trades/columns","event":[{"listen":"test","script":{"id":"9f72a959-2d04-4007-8ab4-dabf8be8a878","exec":[""],"type":"text/javascript"}},{"listen":"prerequest","script":{"id":"9bf482bb-7096-4364-b148-157a1415e15f","exec":[""],"type":"text/javascript"}}],"id":"5946a885-f376-45c5-b779-76f5afeadbe9","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"GET","header":[{"description":"

Required [String] : Token

\n","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"},{"description":"

Required [String]: application/json or text/json

\n","key":"Content-Type","type":"text","value":"application/json"}],"url":"https://api-dry.kpler.com/v1/trades/columns","description":"

This endpoint returns a recent and updated list of all columns available for the endpoint trades.

\n","urlObject":{"protocol":"https","path":["v1","trades","columns"],"host":["api-dry","kpler","com"],"query":[],"variable":[]}},"response":[{"id":"ca62eca5-376e-48be-b181-ad57f9447da4","name":"List of all columns","originalRequest":{"method":"GET","header":[{"description":"Required [String] : Token","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"},{"description":"Required [String]: **application/json** or **text/json**","key":"Content-Type","type":"text","value":"application/json"}],"url":"https://api-dry.kpler.com/v1/trades/columns"},"_postman_previewlanguage":"json","header":null,"cookie":[],"responseTime":null,"body":"{\n \"selected\": [\n {\n \"id\": \"vessel_name\",\n \"shortId\": \"ven\",\n \"columnName\": \"Vessel\",\n \"description\": \"Name of the vessel\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"origin_country_name\",\n \"shortId\": \"ocn\",\n \"columnName\": \"Country (origin)\",\n \"description\": \"Name of the origin country\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"zone_origin_name\",\n \"shortId\": \"zon\",\n \"columnName\": \"Zone Origin\",\n \"description\": \"Name of the origin area\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"installation_origin_name\",\n \"shortId\": \"ion\",\n \"columnName\": \"Installation origin\",\n \"description\": \"Name of the origin installation\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"origin_end\",\n \"shortId\": \"oen\",\n \"columnName\": \"End (origin)\",\n \"description\": \"End of the loading process at the origin \",\n \"deprecated\": false,\n \"type\": \"datetime yyyy-MM-dd HH:mm\"\n },\n {\n \"id\": \"destination_country_name\",\n \"shortId\": \"dcn\",\n \"columnName\": \"Country (destination)\",\n \"description\": \"Name of the destination country\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"zone_destination_name\",\n \"shortId\": \"zdn\",\n \"columnName\": \"Zone Destination\",\n \"description\": \"Name of the destination area\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"installation_destination_name\",\n \"shortId\": \"idn\",\n \"columnName\": \"Installation Destination\",\n \"description\": \"Name of the destination installation\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"destination_start\",\n \"shortId\": \"dsd\",\n \"columnName\": \"Start (destination)\",\n \"description\": \"Start of the discharge process at destination\",\n \"deprecated\": false,\n \"type\": \"datetime yyyy-MM-dd HH:mm\"\n },\n {\n \"id\": \"closest_ancestor_family\",\n \"shortId\": \"cafam\",\n \"columnName\": \"Family\",\n \"description\": \"Product family\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"closest_ancestor_group\",\n \"shortId\": \"cagroup\",\n \"columnName\": \"Group\",\n \"description\": \"Product group\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"closest_ancestor_product\",\n \"shortId\": \"capro\",\n \"columnName\": \"Product\",\n \"description\": \"Product type\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"closest_ancestor_grade\",\n \"shortId\": \"cagrade\",\n \"columnName\": \"Grade\",\n \"description\": \"Product grade\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_id\",\n \"shortId\": \"tid\",\n \"columnName\": \"Id (Trade)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"port_call_origin_id\",\n \"shortId\": \"pcoid\",\n \"columnName\": \"Origin PortCall Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"port_call_destination_id\",\n \"shortId\": \"pcdid\",\n \"columnName\": \"Destination PortCall Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"voyage_id\",\n \"shortId\": \"voy\",\n \"columnName\": \"Id (Voyage)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"zone_origin_id\",\n \"shortId\": \"zoi\",\n \"columnName\": \"Zone Origin Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false,\n \"type\": \"long\"\n },\n {\n \"id\": \"zone_destination_id\",\n \"shortId\": \"zdi\",\n \"columnName\": \"Zone Destination Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false,\n \"type\": \"long\"\n },\n {\n \"id\": \"installation_origin_id\",\n \"shortId\": \"ioi\",\n \"columnName\": \"Installation origin id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false,\n \"type\": \"long\"\n },\n {\n \"id\": \"installation_destination_id\",\n \"shortId\": \"idi\",\n \"columnName\": \"Installation Destination Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false,\n \"type\": \"long\"\n },\n {\n \"id\": \"continent_destination_name\",\n \"shortId\": \"cdn\",\n \"columnName\": \"Continent Destination\",\n \"description\": \"Continent of destination\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"continent_origin_name\",\n \"shortId\": \"con\",\n \"columnName\": \"Continent Origin\",\n \"description\": \"Continent of origin\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"mileage_nautical_miles\",\n \"shortId\": \"mnm\",\n \"columnName\": \"Mileage\",\n \"description\": \"Distance between origin and destination\",\n \"deprecated\": false,\n \"type\": \"long\"\n },\n {\n \"id\": \"ton_miles\",\n \"shortId\": \"tom\",\n \"columnName\": \"Ton Miles\",\n \"description\": \"Ton/mile report\",\n \"deprecated\": false,\n \"type\": \"long\"\n },\n {\n \"id\": \"start\",\n \"shortId\": \"str\",\n \"columnName\": \"Date (origin)\",\n \"description\": \"Departure date of the vessel\",\n \"deprecated\": false,\n \"type\": \"datetime yyyy-MM-dd HH:mm\"\n },\n {\n \"id\": \"origin_location_name\",\n \"shortId\": \"oln\",\n \"columnName\": \"Origin\",\n \"description\": \"Origin location of the cargo\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"origin_reload_sts_partial\",\n \"shortId\": \"ota\",\n \"columnName\": \"Reload STS Partial (origin)\",\n \"description\": \"If field contains 'Partial' = Partial has occurred in this port call. Same logic applies for when “Reload” and 'STS' is returned for Re-loads and Ship-to-Ship transfers\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"end\",\n \"shortId\": \"end\",\n \"columnName\": \"Date (destination)\",\n \"description\": \"Arrival date of the vessel\",\n \"deprecated\": false,\n \"type\": \"datetime yyyy-MM-dd HH:mm\"\n },\n {\n \"id\": \"destination_location_name\",\n \"shortId\": \"dln\",\n \"columnName\": \"Destination\",\n \"description\": \"Destination location of the cargo\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"destination_reload_sts_partial\",\n \"shortId\": \"dta\",\n \"columnName\": \"Reload STS Partial (destination)\",\n \"description\": \"If field contains 'Partial' then Partial has occurred in this port call. Same logic applies for when 'Reload' and 'STS' is returned for Re-loads and Ship-to-Ship transfers.\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"status\",\n \"shortId\": \"stt\",\n \"columnName\": \"Trade status\",\n \"description\": \"'Scheduled' = cargo has not been picked up yet. 'In Transit' = cargo is in movement. 'Delivered' = cargo arrived to destination.\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"initial_seller_name\",\n \"shortId\": \"isn\",\n \"columnName\": \"Seller (origin)\",\n \"description\": \"Company name that sold cargo at the installation of origin\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"final_buyer_name\",\n \"shortId\": \"fbn\",\n \"columnName\": \"Buyer (destination)\",\n \"description\": \"Company name of the buyer at final destination\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"number_of_intermediaries\",\n \"shortId\": \"noi\",\n \"columnName\": \"Intermediaries\",\n \"description\": \"Number of intermediate players involved in the trade\",\n \"deprecated\": false,\n \"type\": \"integer\"\n },\n {\n \"id\": \"origin_subcontinent_name\",\n \"shortId\": \"osn\",\n \"columnName\": \"Subcontinent (origin)\",\n \"description\": \"Subcontinent of trade origin\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"origin_eta_date\",\n \"shortId\": \"oed\",\n \"columnName\": \"Eta (origin)\",\n \"description\": \"Estimated time of arrival at origin\",\n \"deprecated\": false,\n \"type\": \"datetime yyyy-MM-dd HH:mm\"\n },\n {\n \"id\": \"origin_start\",\n \"shortId\": \"ost\",\n \"columnName\": \"Start (origin)\",\n \"description\": \"Start date of the trip\",\n \"deprecated\": false,\n \"type\": \"datetime yyyy-MM-dd HH:mm\"\n },\n {\n \"id\": \"origin_eta_source\",\n \"shortId\": \"oes\",\n \"columnName\": \"Eta source (origin)\",\n \"description\": \"Source of the Estimated Time of Arrival to the Installation of Origin information (Port, Analyst, etc.)\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"destination_eta_source\",\n \"shortId\": \"des\",\n \"columnName\": \"Eta source (destination)\",\n \"description\": \"Source of the Estimated Time of Arrival to the Installation of Destination information (Port, Analyst, etc.)\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"destination_subcontinent_name\",\n \"shortId\": \"dsn\",\n \"columnName\": \"Subcontinent (destination)\",\n \"description\": \"Subcontinent of trade destination\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"destination_eta\",\n \"shortId\": \"ded\",\n \"columnName\": \"Eta (destination)\",\n \"description\": \"Estimated time of arrival at destination\",\n \"deprecated\": false,\n \"type\": \"datetime yyyy-MM-dd HH:mm\"\n },\n {\n \"id\": \"destination_end\",\n \"shortId\": \"den\",\n \"columnName\": \"End (destination)\",\n \"description\": \"Departure datetime from the destination\",\n \"deprecated\": false,\n \"type\": \"datetime yyyy-MM-dd HH:mm\"\n },\n {\n \"id\": \"vessel_capacity_cubic_meters\",\n \"shortId\": \"vcm\",\n \"columnName\": \"Capacity (vessel m3)\",\n \"description\": \"The maximum capacity of the vessel in cubic meters\",\n \"deprecated\": false,\n \"type\": \"long\"\n },\n {\n \"id\": \"vessel_type\",\n \"shortId\": \"vet\",\n \"columnName\": \"Vessel type\",\n \"description\": \"Type of the vessel 1\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"vessel_cargo_type\",\n \"shortId\": \"vct\",\n \"columnName\": \"Cargo type (vessel)\",\n \"description\": \"The specific cargo type of the vessel\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"vessel_id\",\n \"shortId\": \"vid\",\n \"columnName\": \"Id (vessel)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false,\n \"type\": \"long\"\n },\n {\n \"id\": \"vessel_imo\",\n \"shortId\": \"imo\",\n \"columnName\": \"IMO (vessel)\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"vessel_mmsi\",\n \"shortId\": \"msi\",\n \"columnName\": \"MMSI (vessel)\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"charterer_name\",\n \"shortId\": \"chn\",\n \"columnName\": \"Charterer\",\n \"description\": \"Current Controller of the vessel\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"zone_canal_transit\",\n \"shortId\": \"zct\",\n \"columnName\": \"Zone Canal Transit\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_1_delivery\",\n \"shortId\": \"t1d\",\n \"columnName\": \"Link1 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_1_type\",\n \"shortId\": \"t1t\",\n \"columnName\": \"Link1 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_1_seller_name\",\n \"shortId\": \"s1n\",\n \"columnName\": \"Link1 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_1_seller_country_name\",\n \"shortId\": \"s1c\",\n \"columnName\": \"Link1 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_1_buyer_name\",\n \"shortId\": \"n1b\",\n \"columnName\": \"Link1 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_1_buyer_country_name\",\n \"shortId\": \"b1c\",\n \"columnName\": \"Link1 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_2_delivery\",\n \"shortId\": \"t2d\",\n \"columnName\": \"Link2 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_2_type\",\n \"shortId\": \"t2t\",\n \"columnName\": \"Link2 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_2_seller_name\",\n \"shortId\": \"s2n\",\n \"columnName\": \"Link2 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_2_seller_country_name\",\n \"shortId\": \"s2c\",\n \"columnName\": \"Link2 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_2_buyer_name\",\n \"shortId\": \"n2b\",\n \"columnName\": \"Link2 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_2_buyer_country_name\",\n \"shortId\": \"b2c\",\n \"columnName\": \"Link2 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_3_delivery\",\n \"shortId\": \"t3d\",\n \"columnName\": \"Link3 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_3_type\",\n \"shortId\": \"t3t\",\n \"columnName\": \"Link3 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_3_seller_name\",\n \"shortId\": \"s3n\",\n \"columnName\": \"Link3 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_3_seller_country_name\",\n \"shortId\": \"s3c\",\n \"columnName\": \"Link3 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_3_buyer_name\",\n \"shortId\": \"n3b\",\n \"columnName\": \"Link3 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_3_buyer_country_name\",\n \"shortId\": \"b3c\",\n \"columnName\": \"Link3 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_4_delivery\",\n \"shortId\": \"t4d\",\n \"columnName\": \"Link4 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_4_type\",\n \"shortId\": \"t4t\",\n \"columnName\": \"Link4 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_4_seller_name\",\n \"shortId\": \"s4n\",\n \"columnName\": \"Link4 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_4_seller_country_name\",\n \"shortId\": \"s4c\",\n \"columnName\": \"Link4 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_4_buyer_name\",\n \"shortId\": \"n4b\",\n \"columnName\": \"Link4 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_4_buyer_country_name\",\n \"shortId\": \"b4c\",\n \"columnName\": \"Link4 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_5_delivery\",\n \"shortId\": \"t5d\",\n \"columnName\": \"Link5 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_5_type\",\n \"shortId\": \"t5t\",\n \"columnName\": \"Link5 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_5_seller_name\",\n \"shortId\": \"s5n\",\n \"columnName\": \"Link5 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_5_seller_country_name\",\n \"shortId\": \"s5c\",\n \"columnName\": \"Link5 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_5_buyer_name\",\n \"shortId\": \"n5b\",\n \"columnName\": \"Link5 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"trade_link_5_buyer_country_name\",\n \"shortId\": \"b5c\",\n \"columnName\": \"Link5 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"cargo_origin_tons_split_by_product\",\n \"shortId\": \"cotsp\",\n \"columnName\": \"Cargo (tons)\",\n \"description\": \"Quantity (tons) loaded/discharged at the terminal\",\n \"deprecated\": false,\n \"type\": \"long\"\n },\n {\n \"id\": \"closest_ancestor_grade_api\",\n \"shortId\": \"cagradeapi\",\n \"columnName\": \"Grade API\",\n \"description\": \"API grade of the product\",\n \"deprecated\": false,\n \"type\": \"float\"\n },\n {\n \"id\": \"closest_ancestor_grade_sulfur\",\n \"shortId\": \"cagradesulfur\",\n \"columnName\": \"Grade Sulfur\",\n \"description\": \"Sulfur grade of the product\",\n \"deprecated\": false,\n \"type\": \"float\"\n }\n ],\n \"unselected\": [\n {\n \"id\": \"product_id\",\n \"shortId\": \"proid\",\n \"columnName\": \"Id (Product)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false,\n \"type\": \"long\"\n },\n {\n \"id\": \"shipment_id\",\n \"shortId\": \"shipmtid\",\n \"columnName\": \"Id (Shipment)\",\n \"description\": \"Shipment Id in the database\",\n \"deprecated\": false,\n \"type\": \"long\"\n },\n {\n \"id\": \"parent_shipment_id\",\n \"shortId\": \"pshipmtid\",\n \"columnName\": \"Parent Id (Shipment)\",\n \"description\": \"Parent shipment Id in the database\",\n \"deprecated\": false,\n \"type\": \"long\"\n },\n {\n \"id\": \"vessel_dwt_1\",\n \"shortId\": \"dwt1\",\n \"columnName\": \"Vessel DWT\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"long\"\n },\n {\n \"id\": \"vessel_type2\",\n \"shortId\": \"vet2\",\n \"columnName\": \"Vessel Type 2\",\n \"description\": \"Type of the vessel 2\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"vessel_type3\",\n \"shortId\": \"vet3\",\n \"columnName\": \"Vessel Type 3\",\n \"description\": \"Type of the vessel 3\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"vessel_type4\",\n \"shortId\": \"vet4\",\n \"columnName\": \"Vessel Type 4\",\n \"description\": \"Type of the vessel 4\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"vessel_type_alt\",\n \"shortId\": \"vst_alt\",\n \"columnName\": \"Vessel Type Alternative \",\n \"description\": \"Type of the vessel 1 in the Oil classification (Product Tanker, Panamax, Aframax, Suezmax, VLCC, ULCC)\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"vessel_type_alt2\",\n \"shortId\": \"vst_alt2\",\n \"columnName\": \"Vessel Type Alternative 2\",\n \"description\": \"Type of the vessel 2 in the Oil classification (Product Tanker, Panamax, Aframax, Suezmax, VLCC, ULCC)\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"vessel_type_alt3\",\n \"shortId\": \"vst_alt3\",\n \"columnName\": \"Vessel Type Alternative 3\",\n \"description\": \"Type of the vessel 3 in the Oil classification (Product Tanker, Panamax, Aframax, Suezmax, VLCC, ULCC)\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"vessel_type_alt4\",\n \"shortId\": \"vst_alt4\",\n \"columnName\": \"Vessel Type Alternative 4\",\n \"description\": \"Type of the vessel 4 in the Oil classification (Product Tanker, Panamax, Aframax, Suezmax, VLCC, ULCC)\",\n \"deprecated\": false,\n \"type\": \"string\"\n }\n ]\n}"}],"_postman_id":"5946a885-f376-45c5-b779-76f5afeadbe9"},{"name":"/v1/trades/snapshot","event":[{"listen":"test","script":{"id":"3d8b9b2d-e1e4-4f67-80d3-afa9222329f7","exec":[""],"type":"text/javascript"}},{"listen":"prerequest","script":{"id":"a6202481-7d54-4275-94d2-3ffd06f08985","exec":[""],"type":"text/javascript"}}],"id":"760fd1ba-701b-4179-9b21-70252a9988fd","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"GET","header":[{"description":"

Required [String]: Token

\n","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":"https://api-dry.kpler.com/v1/trades/snapshot?snapshotDate={{date}}&vessels={{vessels}}&fromInstallations={{fromInstallations}}&toInstallations={{toInstallations}}&fromZones={{fromZones}}&toZones={{toZones}}&buyers={{buyers}}&sellers={{sellers}}&products={{products}}&startDate={{startDate}}&endDate={{endDate}}&tradeStatus={{tradeStatus}}&columns={{columns}}&hash={{hash}}","description":"

What is it and why to use it

Provides the last snapshot of all trades. The snapshot is a result of getTrades for all zones, vessels, and products, overall the history.
\n
This endpoint's main purpose is to be used as initialization of a local data store (or data lake /warehouse). After the data store has been set up, trade updates endpoint /v1/trades/updates provides daily deltas (see next section for more details).
\n
It allows users to view the state of the trades at a specific point in time.
\n
The snapshots are stored daily on a regular basis since September 2020 (2020-09-21T200000), the date of the first snapshot can vary depending on the commodity queried. This is an add on feature, please reach out to your Account Manager for more details.
\n
If you want to use point-in-time data, you need to specify the snapshotDate parameter. The snapshotDate parameter is a date in the format YYYY-MM-DD that specifies the date for which you want to retrieve data. For example, to retrieve data for January 1, 2023, you would specify snapshotDate=2023-01-01.
\n

How to use it

It must be run at least once, for the initialization, before using /v1/trades/updates. Once the initialization step has been performed, /v1/trades/updates can be used alone.

In addition to the body response, a header lastAvailableDate is returned. It must be used as the startDate parameter for /v1/trades/updates endpoint.

NOTE:

product_id and trade_id columns will always be returned, as it's used as an identifier of a row, and used in the same way for the /v1/trades/updates endpoint.
The result file can be heavy and exceed your platform API default Max response size. Be sure to have no such limitation.

FAQ

What is the difference between getTrades and Snapshot?

The snapshot is a result of the getTrades endpoint (see previous section on /v1/trades for more details). The only difference is that getTrades retrieves all trades available at that moment. The Snapshot, however, returns the trades with a small delay (less than 1 hour).

How to use

Open GIF in fullscreen

","urlObject":{"protocol":"https","path":["v1","trades","snapshot"],"host":["api-dry","kpler","com"],"query":[{"description":{"content":"

Format Date : YYYY-MM-DDTHHMMSS, if empty it's returning the last snapshot

\n","type":"text/plain"},"key":"snapshotDate","value":"{{date}}"},{"description":{"content":"

Optional [String]: Names/IMO's of vessels

\n","type":"text/plain"},"key":"vessels","value":"{{vessels}}"},{"description":{"content":"

Optional [String]: Names of the origin installations

\n","type":"text/plain"},"key":"fromInstallations","value":"{{fromInstallations}}"},{"description":{"content":"

Optional [String]: Names of the destination installations (terminal/refinery)

\n","type":"text/plain"},"key":"toInstallations","value":"{{toInstallations}}"},{"description":{"content":"

Optional [String]: Names of the origin zones (port/region/country/continent)

\n","type":"text/plain"},"key":"fromZones","value":"{{fromZones}}"},{"description":{"content":"

Optional [String]: Names of the destination zones (port/region/country/continent)

\n","type":"text/plain"},"key":"toZones","value":"{{toZones}}"},{"description":{"content":"

Optional [String]: Buyers of the cargo

\n","type":"text/plain"},"key":"buyers","value":"{{buyers}}"},{"description":{"content":"

Optional [String]: Sellers of the cargo

\n","type":"text/plain"},"key":"sellers","value":"{{sellers}}"},{"description":{"content":"

Optional [String]: Names of products

\n","type":"text/plain"},"key":"products","value":"{{products}}"},{"description":{"content":"

Optional [Date]: Start of the period (YYYY-MM-DD)

\n","type":"text/plain"},"key":"startDate","value":"{{startDate}}"},{"description":{"content":"

Optional [Date]: End of the period (YYYY-MM-DD)

\n","type":"text/plain"},"key":"endDate","value":"{{endDate}}"},{"description":{"content":"

Optional [String]: Return only trades of a particular status [“delivered”, ”loading”, ”in transit”, ”scheduled”]. By default value is scheduled.

\n","type":"text/plain"},"key":"tradeStatus","value":"{{tradeStatus}}"},{"description":{"content":"

Optional [String]: Retrieve all available columns when set to \"all\"

\n","type":"text/plain"},"key":"columns","value":"{{columns}}"},{"description":{"content":"

Optional [String]: Generate your favorite set of columns using the hash ( Look at the POST /v1/trades/columnsendpoint to learn more about how to generate the hash code )

Note: You cannot use it simultaneously with the ‘columns’ parameter

\n","type":"text/plain"},"key":"hash","value":"{{hash}}"}],"variable":[]}},"response":[{"id":"8a405a36-3163-4101-bd2d-c8a13ce75497","name":"Snapshot from the past","originalRequest":{"method":"GET","header":[{"description":"**Required [String]**: Token","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":{"raw":"https://api-dry.kpler.com/v1/trades/snapshot?snapshotDate=2020-09-25T020000","protocol":"https","host":["api-dry","kpler","com"],"path":["v1","trades","snapshot"],"query":[{"key":"columns","value":"{{columns}}","description":"Optional [String]: Retrieve all available columns when set to \"all\"","disabled":true},{"key":"hash","value":"{{hash}}","description":"Optional [String]: Generate your favorite set of columns using the hash ( Look at the `POST /v1/trades/columns`endpoint to learn more about how to generate the hash code )\n\n**Note:** You cannot use it simultaneously with the ‘columns’ parameter","disabled":true},{"key":"snapshotDate","value":"2020-09-25T020000"}]}},"_postman_previewlanguage":"Text","header":null,"cookie":[],"responseTime":null,"body":null},{"id":"e9ae4e9b-9447-4d98-b324-7ee5431de9c0","name":"Get trades snapshot","originalRequest":{"method":"GET","header":[{"description":"Required [String] : Token","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":"https://api-dry.kpler.com/v1/trades/snapshot"},"_postman_previewlanguage":"Text","header":[{"key":"lastAvailableDate","value":"2020-11-02T080100","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"Vessel;Country (origin);Zone Origin;Installation origin;End (origin);Country (destination);Zone Destination;Installation Destination;Start (destination);Family;Group;Product;Grade;Id (Trade);Origin PortCall Id;Destination PortCall Id;Id (Voyage);Zone Origin Id;Zone Destination Id;Installation origin id;Installation Destination Id;Continent Destination;Continent Origin;Mileage;Ton Miles;Date (origin);Origin;Reload STS Partial (origin);Date (destination);Destination;Reload STS Partial (destination);Trade status;Seller (origin);Buyer (destination);Intermediaries;Subcontinent (origin);Eta (origin);Start (origin);Eta source (origin);Eta source (destination);Subcontinent (destination);Eta (destination);End (destination);Capacity (vessel m3);Vessel type;Cargo type (vessel);Id (vessel);IMO (vessel);MMSI (vessel);Charterer;Zone Canal Transit;Link1 delivery;Link1 type;Link1 seller name;Link1 seller country;Link1 buyer name;Link1 buyer country;Link2 delivery;Link2 type;Link2 seller name;Link2 seller country;Link2 buyer name;Link2 buyer country;Link3 delivery;Link3 type;Link3 seller name;Link3 seller country;Link3 buyer name;Link3 buyer country;Link4 delivery;Link4 type;Link4 seller name;Link4 seller country;Link4 buyer name;Link4 buyer country;Link5 delivery;Link5 type;Link5 seller name;Link5 seller country;Link5 buyer name;Link5 buyer country;Cargo (tons);Grade API;Grade Sulfur;Id (Product)\nMoonbeam;Nigeria;Calabar;Calabar Grain Terminal;;;;;;minor bulks;minerals;gypsum;;1809511;3388930;;1076428;1702;;7891;;;Africa;;;2022-07-13 17:45;Calabar Grain Terminal;;;;;Scheduled;;;;Western Africa;2022-07-09 00:00;;Port;;;;;56888;Supramax;;85528;9493987;636092952;Orion;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;56035;;;1572\nYasa Pioneer;Brazil;Santos;;;;;;;dry bulk;;;;1842347;3628656;;1094003;1427;;;;;Americas;;;2021-01-29 01:01;Santos;;;;;Scheduled;ADM,Ultracargo;;0;South America;2021-01-22 23:20;;AIS;;;;;81067;Kamsarmax;;73320;9286578;538002531;;;;Spot;ADM,Ultracargo;;;;;;;;;;;;;;;;;;;;;;;;;;;;79852;;;1414\nGolafruz;Brazil;Imbituba;Imbituba;;;;;;dry bulk;;;;1843431;3630497;;1094659;1870;;358;;;Americas;;;2021-01-17 17:11;Imbituba;;;;;Scheduled;;;;South America;2021-01-12 12:00;;AIS;;;;;72080;Panamax;;75884;9323833;422050300;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;70999;;;1414\nIvestos 5;Indonesia;Balikpapan;Balikpapan Coal Terminal;;;;;;major bulks;coal;thermal;;1836446;3618596;;1090369;2656;;100;;;Asia;;;2021-01-09 16:40;Balikpapan Coal Terminal;Partial;;;;Scheduled;Gunung Bayan;;0;South-East Asia;2021-01-08 03:30;;AIS;;;;;75078;Panamax;;74586;9304265;636019318;;;;Spot;Gunung Bayan;Indonesia;;;;;;;;;;;;;;;;;;;;;;;;;;;12013;;;2298\nNordrubicon;United States;Long Beach;;;;;;;dry bulk;;;;1847588;3027397;;1097069;2551;;;;;Americas;;;2021-01-02 14:21;Long Beach;;;;;Scheduled;;;;Northern America;2020-12-31 00:00;;Market;;;;;37168;Handysize;;100075;9763693;255806292;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;36611;;;1414\nKesaria;Argentina;Quequen Necochea;Quequen;;;;;;major bulks;grains;;;1848691;2992664;;1047460;1856;;310;;;Americas;;;2020-12-30 05:14;Quequen;;;;;Scheduled;;;;South America;2020-12-27 00:00;;Market;;;;;80170;Kamsarmax;;81031;9418444;538005909;Bunge;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;78968;;;1554\n(truncated response)"},{"id":"68c96b34-d963-4714-a50d-6c4805a2e8e5","name":"Columns id, name, description and deprecation status","originalRequest":{"method":"GET","header":[],"url":"https://api-dry.kpler.com/v1/trades/snapshot/columns"},"_postman_previewlanguage":"json","header":null,"cookie":[],"responseTime":null,"body":"{\n \"Columns by default\": [\n {\n \"id\": \"vessel_name\",\n \"shortId\": \"ven\",\n \"columnName\": \"Vessel\",\n \"description\": \"Name of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"cargo_origin_barrels_split_by_product\",\n \"shortId\": \"cobsp\",\n \"columnName\": \"Volume (bbl)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_grade\",\n \"shortId\": \"cagrade\",\n \"columnName\": \"Grade\",\n \"description\": \"Product grade\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_product\",\n \"shortId\": \"capro\",\n \"columnName\": \"Product\",\n \"description\": \"Product type\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_group\",\n \"shortId\": \"cagroup\",\n \"columnName\": \"Group\",\n \"description\": \"Product group\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_family\",\n \"shortId\": \"cafam\",\n \"columnName\": \"Family\",\n \"description\": \"Product family\",\n \"deprecated\": false\n },\n {\n \"id\": \"start\",\n \"shortId\": \"str\",\n \"columnName\": \"Date (origin)\",\n \"description\": \"Departure date of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_location_name\",\n \"shortId\": \"oln\",\n \"columnName\": \"Origin\",\n \"description\": \"Origin location of the cargo\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_eta_source\",\n \"shortId\": \"oes\",\n \"columnName\": \"Eta source (origin)\",\n \"description\": \"Source of the Estimated Time of Arrival to the Installation of Origin information (Port, Analyst, etc.)\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_reload_sts_partial\",\n \"shortId\": \"ota\",\n \"columnName\": \"Reload STS Partial (origin)\",\n \"description\": \"If field contains 'Partial' = Partial has occurred in this port call. Same logic applies for when “Reload” and 'STS' is returned for Re-loads and Ship-to-Ship transfers\",\n \"deprecated\": false\n },\n {\n \"id\": \"end\",\n \"shortId\": \"end\",\n \"columnName\": \"Date (destination)\",\n \"description\": \"Arrival date of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_location_name\",\n \"shortId\": \"dln\",\n \"columnName\": \"Destination\",\n \"description\": \"Destination location of the cargo\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_eta_source\",\n \"shortId\": \"des\",\n \"columnName\": \"Eta source (destination)\",\n \"description\": \"Source of the Estimated Time of Arrival to the Installation of Destination information (Port, Analyst, etc.)\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_reload_sts_partial\",\n \"shortId\": \"dta\",\n \"columnName\": \"Reload STS Partial (destination)\",\n \"description\": \"If field contains 'Partial' then Partial has occurred in this port call. Same logic applies for when 'Reload' and 'STS' is returned for Re-loads and Ship-to-Ship transfers.\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_destination_location_name\",\n \"shortId\": \"fdl\",\n \"columnName\": \"Forecasted destination\",\n \"description\": \"Next destination forecasted\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_destination_location_eta\",\n \"shortId\": \"fde\",\n \"columnName\": \"Forecasted ETA\",\n \"description\": \"Next destination ETA forecasted\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_destination_confidence\",\n \"shortId\": \"fdc\",\n \"columnName\": \"Forecasted confidence\",\n \"description\": \"Confidence (in %) of the system forecast\",\n \"deprecated\": false\n },\n {\n \"id\": \"status\",\n \"shortId\": \"stt\",\n \"columnName\": \"Trade status\",\n \"description\": \"'Scheduled' = cargo has not been picked up yet. 'In Transit' = cargo is in movement. 'Delivered' = cargo arrived to destination.\",\n \"deprecated\": false\n },\n {\n \"id\": \"initial_seller_name\",\n \"shortId\": \"isn\",\n \"columnName\": \"Seller (origin)\",\n \"description\": \"Company name that sold cargo at the installation of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"final_buyer_name\",\n \"shortId\": \"fbn\",\n \"columnName\": \"Buyer (destination)\",\n \"description\": \"Company name of the buyer at final destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"number_of_intermediaries\",\n \"shortId\": \"noi\",\n \"columnName\": \"Intermediaries\",\n \"description\": \"Number of intermediate players involved in the trade\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_country_name\",\n \"shortId\": \"ocn\",\n \"columnName\": \"Country (origin)\",\n \"description\": \"Name of the origin country\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_subcontinent_name\",\n \"shortId\": \"osn\",\n \"columnName\": \"Subcontinent (origin)\",\n \"description\": \"Subcontinent of trade origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"continent_origin_name\",\n \"shortId\": \"con\",\n \"columnName\": \"Continent Origin\",\n \"description\": \"Continent of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_eta_date\",\n \"shortId\": \"oed\",\n \"columnName\": \"Eta (origin)\",\n \"description\": \"Estimated time of arrival at origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_start\",\n \"shortId\": \"ost\",\n \"columnName\": \"Start (origin)\",\n \"description\": \"Start date of the trip\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_end\",\n \"shortId\": \"oen\",\n \"columnName\": \"End (origin)\",\n \"description\": \"End of the loading process at the origin \",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_country_name\",\n \"shortId\": \"dcn\",\n \"columnName\": \"Country (destination)\",\n \"description\": \"Name of the destination country\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_subcontinent_name\",\n \"shortId\": \"dsn\",\n \"columnName\": \"Subcontinent (destination)\",\n \"description\": \"Subcontinent of trade destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"continent_destination_name\",\n \"shortId\": \"cdn\",\n \"columnName\": \"Continent Destination\",\n \"description\": \"Continent of destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_eta\",\n \"shortId\": \"ded\",\n \"columnName\": \"Eta (destination)\",\n \"description\": \"Estimated time of arrival at destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_start\",\n \"shortId\": \"dsd\",\n \"columnName\": \"Start (destination)\",\n \"description\": \"Start of the discharge process at destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_end\",\n \"shortId\": \"den\",\n \"columnName\": \"End (destination)\",\n \"description\": \"Departure datetime from the destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_capacity_cubic_meters\",\n \"shortId\": \"vcm\",\n \"columnName\": \"Capacity (vessel m3)\",\n \"description\": \"The maximum capacity of the vessel in cubic meters\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_type\",\n \"shortId\": \"vet\",\n \"columnName\": \"Vessel type\",\n \"description\": \"Type of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_cargo_type\",\n \"shortId\": \"vct\",\n \"columnName\": \"Cargo type (vessel)\",\n \"description\": \"The specific cargo type of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_id\",\n \"shortId\": \"vid\",\n \"columnName\": \"Id (vessel)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_id\",\n \"shortId\": \"tid\",\n \"columnName\": \"Id (Trade)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"zone_origin_name\",\n \"shortId\": \"zon\",\n \"columnName\": \"Zone Origin\",\n \"description\": \"Name of the origin area\",\n \"deprecated\": false\n },\n {\n \"id\": \"zone_origin_id\",\n \"shortId\": \"zoi\",\n \"columnName\": \"Zone Origin Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"zone_destination_name\",\n \"shortId\": \"zdn\",\n \"columnName\": \"Zone Destination\",\n \"description\": \"Name of the destination area\",\n \"deprecated\": false\n },\n {\n \"id\": \"zone_destination_id\",\n \"shortId\": \"zdi\",\n \"columnName\": \"Zone Destination Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_origin_name\",\n \"shortId\": \"ion\",\n \"columnName\": \"Installation origin\",\n \"description\": \"Name of the origin installation\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_origin_id\",\n \"shortId\": \"ioi\",\n \"columnName\": \"Installation origin id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_destination_name\",\n \"shortId\": \"idn\",\n \"columnName\": \"Installation Destination\",\n \"description\": \"Name of the destination installation\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_destination_id\",\n \"shortId\": \"idi\",\n \"columnName\": \"Installation Destination Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"mileage_nautical_miles\",\n \"shortId\": \"mnm\",\n \"columnName\": \"Mileage\",\n \"description\": \"Distance between origin and destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"ton_miles\",\n \"shortId\": \"tom\",\n \"columnName\": \"Ton Miles\",\n \"description\": \"Ton/mile report\",\n \"deprecated\": false\n },\n {\n \"id\": \"voyage_id\",\n \"shortId\": \"voy\",\n \"columnName\": \"Id (Voyage)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n }\n ],\n \"Optional Columns\": [\n {\n \"id\": \"cargo_origin_tons_split_by_product\",\n \"shortId\": \"cotsp\",\n \"columnName\": \"Cargo (tons)\",\n \"description\": \"Quantity (tons) loaded/discharged at the terminal\",\n \"deprecated\": false\n },\n {\n \"id\": \"cargo_sources\",\n \"shortId\": \"cargo_sources\",\n \"columnName\": \"Cargo Sources\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"charterer_name\",\n \"shortId\": \"chn\",\n \"columnName\": \"Charterer\",\n \"description\": \"Current Controller of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_country_1\",\n \"shortId\": \"stco1\",\n \"columnName\": \"Country STS 1\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_country_2\",\n \"shortId\": \"stco2\",\n \"columnName\": \"Country STS 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_country_3\",\n \"shortId\": \"stco3\",\n \"columnName\": \"Country STS 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_end_date1\",\n \"shortId\": \"sted1\",\n \"columnName\": \"Date End STS 1\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_end_date2\",\n \"shortId\": \"sted2\",\n \"columnName\": \"Date End STS 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_end_date3\",\n \"shortId\": \"sted3\",\n \"columnName\": \"Date End STS 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_start_date_1\",\n \"shortId\": \"stsd1\",\n \"columnName\": \"Date Start STS 1\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_start_date_2\",\n \"shortId\": \"stsd2\",\n \"columnName\": \"Date Start STS 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_start_date_3\",\n \"shortId\": \"stsd3\",\n \"columnName\": \"Date Start STS 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"port_call_destination_id\",\n \"shortId\": \"pcdid\",\n \"columnName\": \"Destination PortCall Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"export_price\",\n \"shortId\": \"epr\",\n \"columnName\": \"Export price\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_origin_location_name\",\n \"shortId\": \"fol\",\n \"columnName\": \"Forecasted origin\",\n \"description\": \"Next origin forecasted\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_origin_eta\",\n \"shortId\": \"foe\",\n \"columnName\": \"Forecasted origin ETA\",\n \"description\": \"Next origin ETA forecasted\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_origin_confidence\",\n \"shortId\": \"foc\",\n \"columnName\": \"Forecasted origin confidence\",\n \"description\": \"Confidence (in %) of the system forecast\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_grade_api\",\n \"shortId\": \"cagradeapi\",\n \"columnName\": \"Grade API\",\n \"description\": \"API grade of the product\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_grade_sulfur\",\n \"shortId\": \"cagradesulfur\",\n \"columnName\": \"Grade Sulfur\",\n \"description\": \"Sulfur grade of the product\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_imo\",\n \"shortId\": \"imo\",\n \"columnName\": \"IMO (vessel)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"product_id\",\n \"shortId\": \"proid\",\n \"columnName\": \"Id (Product)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"import_price\",\n \"shortId\": \"ipr\",\n \"columnName\": \"Import price\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"ship_to_ship_installation_1\",\n \"shortId\": \"stsi1\",\n \"columnName\": \"Installation STS 1\",\n \"description\": \"Ship to ship installation\",\n \"deprecated\": false\n },\n {\n \"id\": \"ship_to_ship_installation_2\",\n \"shortId\": \"stsi2\",\n \"columnName\": \"Installation STS 2\",\n \"description\": \"Ship to ship installation\",\n \"deprecated\": false\n },\n {\n \"id\": \"ship_to_ship_installation_3\",\n \"shortId\": \"stsi3\",\n \"columnName\": \"Installation STS 3\",\n \"description\": \"Ship to ship installation\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_buyer_country_name\",\n \"shortId\": \"b1c\",\n \"columnName\": \"Link1 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_buyer_name\",\n \"shortId\": \"n1b\",\n \"columnName\": \"Link1 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_delivery\",\n \"shortId\": \"t1d\",\n \"columnName\": \"Link1 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_seller_country_name\",\n \"shortId\": \"s1c\",\n \"columnName\": \"Link1 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_seller_name\",\n \"shortId\": \"s1n\",\n \"columnName\": \"Link1 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_type\",\n \"shortId\": \"t1t\",\n \"columnName\": \"Link1 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_buyer_country_name\",\n \"shortId\": \"b2c\",\n \"columnName\": \"Link2 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_buyer_name\",\n \"shortId\": \"n2b\",\n \"columnName\": \"Link2 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_delivery\",\n \"shortId\": \"t2d\",\n \"columnName\": \"Link2 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_seller_country_name\",\n \"shortId\": \"s2c\",\n \"columnName\": \"Link2 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_seller_name\",\n \"shortId\": \"s2n\",\n \"columnName\": \"Link2 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_type\",\n \"shortId\": \"t2t\",\n \"columnName\": \"Link2 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_buyer_country_name\",\n \"shortId\": \"b3c\",\n \"columnName\": \"Link3 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_buyer_name\",\n \"shortId\": \"n3b\",\n \"columnName\": \"Link3 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_delivery\",\n \"shortId\": \"t3d\",\n \"columnName\": \"Link3 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_seller_country_name\",\n \"shortId\": \"s3c\",\n \"columnName\": \"Link3 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_seller_name\",\n \"shortId\": \"s3n\",\n \"columnName\": \"Link3 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_type\",\n \"shortId\": \"t3t\",\n \"columnName\": \"Link3 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_buyer_country_name\",\n \"shortId\": \"b4c\",\n \"columnName\": \"Link4 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_buyer_name\",\n \"shortId\": \"n4b\",\n \"columnName\": \"Link4 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_delivery\",\n \"shortId\": \"t4d\",\n \"columnName\": \"Link4 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_seller_country_name\",\n \"shortId\": \"s4c\",\n \"columnName\": \"Link4 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_seller_name\",\n \"shortId\": \"s4n\",\n \"columnName\": \"Link4 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_type\",\n \"shortId\": \"t4t\",\n \"columnName\": \"Link4 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_buyer_country_name\",\n \"shortId\": \"b5c\",\n \"columnName\": \"Link5 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_buyer_name\",\n \"shortId\": \"n5b\",\n \"columnName\": \"Link5 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_delivery\",\n \"shortId\": \"t5d\",\n \"columnName\": \"Link5 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_seller_country_name\",\n \"shortId\": \"s5c\",\n \"columnName\": \"Link5 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_seller_name\",\n \"shortId\": \"s5n\",\n \"columnName\": \"Link5 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_type\",\n \"shortId\": \"t5t\",\n \"columnName\": \"Link5 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_mmsi\",\n \"shortId\": \"msi\",\n \"columnName\": \"MMSI (vessel)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"export_number_of_trades\",\n \"shortId\": \"ent\",\n \"columnName\": \"Number of trades (export)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"import_number_of_trades\",\n \"shortId\": \"int\",\n \"columnName\": \"Number of trades (import)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"port_call_origin_id\",\n \"shortId\": \"pcoid\",\n \"columnName\": \"Origin PortCall Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_dwt_1\",\n \"shortId\": \"dwt1\",\n \"columnName\": \"Vessel DWT\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_dwt_2\",\n \"shortId\": \"dwt2\",\n \"columnName\": \"Vessel DWT 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_dwt_3\",\n \"shortId\": \"dwt3\",\n \"columnName\": \"Vessel DWT 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_dwt_4\",\n \"shortId\": \"dwt4\",\n \"columnName\": \"Vessel DWT 4\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_imo_2\",\n \"shortId\": \"imo2\",\n \"columnName\": \"Vessel IMO 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_imo_3\",\n \"shortId\": \"imo3\",\n \"columnName\": \"Vessel IMO 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_imo_4\",\n \"shortId\": \"imo4\",\n \"columnName\": \"Vessel IMO 4\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_id_2\",\n \"shortId\": \"vid2\",\n \"columnName\": \"Vessel Id 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_id_3\",\n \"shortId\": \"vid3\",\n \"columnName\": \"Vessel Id 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_id_4\",\n \"shortId\": \"vid4\",\n \"columnName\": \"Vessel Id 4\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_name_2\",\n \"shortId\": \"ven2\",\n \"columnName\": \"Vessel Name 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_name_3\",\n \"shortId\": \"ven3\",\n \"columnName\": \"Vessel Name 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_name_4\",\n \"shortId\": \"ven4\",\n \"columnName\": \"Vessel Name 4\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"ship_to_ship_volume_1\",\n \"shortId\": \"stsv1\",\n \"columnName\": \"Volume STS 1\",\n \"description\": \"Ship to ship volume\",\n \"deprecated\": false\n },\n {\n \"id\": \"ship_to_ship_volume_2\",\n \"shortId\": \"stsv2\",\n \"columnName\": \"Volume STS 2\",\n \"description\": \"Ship to ship volume\",\n \"deprecated\": false\n },\n {\n \"id\": \"ship_to_ship_volume_3\",\n \"shortId\": \"stsv3\",\n \"columnName\": \"Volume STS 3\",\n \"description\": \"Ship to ship volume\",\n \"deprecated\": false\n },\n {\n \"id\": \"voyage_id_2\",\n \"shortId\": \"voyage_id_2\",\n \"columnName\": \"Voyage Id 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"voyage_id_3\",\n \"shortId\": \"voyage_id_3\",\n \"columnName\": \"Voyage Id 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"voyage_id_4\",\n \"shortId\": \"voyage_id_4\",\n \"columnName\": \"Voyage Id 4\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"zone_canal_transit\",\n \"shortId\": \"zct\",\n \"columnName\": \"Zone Canal Transit\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_zone_1\",\n \"shortId\": \"st1\",\n \"columnName\": \"Zone STS 1\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_zone_2\",\n \"shortId\": \"st2\",\n \"columnName\": \"Zone STS 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_zone_3\",\n \"shortId\": \"st3\",\n \"columnName\": \"Zone STS 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_zone_1_id\",\n \"shortId\": \"stzid1\",\n \"columnName\": \"Zone STS Id 1\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_zone_2_id\",\n \"shortId\": \"stzid2\",\n \"columnName\": \"Zone STS Id 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_zone_3_id\",\n \"shortId\": \"stzid3\",\n \"columnName\": \"Zone STS Id 3\",\n \"description\": null,\n \"deprecated\": false\n }\n ]\n}"}],"_postman_id":"760fd1ba-701b-4179-9b21-70252a9988fd"},{"name":"/v1/trades/snapshot/list","event":[{"listen":"test","script":{"id":"3d8b9b2d-e1e4-4f67-80d3-afa9222329f7","exec":[""],"type":"text/javascript"}},{"listen":"prerequest","script":{"id":"a6202481-7d54-4275-94d2-3ffd06f08985","exec":[""],"type":"text/javascript"}}],"id":"5c04af58-2f3a-4016-9318-2440cfb5680b","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"GET","header":[{"description":"

Required [String]: Token

\n","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":"https://api-dry.kpler.com/v1/trades/snapshot/list?startDate={{startDate}}&endDate={{endDate}}","description":"

List of snapshots provides a list of all the available snapshots in our /v1/trades/snapshot endpoint. You can filter the data by start date and end date.

Note that the duration between the start date and end date cannot exceed one month.

\n","urlObject":{"protocol":"https","path":["v1","trades","snapshot","list"],"host":["api-dry","kpler","com"],"query":[{"description":{"content":"

Required [Date]: Start of the period (YYYY-MM-DD)

\n","type":"text/plain"},"key":"startDate","value":"{{startDate}}"},{"description":{"content":"

Required [Date]: End of the period (YYYY-MM-DD)

\n","type":"text/plain"},"key":"endDate","value":"{{endDate}}"}],"variable":[]}},"response":[{"id":"c251cbd0-8027-48a4-8575-ababfd954585","name":"Retrieve a list of snapshots","originalRequest":{"method":"GET","header":[{"description":"**Required [String]**: Token","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":{"raw":"https://api-dry.kpler.com/v1/trades/snapshot/list?startDate=2023-05-01&endDate=2023-05-05","protocol":"https","host":["api-dry","kpler","com"],"path":["v1","trades","snapshot","list"],"query":[{"key":"startDate","value":"2023-05-01","description":"Optional [Date]: Start of the period (YYYY-MM-DD)"},{"key":"endDate","value":"2023-05-05","description":"Optional [Date]: End of the period (YYYY-MM-DD)"}]}},"status":"OK","code":200,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Wed, 10 May 2023 15:51:52 GMT"},{"key":"Content-Type","value":"text/csv; charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"Vary","value":"*,Accept-Encoding"},{"key":"Pragma","value":"no-cache"},{"key":"Cache-Control","value":"private, no-cache, no-store, must-revalidate, max-age=0, proxy-revalidate, s-maxage=0, Expires: Sat, 12 Oct 1991 05:00:00 GMT"},{"key":"Content-Encoding","value":"gzip"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"X-Kong-Upstream-Latency","value":"640"},{"key":"X-Kong-Proxy-Latency","value":"1"},{"key":"Via","value":"kong/3.2.1.0-enterprise-edition"}],"cookie":[],"responseTime":null,"body":"2023-05-01T000100\n2023-05-01T010100\n2023-05-01T020100\n2023-05-01T030100\n2023-05-01T040100\n2023-05-01T050100\n2023-05-01T060100\n2023-05-01T070100\n2023-05-01T080100\n2023-05-01T090100\n2023-05-01T100100\n2023-05-01T110100\n2023-05-01T120100\n2023-05-01T130100\n2023-05-01T140100\n2023-05-01T150100\n2023-05-01T160100\n2023-05-01T170100\n2023-05-01T180000\n2023-05-01T190100\n2023-05-01T200100\n2023-05-01T210100\n2023-05-01T220100\n2023-05-01T230100\n2023-05-02T000100\n2023-05-02T010100\n2023-05-02T020100\n2023-05-02T030100\n2023-05-02T040100\n2023-05-02T050100\n2023-05-02T060100\n2023-05-02T070100\n2023-05-02T080100\n2023-05-02T090100\n2023-05-02T100100\n2023-05-02T110100\n2023-05-02T120100\n2023-05-02T130100\n2023-05-02T140100\n2023-05-02T150100\n2023-05-02T160100\n2023-05-02T170100\n2023-05-02T180100\n2023-05-02T190100\n2023-05-02T200100\n2023-05-02T210100\n2023-05-02T220100\n2023-05-02T230100\n2023-05-03T000100\n2023-05-03T010100\n2023-05-03T020100\n2023-05-03T030100\n2023-05-03T040100\n2023-05-03T050100\n2023-05-03T060100\n2023-05-03T070100\n2023-05-03T080100\n2023-05-03T090100\n2023-05-03T100100\n2023-05-03T110100\n2023-05-03T120100\n2023-05-03T130000\n2023-05-03T140100\n2023-05-03T150100\n2023-05-03T160100\n2023-05-03T170100\n2023-05-03T180100\n2023-05-03T190100\n2023-05-03T200100\n2023-05-03T210100\n2023-05-03T220100\n2023-05-03T230100\n2023-05-04T000100\n2023-05-04T010100\n2023-05-04T020100\n2023-05-04T030100\n2023-05-04T040100\n2023-05-04T050100\n2023-05-04T060100\n2023-05-04T070100\n2023-05-04T080100\n2023-05-04T090100\n2023-05-04T100100\n2023-05-04T110100\n2023-05-04T120100\n2023-05-04T130100\n2023-05-04T140100\n2023-05-04T150100\n2023-05-04T160100\n2023-05-04T170100\n2023-05-04T180100\n2023-05-04T190100\n2023-05-04T200100\n2023-05-04T210000\n2023-05-04T220100\n2023-05-04T230100\n2023-05-05T000100\n2023-05-05T010100\n2023-05-05T020100\n2023-05-05T030100\n2023-05-05T040000\n2023-05-05T050100\n2023-05-05T060100\n2023-05-05T070100\n2023-05-05T080000\n2023-05-05T090100\n2023-05-05T100100\n2023-05-05T110100\n2023-05-05T120100\n2023-05-05T130100\n2023-05-05T140100\n2023-05-05T150100\n2023-05-05T160100\n2023-05-05T170100\n2023-05-05T180100\n2023-05-05T190100\n2023-05-05T200100\n2023-05-05T210100\n2023-05-05T220100\n2023-05-05T230100"}],"_postman_id":"5c04af58-2f3a-4016-9318-2440cfb5680b"},{"name":"/v1/trades/updates","event":[{"listen":"test","script":{"id":"c2d67376-c693-41da-ba78-f57d677a494b","exec":[""],"type":"text/javascript"}},{"listen":"prerequest","script":{"id":"e5969d9a-34f1-41c3-ba10-8aa486f0d09a","exec":[""],"type":"text/javascript"}}],"id":"3b1fafbb-97ee-4c28-be0f-f6f8ba689f15","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"GET","header":[{"description":"

Required [String]: Token

\n","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":"https://api-dry.kpler.com/v1/trades/updates?startDate={{startDate}}&showAllHistory={{showAllHistory}}&columns={{columns}}&hash={{hash}}&products={{products}}","description":"

Returns the delta in trades that happened since the startDate mandatory parameter, until a point in time. That point in time is returned in the lastAvailableDate response header.

For the first call, this startDate parameter should come from the header lastAvailableDate return by v1/trades/snapshot,\nthen for following calls will use the lastAvailableDate returned by v1/trades/updates itself.

\n
\n\n

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Columns	Description
productId	Product ID
tradeId	Trade ID
date	Date of operation using following format: YYYY-MM-DDTHHmmss time format
operation type	Types of operations can be as follows: INSERT, UPDATE, DELETE
jsonUpdates	Represents the impacted field of an INSERT or UPDATE operation. It's return in JSON text format

NOTE:

Calling /v1/trades/snapshot once to initialize your data store/ data lake/ data warehouse, and schedule the call to /v1/trades/snapshot is more optimal than calling /v1/trades lot of times. Further more calling /v1/trades won't prevent you from inconsistency in data as it's a live endpoint.

How to use

The lastAvailableSnapshot is 2020-10-28T130100. Therefore, the update is to be run against another snapshot prior to this date. Here, we used 2020-10-28T120000, prior to lastAvailableSnapshot provided by /v1/trades/snapshot earlier.

Open GIF in fullscreen\n $\"Alt$

\n
\n\n

The lastAvailableSnapshot is 2020-10-28T130100. When using startDate=2020-10-28T130100, we are comparing the snapshot of 2020-10-28T130100 against the one of 2020-10-28T130100, aka itself. There is no difference for the snapshot versus itself, hence an empty result.

Open GIF in fullscreen\n $\"Alt$

\n
\n\n

The lastAvailableSnapshot is 2020-10-28T130100. We are trying to compare a snapshot that do not exist yet, the one of 2020-10-28T140100, to the lastAvailableSnapshot. As a consequence, an error rises.

Open GIF in fullscreen\n $\"Alt$ \n

\n
\n\n

How showAllHistory parameter works?

This parameter is meant to provide the different states of the data over time.

If set to true, all states of the diffs are returned.

e.g 1: if a Trade changes 3 times since the startDate then you'll get 3 rows.

e.g 2: if a Trade changes 2 times since the startDate and is eventually deleted, both Updates and the Delete operation will be returned, so 3 rows as well.

If set to false, it enable compaction, meaning that all operations since startDate will be condensed in one line.

e.g 1: if a Trade changes 3 times since the startDate then you'll get a single row compacting the 3 changes.

e.g 2: if a Trade is changes 2 times since the startDate and is eventually deleted, only the Delete operation will be returned.

For a same time period, more rows will be returned when showAllHistory is set to true. \nFor a same trade_id product_id couple, more than one operation can be returned, compared to a single one when showAllHistory is set to false.

Example 1:

showAllHistory set to true

trade_id 1 product_id A time t1 -> 1 update field A
trade_id 1 product_id A time t2 -> 1 update field B
trade_id 1 product_id A time t3 -> 1 update field C

showAllHistory set to false

trade_id 1 product_id A time t3 -> 1 update field A, B, C

Example 2

showAllHistory set to true

trade_id 1 product_id A time t1 -> 1 update field A
trade_id 1 product_id A time t2 -> 1 update field B
trade_id 1 product_id A time t3 -> 1 delete

showAllHistory set to false

trade_id 1 product_id A time t3 -> 1 delete

NOTE: showAllHistory set to true takes more time to process as it doesn't stream the results as showAllHistory set to false does.

\n","urlObject":{"protocol":"https","path":["v1","trades","updates"],"host":["api-dry","kpler","com"],"query":[{"description":{"content":"

Required [String]: Use following format: YYYY-MM-DDTHHmmss.\nThe starting point in time of the returned \"diffs\", in UTC 0 time. All diffs that have been computed strictly after that date will be returned.

Note: a time window of 15 days of diffs are kept, you can't look before in the past

\n","type":"text/plain"},"key":"startDate","value":"{{startDate}}"},{"description":{"content":"

Optional [String]: Use ['true', 'false']. Default to false if not specified.

\n","type":"text/plain"},"key":"showAllHistory","value":"{{showAllHistory}}"},{"description":{"content":"

Optional [String]: Retrieve all available columns when set to \"all\"

\n","type":"text/plain"},"key":"columns","value":"{{columns}}"},{"description":{"content":"

Optional [String]: Generate your favorite set of columns using the hash ( Look at the POST /v1/trades/columnsendpoint to learn more about how to generate the hash code )

Note: You cannot use it simultaneously with the ‘columns’ parameter

\n","type":"text/plain"},"key":"hash","value":"{{hash}}"},{"description":{"content":"

Optional [String]: Names of products

\n","type":"text/plain"},"key":"products","value":"{{products}}"}],"variable":[]}},"response":[{"id":"22f744da-e4a8-4ed4-bd08-8c111b907f40","name":"Get trades since 1st January 2020","originalRequest":{"method":"GET","header":[{"description":"Required [String] : Token","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":{"raw":"https://api-dry.kpler.com/v1/trades/updates?startDate=2020-01-01T090721","protocol":"https","host":["api-dry","kpler","com"],"path":["v1","trades","updates"],"query":[{"key":"startDate","value":"2020-01-01T090721"}]}},"_postman_previewlanguage":"Text","header":[{"key":"lastAvailableDate","value":"2020-11-02T080100","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"productId;tradeId;date;operation;jsonUpdates\n1414;1840719;2020-10-31T170100;UPDATE;{\"Country (destination)\":\"Cameroon\",\"Zone Destination\":\"Douala\",\"Installation Destination\":\"Douala\",\"Start (destination)\":\"2020-10-18 18:59\",\"Destination PortCall Id\":\"3615627\",\"Zone Destination Id\":\"1996\",\"Installation Destination Id\":\"814\",\"Mileage\":\"710\",\"Ton Miles\":\"11877704\",\"Date (destination)\":\"2020-10-18 18:59\",\"Destination\":\"Douala\",\"Reload STS Partial (destination)\":\"\",\"Trade status\":\"Delivered\",\"Eta source (destination)\":\"\",\"Eta (destination)\":\"\",\"End (destination)\":\"2020-10-23 23:24\"}\n2298;1820272;2020-10-30T120100;UPDATE;{\"End (destination)\":\"2020-10-30 11:13\"}\n1838;1676175;2020-10-30T140100;UPDATE;{\"Ton Miles\":\"178423454\",\"Cargo (tons)\":\"31963\"}\n1414;1848916;2020-10-31T060100;INSERT;{\"Vessel\":\"African Seto\",\"Country (origin)\":\"United States\",\"Zone Origin\":\"Portland (Oregon)\",\"Installation origin\":\"KM Portland Bulk T4\",\"End (origin)\":\"2020-10-31 05:21\",\"Country (destination)\":\"United Kingdom\",\"Zone Destination\":\"Portland UK\",\"Installation Destination\":\"Fortuneswell\",\"Family\":\"dry bulk\",\"Origin PortCall Id\":\"3639615\",\"Destination PortCall Id\":\"3588899\",\"Id (Voyage)\":\"1091395\",\"Zone Origin Id\":\"1626\",\"Zone Destination Id\":\"2018\",\"Installation origin id\":\"7936\",\"Installation Destination Id\":\"766\",\"Continent Destination\":\"Europe\",\"Continent Origin\":\"Americas\",\"Date (origin)\":\"2020-10-31 05:21\",\"Origin\":\"KM Portland Bulk T4\",\"Reload STS Partial (origin)\":\"Partial\",\"Date (destination)\":\"2020-11-14 20:38\",\"Destination\":\"Fortuneswell\",\"Trade status\":\"In Transit\",\"Subcontinent (origin)\":\"Northern America\",\"Start (origin)\":\"2020-10-31 01:45\",\"Eta source (destination)\":\"AIS\",\"Subcontinent (destination)\":\"Northern Europe\",\"Eta (destination)\":\"2020-11-14 20:00\",\"Capacity (vessel m3)\":\"60101\",\"Vessel type\":\"Ultramax\",\"Id (vessel)\":\"91703\",\"IMO (vessel)\":\"9614983\",\"MMSI (vessel)\":\"373494000\",\"Cargo (tons)\":\"25832\"}\n1854;1807531;2020-10-30T060100;UPDATE;{\"Start (destination)\":\"2020-10-30 05:34\",\"Mileage\":\"3186\",\"Ton Miles\":\"134912128\",\"Date (destination)\":\"2020-10-30 05:34\",\"Reload STS Partial (destination)\":\"Partial\",\"Trade status\":\"Delivered\",\"Cargo (tons)\":\"42342\"}\n1334;1840981;2020-11-01T150100;UPDATE;{\"Date (destination)\":\"2020-11-02 10:38\",\"Eta (destination)\":\"2020-11-02 02:00\"}\n1414;1809809;2020-11-02T070100;INSERT;{\"Vessel\":\"Yuan Shi Hai\",\"Country (origin)\":\"China\",\"Zone Origin\":\"Zhoushan\",\"End (origin)\":\"2020-08-16 09:18\",\"Family\":\"dry bulk\",\"Origin PortCall Id\":\"3497326\",\"Id (Voyage)\":\"1056811\",\"Zone Origin Id\":\"5892\",\"Continent Origin\":\"Asia\",\"Date (origin)\":\"2020-08-16 09:18\",\"Origin\":\"Zhoushan\",\"Reload STS Partial (origin)\":\"Partial\",\"Trade status\":\"In Transit\",\"Seller (origin)\":\"China National Energy Investment Group\",\"Intermediaries\":\"0\",\"Subcontinent (origin)\":\"Eastern Asia\",\"Start (origin)\":\"2020-08-16 06:48\",\"Capacity (vessel m3)\":\"391686\",\"Vessel type\":\"Valemax\",\"Id (vessel)\":\"87218\",\"IMO (vessel)\":\"9532575\",\"MMSI (vessel)\":\"566863000\",\"Link1 type\":\"Spot\",\"Link1 seller name\":\"China National Energy Investment Group\",\"Cargo (tons)\":\"53960\"}\n1838;1849242;2020-11-01T190100;INSERT;{\"Vessel\":\"Redmer Oldendorff\",\"Country (origin)\":\"United States\",\"Zone Origin\":\"Norfolk\",\"Installation origin\":\"Lamberts Point\",\"Family\":\"major bulks\",\"Group\":\"coal\",\"Product\":\"metallurgical\",\"Origin PortCall Id\":\"3640472\",\"Id (Voyage)\":\"1096464\",\"Zone Origin Id\":\"1840\",\"Installation origin id\":\"214\",\"Continent Origin\":\"Americas\",\"Date (origin)\":\"2020-11-02 00:00\",\"Origin\":\"Lamberts Point\",\"Reload STS Partial (origin)\":\"Partial\",\"Trade status\":\"Loading\",\"Subcontinent (origin)\":\"Northern America\",\"Start (origin)\":\"2020-10-31 11:44\",\"Capacity (vessel m3)\":\"115924\",\"Vessel type\":\"Baby Capes\",\"Id (vessel)\":\"83646\",\"IMO (vessel)\":\"9463669\",\"MMSI (vessel)\":\"636092818\",\"Cargo (tons)\":\"57093\"}\n1414;1845178;2020-11-02T030100;DELETE;\n(truncated response)"},{"id":"cc11f347-2fee-4064-ae04-fa7bde608a26","name":"Columns id, name, description and deprecation status","originalRequest":{"method":"GET","header":[],"url":"https://api-dry.kpler.com/v1/trades/updates/columns"},"_postman_previewlanguage":"json","header":null,"cookie":[],"responseTime":null,"body":"{\n \"Columns by default\": [\n {\n \"id\": \"vessel_name\",\n \"shortId\": \"ven\",\n \"columnName\": \"Vessel\",\n \"description\": \"Name of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_country_name\",\n \"shortId\": \"ocn\",\n \"columnName\": \"Country (origin)\",\n \"description\": \"Name of the origin country\",\n \"deprecated\": false\n },\n {\n \"id\": \"zone_origin_name\",\n \"shortId\": \"zon\",\n \"columnName\": \"Zone Origin\",\n \"description\": \"Name of the origin area\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_origin_name\",\n \"shortId\": \"ion\",\n \"columnName\": \"Installation origin\",\n \"description\": \"Name of the origin installation\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_end\",\n \"shortId\": \"oen\",\n \"columnName\": \"End (origin)\",\n \"description\": \"End of the loading process at the origin \",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_country_name\",\n \"shortId\": \"dcn\",\n \"columnName\": \"Country (destination)\",\n \"description\": \"Name of the destination country\",\n \"deprecated\": false\n },\n {\n \"id\": \"zone_destination_name\",\n \"shortId\": \"zdn\",\n \"columnName\": \"Zone Destination\",\n \"description\": \"Name of the destination area\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_destination_name\",\n \"shortId\": \"idn\",\n \"columnName\": \"Installation Destination\",\n \"description\": \"Name of the destination installation\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_start\",\n \"shortId\": \"dsd\",\n \"columnName\": \"Start (destination)\",\n \"description\": \"Start of the discharge process at destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_family\",\n \"shortId\": \"cafam\",\n \"columnName\": \"Family\",\n \"description\": \"Product family\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_group\",\n \"shortId\": \"cagroup\",\n \"columnName\": \"Group\",\n \"description\": \"Product group\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_product\",\n \"shortId\": \"capro\",\n \"columnName\": \"Product\",\n \"description\": \"Product type\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_grade\",\n \"shortId\": \"cagrade\",\n \"columnName\": \"Grade\",\n \"description\": \"Product grade\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_id\",\n \"shortId\": \"tid\",\n \"columnName\": \"Id (Trade)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"port_call_origin_id\",\n \"shortId\": \"pcoid\",\n \"columnName\": \"Origin PortCall Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"port_call_destination_id\",\n \"shortId\": \"pcdid\",\n \"columnName\": \"Destination PortCall Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"voyage_id\",\n \"shortId\": \"voy\",\n \"columnName\": \"Id (Voyage)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"zone_origin_id\",\n \"shortId\": \"zoi\",\n \"columnName\": \"Zone Origin Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"zone_destination_id\",\n \"shortId\": \"zdi\",\n \"columnName\": \"Zone Destination Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_origin_id\",\n \"shortId\": \"ioi\",\n \"columnName\": \"Installation origin id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_destination_id\",\n \"shortId\": \"idi\",\n \"columnName\": \"Installation Destination Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"continent_destination_name\",\n \"shortId\": \"cdn\",\n \"columnName\": \"Continent Destination\",\n \"description\": \"Continent of destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"continent_origin_name\",\n \"shortId\": \"con\",\n \"columnName\": \"Continent Origin\",\n \"description\": \"Continent of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"mileage_nautical_miles\",\n \"shortId\": \"mnm\",\n \"columnName\": \"Mileage\",\n \"description\": \"Distance between origin and destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"ton_miles\",\n \"shortId\": \"tom\",\n \"columnName\": \"Ton Miles\",\n \"description\": \"Ton/mile report\",\n \"deprecated\": false\n },\n {\n \"id\": \"start\",\n \"shortId\": \"str\",\n \"columnName\": \"Date (origin)\",\n \"description\": \"Departure date of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_location_name\",\n \"shortId\": \"oln\",\n \"columnName\": \"Origin\",\n \"description\": \"Origin location of the cargo\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_reload_sts_partial\",\n \"shortId\": \"ota\",\n \"columnName\": \"Reload STS Partial (origin)\",\n \"description\": \"If field contains 'Partial' = Partial has occurred in this port call. Same logic applies for when “Reload” and 'STS' is returned for Re-loads and Ship-to-Ship transfers\",\n \"deprecated\": false\n },\n {\n \"id\": \"end\",\n \"shortId\": \"end\",\n \"columnName\": \"Date (destination)\",\n \"description\": \"Arrival date of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_location_name\",\n \"shortId\": \"dln\",\n \"columnName\": \"Destination\",\n \"description\": \"Destination location of the cargo\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_reload_sts_partial\",\n \"shortId\": \"dta\",\n \"columnName\": \"Reload STS Partial (destination)\",\n \"description\": \"If field contains 'Partial' then Partial has occurred in this port call. Same logic applies for when 'Reload' and 'STS' is returned for Re-loads and Ship-to-Ship transfers.\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_destination_location_name\",\n \"shortId\": \"fdl\",\n \"columnName\": \"Forecasted destination\",\n \"description\": \"Next destination forecasted\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_destination_location_eta\",\n \"shortId\": \"fde\",\n \"columnName\": \"Forecasted ETA\",\n \"description\": \"Next destination ETA forecasted\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_destination_confidence\",\n \"shortId\": \"fdc\",\n \"columnName\": \"Forecasted confidence\",\n \"description\": \"Confidence (in %) of the system forecast\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_origin_location_name\",\n \"shortId\": \"fol\",\n \"columnName\": \"Forecasted origin\",\n \"description\": \"Next origin forecasted\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_origin_eta\",\n \"shortId\": \"foe\",\n \"columnName\": \"Forecasted origin ETA\",\n \"description\": \"Next origin ETA forecasted\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_origin_confidence\",\n \"shortId\": \"foc\",\n \"columnName\": \"Forecasted origin confidence\",\n \"description\": \"Confidence (in %) of the system forecast\",\n \"deprecated\": false\n },\n {\n \"id\": \"status\",\n \"shortId\": \"stt\",\n \"columnName\": \"Trade status\",\n \"description\": \"'Scheduled' = cargo has not been picked up yet. 'In Transit' = cargo is in movement. 'Delivered' = cargo arrived to destination.\",\n \"deprecated\": false\n },\n {\n \"id\": \"initial_seller_name\",\n \"shortId\": \"isn\",\n \"columnName\": \"Seller (origin)\",\n \"description\": \"Company name that sold cargo at the installation of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"final_buyer_name\",\n \"shortId\": \"fbn\",\n \"columnName\": \"Buyer (destination)\",\n \"description\": \"Company name of the buyer at final destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"number_of_intermediaries\",\n \"shortId\": \"noi\",\n \"columnName\": \"Intermediaries\",\n \"description\": \"Number of intermediate players involved in the trade\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_subcontinent_name\",\n \"shortId\": \"osn\",\n \"columnName\": \"Subcontinent (origin)\",\n \"description\": \"Subcontinent of trade origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_eta_date\",\n \"shortId\": \"oed\",\n \"columnName\": \"Eta (origin)\",\n \"description\": \"Estimated time of arrival at origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_start\",\n \"shortId\": \"ost\",\n \"columnName\": \"Start (origin)\",\n \"description\": \"Start date of the trip\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_eta_source\",\n \"shortId\": \"oes\",\n \"columnName\": \"Eta source (origin)\",\n \"description\": \"Source of the Estimated Time of Arrival to the Installation of Origin information (Port, Analyst, etc.)\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_eta_source\",\n \"shortId\": \"des\",\n \"columnName\": \"Eta source (destination)\",\n \"description\": \"Source of the Estimated Time of Arrival to the Installation of Destination information (Port, Analyst, etc.)\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_subcontinent_name\",\n \"shortId\": \"dsn\",\n \"columnName\": \"Subcontinent (destination)\",\n \"description\": \"Subcontinent of trade destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_eta\",\n \"shortId\": \"ded\",\n \"columnName\": \"Eta (destination)\",\n \"description\": \"Estimated time of arrival at destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_end\",\n \"shortId\": \"den\",\n \"columnName\": \"End (destination)\",\n \"description\": \"Departure datetime from the destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_capacity_cubic_meters\",\n \"shortId\": \"vcm\",\n \"columnName\": \"Capacity (vessel m3)\",\n \"description\": \"The maximum capacity of the vessel in cubic meters\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_type\",\n \"shortId\": \"vet\",\n \"columnName\": \"Vessel type\",\n \"description\": \"Type of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_cargo_type\",\n \"shortId\": \"vct\",\n \"columnName\": \"Cargo type (vessel)\",\n \"description\": \"The specific cargo type of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_id\",\n \"shortId\": \"vid\",\n \"columnName\": \"Id (vessel)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_imo\",\n \"shortId\": \"imo\",\n \"columnName\": \"IMO (vessel)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_mmsi\",\n \"shortId\": \"msi\",\n \"columnName\": \"MMSI (vessel)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"charterer_name\",\n \"shortId\": \"chn\",\n \"columnName\": \"Charterer\",\n \"description\": \"Current Controller of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"zone_canal_transit\",\n \"shortId\": \"zct\",\n \"columnName\": \"Zone Canal Transit\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_delivery\",\n \"shortId\": \"t1d\",\n \"columnName\": \"Link1 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_type\",\n \"shortId\": \"t1t\",\n \"columnName\": \"Link1 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_seller_name\",\n \"shortId\": \"s1n\",\n \"columnName\": \"Link1 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_seller_country_name\",\n \"shortId\": \"s1c\",\n \"columnName\": \"Link1 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_buyer_name\",\n \"shortId\": \"n1b\",\n \"columnName\": \"Link1 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_buyer_country_name\",\n \"shortId\": \"b1c\",\n \"columnName\": \"Link1 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_delivery\",\n \"shortId\": \"t2d\",\n \"columnName\": \"Link2 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_type\",\n \"shortId\": \"t2t\",\n \"columnName\": \"Link2 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_seller_name\",\n \"shortId\": \"s2n\",\n \"columnName\": \"Link2 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_seller_country_name\",\n \"shortId\": \"s2c\",\n \"columnName\": \"Link2 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_buyer_name\",\n \"shortId\": \"n2b\",\n \"columnName\": \"Link2 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_buyer_country_name\",\n \"shortId\": \"b2c\",\n \"columnName\": \"Link2 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_delivery\",\n \"shortId\": \"t3d\",\n \"columnName\": \"Link3 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_type\",\n \"shortId\": \"t3t\",\n \"columnName\": \"Link3 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_seller_name\",\n \"shortId\": \"s3n\",\n \"columnName\": \"Link3 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_seller_country_name\",\n \"shortId\": \"s3c\",\n \"columnName\": \"Link3 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_buyer_name\",\n \"shortId\": \"n3b\",\n \"columnName\": \"Link3 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_buyer_country_name\",\n \"shortId\": \"b3c\",\n \"columnName\": \"Link3 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_delivery\",\n \"shortId\": \"t4d\",\n \"columnName\": \"Link4 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_type\",\n \"shortId\": \"t4t\",\n \"columnName\": \"Link4 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_seller_name\",\n \"shortId\": \"s4n\",\n \"columnName\": \"Link4 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_seller_country_name\",\n \"shortId\": \"s4c\",\n \"columnName\": \"Link4 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_buyer_name\",\n \"shortId\": \"n4b\",\n \"columnName\": \"Link4 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_buyer_country_name\",\n \"shortId\": \"b4c\",\n \"columnName\": \"Link4 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_delivery\",\n \"shortId\": \"t5d\",\n \"columnName\": \"Link5 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_type\",\n \"shortId\": \"t5t\",\n \"columnName\": \"Link5 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_seller_name\",\n \"shortId\": \"s5n\",\n \"columnName\": \"Link5 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_seller_country_name\",\n \"shortId\": \"s5c\",\n \"columnName\": \"Link5 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_buyer_name\",\n \"shortId\": \"n5b\",\n \"columnName\": \"Link5 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_buyer_country_name\",\n \"shortId\": \"b5c\",\n \"columnName\": \"Link5 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"cargo_origin_tons_split_by_product\",\n \"shortId\": \"cotsp\",\n \"columnName\": \"Cargo (tons)\",\n \"description\": \"Quantity (tons) loaded/discharged at the terminal\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_grade_api\",\n \"shortId\": \"cagradeapi\",\n \"columnName\": \"Grade API\",\n \"description\": \"API grade of the product\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_grade_sulfur\",\n \"shortId\": \"cagradesulfur\",\n \"columnName\": \"Grade Sulfur\",\n \"description\": \"Sulfur grade of the product\",\n \"deprecated\": false\n }\n ],\n \"Optional Columns\": [\n {\n \"id\": \"product_id\",\n \"shortId\": \"proid\",\n \"columnName\": \"Id (Product)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_dwt_1\",\n \"shortId\": \"dwt1\",\n \"columnName\": \"Vessel DWT\",\n \"description\": null,\n \"deprecated\": false\n }\n ]\n}"}],"_postman_id":"3b1fafbb-97ee-4c28-be0f-f6f8ba689f15"}],"id":"f9bc6f60-afdc-42a9-9887-3784df352018","description":"

The Trades query returns the volumes from one point of interest to another (installation/zone) on a cargo-by-cargo basis.

In order to select specific columns to display, please use the column ids explicited in the example called Columns id, name, description and deprecation status.

Note: The intra-country trades are activated by default if the parameter 'withIntraCountry' is not populated.

\n","event":[{"listen":"prerequest","script":{"id":"405652fc-0d90-4e48-aed6-2279fafcfa4d","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"2e196f57-912c-4b42-810c-22a119522e37","type":"text/javascript","exec":[""]}}],"_postman_id":"f9bc6f60-afdc-42a9-9887-3784df352018"},{"name":"Vessels","item":[{"name":"/v1/vessels","event":[{"listen":"test","script":{"id":"e139e277-20d5-4e9a-898a-98365e81b00d","exec":[""],"type":"text/javascript"}},{"listen":"prerequest","script":{"id":"6685f7ad-53d1-4082-9d9b-4abcb30fe489","exec":[""],"type":"text/javascript"}}],"id":"72148323-662c-4822-8ce9-f9a2411d5cd9","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"description":"

Required [String] : Token

\n","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":"https://api-dry.kpler.com/v1/vessels?columns={{columns}}&hash={{hash}}","description":"

We provide two parameters to retrieve vessels. You must use one of them or you will get an error:

columns: manually pass each column name you are interested in or use \"all\" to retrieve all available columns.
hash: use a hash that will return the columns you have already chosen. How do I create a hash?

\n","urlObject":{"protocol":"https","path":["v1","vessels"],"host":["api-dry","kpler","com"],"query":[{"description":{"content":"

Retrieve all available columns when set to \"all\"

Note: Please see note above for details

\n","type":"text/plain"},"key":"columns","value":"{{columns}}"},{"description":{"content":"

Generate your favorite set of columns using the hash ( Look at the next endpoint to learn more about how to generate the hash code )

Note: Please see note above for details

\n","type":"text/plain"},"key":"hash","value":"{{hash}}"}],"variable":[]}},"response":[{"id":"7c48d0ef-0f14-488d-b296-74eb12a10265","name":"Columns id, name, description and deprecation status","originalRequest":{"method":"GET","header":[],"url":"this_url_is_not_valid"},"_postman_previewlanguage":"json","header":null,"cookie":[],"responseTime":null,"body":"{\n \"Columns by default\": [\n {\n \"id\": \"vessel_name\",\n \"shortId\": \"vna\",\n \"columnName\": \"Name\",\n \"description\": \"Name of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_status\",\n \"shortId\": \"sta\",\n \"columnName\": \"Status\",\n \"description\": \"Status of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"last_port_call_location_name\",\n \"shortId\": \"lln\",\n \"columnName\": \"Last port-call\",\n \"description\": \"Vessel’s last port call location\",\n \"deprecated\": false\n },\n {\n \"id\": \"last_port_call_end\",\n \"shortId\": \"lpe\",\n \"columnName\": \"Departure date\",\n \"description\": \"End of the last port call\",\n \"deprecated\": false\n },\n {\n \"id\": \"cargo_on_board_tons\",\n \"shortId\": \"cbt\",\n \"columnName\": \"Mass (tons)\",\n \"description\": \"Weight of the cargo on board in tons\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_destination_zone_name\",\n \"shortId\": \"nzn\",\n \"columnName\": \"Destination\",\n \"description\": \"Next destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"last_raw_destination\",\n \"shortId\": \"lrd\",\n \"columnName\": \"Last signal received\",\n \"description\": \"Last signal received by Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"next destination eta\",\n \"shortId\": \"eta\",\n \"columnName\": \"ETA\",\n \"description\": \"Estimated date and time of arrival at next destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_destination_source\",\n \"shortId\": \"nds\",\n \"columnName\": \"Destination source\",\n \"description\": \"Source of the destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_destination_location_name\",\n \"shortId\": \"fln\",\n \"columnName\": \"Forecasted destination\",\n \"description\": \"Next forecasted destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_eta\",\n \"shortId\": \"fet\",\n \"columnName\": \"Forecasted ETA\",\n \"description\": \"Forecasted estimated date and time of arrival at next forecasted destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecast_confidence\",\n \"shortId\": \"fco\",\n \"columnName\": \"Forecast confidence\",\n \"description\": \"Confidence (in %) of the system forecast\",\n \"deprecated\": false\n },\n {\n \"id\": \"is_floating_storage\",\n \"shortId\": \"iff\",\n \"columnName\": \"Floating storage\",\n \"description\": \"'TRUE' if the vessel is considered as floating storage\",\n \"deprecated\": false\n },\n {\n \"id\": \"last_speed_kn\",\n \"shortId\": \"skn\",\n \"columnName\": \"Last speed (kn)\",\n \"description\": \"Last speed received by Kpler (kn)\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_availability_status\",\n \"shortId\": \"ast\",\n \"columnName\": \"Availability\",\n \"description\": \"Availability status\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_availability_open\",\n \"shortId\": \"vao\",\n \"columnName\": \"Open from\",\n \"description\": \"Start date of vessel’s availability\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_availibility_until\",\n \"shortId\": \"vau\",\n \"columnName\": \"Open until\",\n \"description\": \"End date of vessel’s availability\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_availibility_delivery\",\n \"shortId\": \"vad\",\n \"columnName\": \"Delivery\",\n \"description\": \"Delivery location\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_availibility_redelivery\",\n \"shortId\": \"var\",\n \"columnName\": \"Redelivery\",\n \"description\": \"Redelivery location\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_imo\",\n \"shortId\": \"imo\",\n \"columnName\": \"IMO\",\n \"description\": \"Vessel IMO\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_mmsi\",\n \"shortId\": \"mms\",\n \"columnName\": \"MMSI\",\n \"description\": \"The Maritime Mobile Service Identity of the vessel (9 digits)\",\n \"deprecated\": false\n },\n {\n \"id\": \"current_vessel_controller_name\",\n \"shortId\": \"vcn\",\n \"columnName\": \"Current controller\",\n \"description\": \"Name of the current vessel controller\",\n \"deprecated\": false\n },\n {\n \"id\": \"Owners_names\",\n \"shortId\": \"Own\",\n \"columnName\": \"Owners\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"Operators_names\",\n \"shortId\": \"Opn\",\n \"columnName\": \"Operators\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"Builders_names\",\n \"shortId\": \"Bun\",\n \"columnName\": \"Builders\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_build_year\",\n \"shortId\": \"vby\",\n \"columnName\": \"Build year\",\n \"description\": \"Year of construction of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_type\",\n \"shortId\": \"vty\",\n \"columnName\": \"Vessel type\",\n \"description\": \"Type of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_capacity_cubic_meters\",\n \"shortId\": \"vcm\",\n \"columnName\": \"Capacity (m3)\",\n \"description\": \"The maximum capacity of the vessel in cubic meters\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_flag_name\",\n \"shortId\": \"vfn\",\n \"columnName\": \"Flag name\",\n \"description\": \"Country flag\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_dead_weight\",\n \"shortId\": \"vdw\",\n \"columnName\": \"Dead weight (t)\",\n \"description\": \"Dead weight in tons\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_id\",\n \"shortId\": \"vid\",\n \"columnName\": \"Vessel id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"last_port_call_id\",\n \"shortId\": \"lpi\",\n \"columnName\": \"Last port-call id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_port_call_id\",\n \"shortId\": \"fid\",\n \"columnName\": \"Forecasted Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_availability_id\",\n \"shortId\": \"asi\",\n \"columnName\": \"Availability id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"Owners_ids\",\n \"shortId\": \"Owi\",\n \"columnName\": \"Owners_id\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"Operators_ids\",\n \"shortId\": \"Opi\",\n \"columnName\": \"Operators_id\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"Builders_ids\",\n \"shortId\": \"Bui\",\n \"columnName\": \"Builders_id\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"loaded_days_in_2017\",\n \"shortId\": \"17\",\n \"columnName\": \"loaded days in 2017\",\n \"description\": \"Number of days in 2017 when a vessel was carrying at last a partial cargo\",\n \"deprecated\": false\n },\n {\n \"id\": \"loaded_days_in_2018\",\n \"shortId\": \"18\",\n \"columnName\": \"loaded days in 2018\",\n \"description\": \"Number of days in 2018 when a vessel was carrying at last a partial cargo\",\n \"deprecated\": false\n }\n ],\n \"Optional Columns\": [\n {\n \"id\": \"odc\",\n \"shortId\": \"odc\",\n \"columnName\": \"Capacity\",\n \"description\": \"Maximum capacity of the vessel in cubic meters\",\n \"deprecated\": true\n },\n {\n \"id\": \"vessel_cargo_system\",\n \"shortId\": \"vcs\",\n \"columnName\": \"Cargo system\",\n \"description\": \"The specified containment system of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_cargo_type\",\n \"shortId\": \"cgo\",\n \"columnName\": \"Cargo type\",\n \"description\": \"The specific cargo type of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_carrier_type\",\n \"shortId\": \"cer\",\n \"columnName\": \"Carrier type\",\n \"description\": \"Ocean/Coastal\",\n \"deprecated\": false\n },\n {\n \"id\": \"odw\",\n \"shortId\": \"odw\",\n \"columnName\": \"Dead weight\",\n \"description\": \"Dead weight in tons\",\n \"deprecated\": true\n },\n {\n \"id\": \"vessel_engine_type\",\n \"shortId\": \"vet\",\n \"columnName\": \"Engine type\",\n \"description\": \"Engine type\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_gross_tonnage\",\n \"shortId\": \"vgt\",\n \"columnName\": \"Gross tonnage\",\n \"description\": \"Vessel gross tonnage\",\n \"deprecated\": false\n },\n {\n \"id\": \"ols\",\n \"shortId\": \"ols\",\n \"columnName\": \"Last speed\",\n \"description\": \"The last speed of the vessel in nautical miles\",\n \"deprecated\": true\n },\n {\n \"id\": \"loaded_days_in_2016\",\n \"shortId\": \"16\",\n \"columnName\": \"loaded days in 2016\",\n \"description\": \"Number of days in 2016 when a vessel was carrying at last a partial cargo\",\n \"deprecated\": false\n },\n {\n \"id\": \"loaded_days_in_2019\",\n \"shortId\": \"19\",\n \"columnName\": \"loaded days in 2019\",\n \"description\": \"Number of days in 2019 when a vessel was carrying at last a partial cargo\",\n \"deprecated\": false\n },\n {\n \"id\": \"loaded_days_in_2020\",\n \"shortId\": \"20\",\n \"columnName\": \"loaded days in 2020\",\n \"description\": \"Number of days in 2020 when a vessel was carrying at last a partial cargo\",\n \"deprecated\": false\n }\n ]\n}"},{"id":"87b5bf8d-6408-49a2-ba9f-c1313e649d89","name":"Retrieve columns using hash","originalRequest":{"method":"GET","header":[{"description":"Required [String] : Token","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":{"raw":"https://api-dry.kpler.com/v1/vessels?hash=YOUR_HASH","protocol":"https","host":["api-dry","kpler","com"],"path":["v1","vessels"],"query":[{"key":"hash","value":"YOUR_HASH","description":"Optional [String]: Generate your favorite set of columns using the hash ( Look at the next endpoint to learn more about how to generate the hash code )\n\n**Note:** You cannot use it simultaneously with the ‘columns’ parameter"}]}},"_postman_previewlanguage":"Text","header":null,"cookie":[],"responseTime":null,"body":""},{"id":"f840d4f2-6217-438e-856d-2505108baef6","name":"Get the list of vessels","originalRequest":{"method":"GET","header":[{"key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN","description":"Required [String] : Token"}],"url":{"raw":"https://api-dry.kpler.com/v1/vessels?columns=vessel_id,vessel_name,vessel_imo,vessel_type","protocol":"https","host":["api-dry","kpler","com"],"path":["v1","vessels"],"query":[{"key":"columns","value":"vessel_id,vessel_name,vessel_imo,vessel_type","description":"Optional [String] : Retrieve all available columns when set to \"all\""}]}},"status":"OK","code":200,"_postman_previewlanguage":"Text","header":[],"cookie":[],"responseTime":null,"body":"Vessel id;Name;IMO;Vessel type\n102373;29 Ekim;7530975;Ultramax\n103307;2Car;9122095;Capesize\n103217;3 Maj;8610904;Ultramax\n114150;A Racer;9086318;Handysize\n100225;Aanya;9592446;Capesize\n115248;Aargau;9583897;Handysize\n102929;Aarti Prem;9087738;Panamax\n100231;Aashna;9592458;Capesize\n102307;Abant;7364132;Baby Capes\n115730;Abdala;9571040;Handysize\n..."}],"_postman_id":"72148323-662c-4822-8ce9-f9a2411d5cd9"},{"name":"/v1/vessels/columns","event":[{"listen":"test","script":{"id":"e139e277-20d5-4e9a-898a-98365e81b00d","exec":[""],"type":"text/javascript"}},{"listen":"prerequest","script":{"id":"6685f7ad-53d1-4082-9d9b-4abcb30fe489","exec":[""],"type":"text/javascript"}}],"id":"af29ef6e-f75e-41f5-ab55-fa14399953e8","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"bearer","bearer":{"basicConfig":[]},"isInherited":false},"method":"POST","header":[{"description":"

Required [String] : Token

\n","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"},{"key":"Content-Type","value":"application/json","description":"

Required [String]: application/json or text/json

\n","type":"text"}],"body":{"mode":"raw","raw":"[\n \"vessel_name\",\n \"vessel_status\",\n \"next_destination_zone_name\",\n \"last_speed_kn\"\n]"},"url":"https://api-dry.kpler.com/v1/vessels/columns","description":"

To prevent breaking changes, we strongly recommend you to not use the “all” or the default value for the 'column’ parameter as these may occasionally change.

Therefore we have added this endpoint which allows you to get a hash code for the set of columns that you wish to add on your query.

Note: The set of columns defined with the hash code will never change and will always remain the same.

In this example, we have created a hash code that will always return the following columns:

vessel_name
vessel_status
next_destination_zone_name
last_speed_kn

\n","urlObject":{"protocol":"https","path":["v1","vessels","columns"],"host":["api-dry","kpler","com"],"query":[],"variable":[]}},"response":[{"id":"8468fa12-4507-42de-b1af-7ae1606ab707","name":"Create a new hash","originalRequest":{"method":"POST","header":[{"description":"Required [String] : Token","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"},{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"Required [String]: **application/json** or **text/json**","type":"text"}],"body":{"mode":"raw","raw":"[\n \"vessel_name\",\n \"vessel_status\",\n \"next_destination_zone_name\",\n \"last_speed_kn\"\n]","options":{"raw":{"language":"json"}}},"url":"https://api-dry.kpler.com/v1/vessels/columns"},"status":"OK","code":200,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Wed, 20 May 2020 09:15:41 GMT"},{"key":"Content-Type","value":"text/plain; charset=UTF-8"},{"key":"Content-Length","value":"58"},{"key":"Connection","value":"keep-alive"},{"key":"Vary","value":"Accept-Encoding"},{"key":"Content-Encoding","value":"gzip"},{"key":"Access-Control-Allow-Origin","value":"*"}],"cookie":[],"responseTime":null,"body":"a7ff36b815520cfaa8e0cd4cf99ecace"},{"id":"ffaa6533-f858-4faa-8870-83590b55ca5f","name":"Columns id, name, description and deprecation status","originalRequest":{"method":"GET","header":[],"url":"this_url_is_not_valid"},"_postman_previewlanguage":"json","header":null,"cookie":[],"responseTime":null,"body":"{\n \"Columns by default\": [\n {\n \"id\": \"vessel_name\",\n \"shortId\": \"vna\",\n \"columnName\": \"Name\",\n \"description\": \"Name of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_status\",\n \"shortId\": \"sta\",\n \"columnName\": \"Status\",\n \"description\": \"Status of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"last_port_call_location_name\",\n \"shortId\": \"lln\",\n \"columnName\": \"Last port-call\",\n \"description\": \"Vessel’s last port call location\",\n \"deprecated\": false\n },\n {\n \"id\": \"last_port_call_end\",\n \"shortId\": \"lpe\",\n \"columnName\": \"Departure date\",\n \"description\": \"End of the last port call\",\n \"deprecated\": false\n },\n {\n \"id\": \"cargo_on_board_tons\",\n \"shortId\": \"cbt\",\n \"columnName\": \"Mass (tons)\",\n \"description\": \"Weight of the cargo on board in tons\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_destination_zone_name\",\n \"shortId\": \"nzn\",\n \"columnName\": \"Destination\",\n \"description\": \"Next destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"last_raw_destination\",\n \"shortId\": \"lrd\",\n \"columnName\": \"Last signal received\",\n \"description\": \"Last signal received by Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"next destination eta\",\n \"shortId\": \"eta\",\n \"columnName\": \"ETA\",\n \"description\": \"Estimated date and time of arrival at next destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_destination_source\",\n \"shortId\": \"nds\",\n \"columnName\": \"Destination source\",\n \"description\": \"Source of the destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_destination_location_name\",\n \"shortId\": \"fln\",\n \"columnName\": \"Forecasted destination\",\n \"description\": \"Next forecasted destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_eta\",\n \"shortId\": \"fet\",\n \"columnName\": \"Forecasted ETA\",\n \"description\": \"Forecasted estimated date and time of arrival at next forecasted destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecast_confidence\",\n \"shortId\": \"fco\",\n \"columnName\": \"Forecast confidence\",\n \"description\": \"Confidence (in %) of the system forecast\",\n \"deprecated\": false\n },\n {\n \"id\": \"is_floating_storage\",\n \"shortId\": \"iff\",\n \"columnName\": \"Floating storage\",\n \"description\": \"'TRUE' if the vessel is considered as floating storage\",\n \"deprecated\": false\n },\n {\n \"id\": \"last_speed_kn\",\n \"shortId\": \"skn\",\n \"columnName\": \"Last speed (kn)\",\n \"description\": \"Last speed received by Kpler (kn)\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_availability_status\",\n \"shortId\": \"ast\",\n \"columnName\": \"Availability\",\n \"description\": \"Availability status\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_availability_open\",\n \"shortId\": \"vao\",\n \"columnName\": \"Open from\",\n \"description\": \"Start date of vessel’s availability\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_availibility_until\",\n \"shortId\": \"vau\",\n \"columnName\": \"Open until\",\n \"description\": \"End date of vessel’s availability\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_availibility_delivery\",\n \"shortId\": \"vad\",\n \"columnName\": \"Delivery\",\n \"description\": \"Delivery location\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_availibility_redelivery\",\n \"shortId\": \"var\",\n \"columnName\": \"Redelivery\",\n \"description\": \"Redelivery location\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_imo\",\n \"shortId\": \"imo\",\n \"columnName\": \"IMO\",\n \"description\": \"Vessel IMO\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_mmsi\",\n \"shortId\": \"mms\",\n \"columnName\": \"MMSI\",\n \"description\": \"The Maritime Mobile Service Identity of the vessel (9 digits)\",\n \"deprecated\": false\n },\n {\n \"id\": \"current_vessel_controller_name\",\n \"shortId\": \"vcn\",\n \"columnName\": \"Current controller\",\n \"description\": \"Name of the current vessel controller\",\n \"deprecated\": false\n },\n {\n \"id\": \"Owners_names\",\n \"shortId\": \"Own\",\n \"columnName\": \"Owners\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"Operators_names\",\n \"shortId\": \"Opn\",\n \"columnName\": \"Operators\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"Builders_names\",\n \"shortId\": \"Bun\",\n \"columnName\": \"Builders\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_build_year\",\n \"shortId\": \"vby\",\n \"columnName\": \"Build year\",\n \"description\": \"Year of construction of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_type\",\n \"shortId\": \"vty\",\n \"columnName\": \"Vessel type\",\n \"description\": \"Type of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_capacity_cubic_meters\",\n \"shortId\": \"vcm\",\n \"columnName\": \"Capacity (m3)\",\n \"description\": \"The maximum capacity of the vessel in cubic meters\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_flag_name\",\n \"shortId\": \"vfn\",\n \"columnName\": \"Flag name\",\n \"description\": \"Country flag\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_dead_weight\",\n \"shortId\": \"vdw\",\n \"columnName\": \"Dead weight (t)\",\n \"description\": \"Dead weight in tons\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_id\",\n \"shortId\": \"vid\",\n \"columnName\": \"Vessel id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"last_port_call_id\",\n \"shortId\": \"lpi\",\n \"columnName\": \"Last port-call id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_port_call_id\",\n \"shortId\": \"fid\",\n \"columnName\": \"Forecasted Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_availability_id\",\n \"shortId\": \"asi\",\n \"columnName\": \"Availability id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"Owners_ids\",\n \"shortId\": \"Owi\",\n \"columnName\": \"Owners_id\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"Operators_ids\",\n \"shortId\": \"Opi\",\n \"columnName\": \"Operators_id\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"Builders_ids\",\n \"shortId\": \"Bui\",\n \"columnName\": \"Builders_id\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"loaded_days_in_2017\",\n \"shortId\": \"17\",\n \"columnName\": \"loaded days in 2017\",\n \"description\": \"Number of days in 2017 when a vessel was carrying at last a partial cargo\",\n \"deprecated\": false\n },\n {\n \"id\": \"loaded_days_in_2018\",\n \"shortId\": \"18\",\n \"columnName\": \"loaded days in 2018\",\n \"description\": \"Number of days in 2018 when a vessel was carrying at last a partial cargo\",\n \"deprecated\": false\n }\n ],\n \"Optional Columns\": [\n {\n \"id\": \"odc\",\n \"shortId\": \"odc\",\n \"columnName\": \"Capacity\",\n \"description\": \"Maximum capacity of the vessel in cubic meters\",\n \"deprecated\": true\n },\n {\n \"id\": \"vessel_cargo_system\",\n \"shortId\": \"vcs\",\n \"columnName\": \"Cargo system\",\n \"description\": \"The specified containment system of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_cargo_type\",\n \"shortId\": \"cgo\",\n \"columnName\": \"Cargo type\",\n \"description\": \"The specific cargo type of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_carrier_type\",\n \"shortId\": \"cer\",\n \"columnName\": \"Carrier type\",\n \"description\": \"Ocean/Coastal\",\n \"deprecated\": false\n },\n {\n \"id\": \"odw\",\n \"shortId\": \"odw\",\n \"columnName\": \"Dead weight\",\n \"description\": \"Dead weight in tons\",\n \"deprecated\": true\n },\n {\n \"id\": \"vessel_engine_type\",\n \"shortId\": \"vet\",\n \"columnName\": \"Engine type\",\n \"description\": \"Engine type\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_gross_tonnage\",\n \"shortId\": \"vgt\",\n \"columnName\": \"Gross tonnage\",\n \"description\": \"Vessel gross tonnage\",\n \"deprecated\": false\n },\n {\n \"id\": \"ols\",\n \"shortId\": \"ols\",\n \"columnName\": \"Last speed\",\n \"description\": \"The last speed of the vessel in nautical miles\",\n \"deprecated\": true\n },\n {\n \"id\": \"loaded_days_in_2016\",\n \"shortId\": \"16\",\n \"columnName\": \"loaded days in 2016\",\n \"description\": \"Number of days in 2016 when a vessel was carrying at last a partial cargo\",\n \"deprecated\": false\n },\n {\n \"id\": \"loaded_days_in_2019\",\n \"shortId\": \"19\",\n \"columnName\": \"loaded days in 2019\",\n \"description\": \"Number of days in 2019 when a vessel was carrying at last a partial cargo\",\n \"deprecated\": false\n },\n {\n \"id\": \"loaded_days_in_2020\",\n \"shortId\": \"20\",\n \"columnName\": \"loaded days in 2020\",\n \"description\": \"Number of days in 2020 when a vessel was carrying at last a partial cargo\",\n \"deprecated\": false\n }\n ]\n}"}],"_postman_id":"af29ef6e-f75e-41f5-ab55-fa14399953e8"},{"name":"/v1/vessels/columns","event":[{"listen":"test","script":{"id":"c4c8d8ee-9084-462f-a097-b2d4968a7364","exec":[""],"type":"text/javascript"}},{"listen":"prerequest","script":{"id":"e57ffa64-b6c8-43bc-95c2-8bdbaccc4b89","exec":[""],"type":"text/javascript"}}],"id":"d3e6851f-47dc-483a-a7fa-4a0b219fc34d","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"noauth","isInherited":false},"method":"GET","header":[{"description":"

Required [String] : Token

\n","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"},{"description":"

Required [String]: application/json or text/json

\n","key":"Content-Type","type":"text","value":"application/json"}],"url":"https://api-dry.kpler.com/v1/vessels/columns","description":"

This endpoint returns a recent and updated list of all columns available for the endpoint vessels.

\n","urlObject":{"protocol":"https","path":["v1","vessels","columns"],"host":["api-dry","kpler","com"],"query":[],"variable":[]}},"response":[{"id":"6a97fc0e-a266-4133-8da4-474bd887eab7","name":"List of all columns","originalRequest":{"method":"GET","header":[{"description":"Required [String] : Token","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"},{"description":"Required [String]: **application/json** or **text/json**","key":"Content-Type","type":"text","value":"application/json"}],"url":"https://api-dry.kpler.com/v1/vessels/columns"},"_postman_previewlanguage":"json","header":null,"cookie":[],"responseTime":null,"body":"{\n \"selected\": [\n {\n \"id\": \"vessel_name\",\n \"shortId\": \"vna\",\n \"columnName\": \"Name\",\n \"description\": \"Name of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_status\",\n \"shortId\": \"sta\",\n \"columnName\": \"Status\",\n \"description\": \"Status of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"last_port_call_location_name\",\n \"shortId\": \"lln\",\n \"columnName\": \"Last port-call\",\n \"description\": \"Vessel’s last port call location\",\n \"deprecated\": false\n },\n {\n \"id\": \"last_port_call_end\",\n \"shortId\": \"lpe\",\n \"columnName\": \"Departure date\",\n \"description\": \"End of the last port call\",\n \"deprecated\": false\n },\n {\n \"id\": \"cargo_on_board_tons\",\n \"shortId\": \"cbt\",\n \"columnName\": \"Mass (tons)\",\n \"description\": \"Weight of the cargo on board in tons\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_destination_zone_name\",\n \"shortId\": \"nzn\",\n \"columnName\": \"Destination\",\n \"description\": \"Next destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"last_raw_destination\",\n \"shortId\": \"lrd\",\n \"columnName\": \"Last signal received\",\n \"description\": \"Last signal received by Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"next destination eta\",\n \"shortId\": \"eta\",\n \"columnName\": \"ETA\",\n \"description\": \"Estimated date and time of arrival at next destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_destination_source\",\n \"shortId\": \"nds\",\n \"columnName\": \"Destination source\",\n \"description\": \"Source of the destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_destination_location_name\",\n \"shortId\": \"fln\",\n \"columnName\": \"Forecasted destination\",\n \"description\": \"Next forecasted destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_eta\",\n \"shortId\": \"fet\",\n \"columnName\": \"Forecasted ETA\",\n \"description\": \"Forecasted estimated date and time of arrival at next forecasted destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecast_confidence\",\n \"shortId\": \"fco\",\n \"columnName\": \"Forecast confidence\",\n \"description\": \"Confidence (in %) of the system forecast\",\n \"deprecated\": false\n },\n {\n \"id\": \"is_floating_storage\",\n \"shortId\": \"iff\",\n \"columnName\": \"Floating storage\",\n \"description\": \"'TRUE' if the vessel is considered as floating storage\",\n \"deprecated\": false\n },\n {\n \"id\": \"last_speed_kn\",\n \"shortId\": \"skn\",\n \"columnName\": \"Last speed (kn)\",\n \"description\": \"Last speed received by Kpler (kn)\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_availability_status\",\n \"shortId\": \"ast\",\n \"columnName\": \"Availability\",\n \"description\": \"Availability status\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_availability_open\",\n \"shortId\": \"vao\",\n \"columnName\": \"Open from\",\n \"description\": \"Start date of vessel’s availability\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_availibility_until\",\n \"shortId\": \"vau\",\n \"columnName\": \"Open until\",\n \"description\": \"End date of vessel’s availability\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_availibility_delivery\",\n \"shortId\": \"vad\",\n \"columnName\": \"Delivery\",\n \"description\": \"Delivery location\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_availibility_redelivery\",\n \"shortId\": \"var\",\n \"columnName\": \"Redelivery\",\n \"description\": \"Redelivery location\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_imo\",\n \"shortId\": \"imo\",\n \"columnName\": \"IMO\",\n \"description\": \"Vessel IMO\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_mmsi\",\n \"shortId\": \"mms\",\n \"columnName\": \"MMSI\",\n \"description\": \"The Maritime Mobile Service Identity of the vessel (9 digits)\",\n \"deprecated\": false\n },\n {\n \"id\": \"current_vessel_controller_name\",\n \"shortId\": \"vcn\",\n \"columnName\": \"Current controller\",\n \"description\": \"Name of the current vessel controller\",\n \"deprecated\": false\n },\n {\n \"id\": \"Owners_names\",\n \"shortId\": \"Own\",\n \"columnName\": \"Owners\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"Operators_names\",\n \"shortId\": \"Opn\",\n \"columnName\": \"Operators\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"Builders_names\",\n \"shortId\": \"Bun\",\n \"columnName\": \"Builders\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_build_year\",\n \"shortId\": \"vby\",\n \"columnName\": \"Build year\",\n \"description\": \"Year of construction of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_type\",\n \"shortId\": \"vty\",\n \"columnName\": \"Vessel type\",\n \"description\": \"Type of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_capacity_cubic_meters\",\n \"shortId\": \"vcm\",\n \"columnName\": \"Capacity (m3)\",\n \"description\": \"The maximum capacity of the vessel in cubic meters\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_flag_name\",\n \"shortId\": \"vfn\",\n \"columnName\": \"Flag name\",\n \"description\": \"Country flag\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_dead_weight\",\n \"shortId\": \"vdw\",\n \"columnName\": \"Dead weight (t)\",\n \"description\": \"Dead weight in tons\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_id\",\n \"shortId\": \"vid\",\n \"columnName\": \"Vessel id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"last_port_call_id\",\n \"shortId\": \"lpi\",\n \"columnName\": \"Last port-call id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_port_call_id\",\n \"shortId\": \"fid\",\n \"columnName\": \"Forecasted Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_availability_id\",\n \"shortId\": \"asi\",\n \"columnName\": \"Availability id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"Owners_ids\",\n \"shortId\": \"Owi\",\n \"columnName\": \"Owners_id\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"Operators_ids\",\n \"shortId\": \"Opi\",\n \"columnName\": \"Operators_id\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"Builders_ids\",\n \"shortId\": \"Bui\",\n \"columnName\": \"Builders_id\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"loaded_days_in_2017\",\n \"shortId\": \"17\",\n \"columnName\": \"loaded days in 2017\",\n \"description\": \"Number of days in 2017 when a vessel was carrying at last a partial cargo\",\n \"deprecated\": false\n },\n {\n \"id\": \"loaded_days_in_2018\",\n \"shortId\": \"18\",\n \"columnName\": \"loaded days in 2018\",\n \"description\": \"Number of days in 2018 when a vessel was carrying at last a partial cargo\",\n \"deprecated\": false\n }\n ],\n \"unselected\": [\n {\n \"id\": \"odc\",\n \"shortId\": \"odc\",\n \"columnName\": \"Capacity\",\n \"description\": \"Maximum capacity of the vessel in cubic meters\",\n \"deprecated\": true\n },\n {\n \"id\": \"vessel_cargo_system\",\n \"shortId\": \"vcs\",\n \"columnName\": \"Cargo system\",\n \"description\": \"The specified containment system of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_cargo_type\",\n \"shortId\": \"cgo\",\n \"columnName\": \"Cargo type\",\n \"description\": \"The specific cargo type of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_carrier_type\",\n \"shortId\": \"cer\",\n \"columnName\": \"Carrier type\",\n \"description\": \"Ocean/Coastal\",\n \"deprecated\": false\n },\n {\n \"id\": \"odw\",\n \"shortId\": \"odw\",\n \"columnName\": \"Dead weight\",\n \"description\": \"Dead weight in tons\",\n \"deprecated\": true\n },\n {\n \"id\": \"vessel_engine_type\",\n \"shortId\": \"vet\",\n \"columnName\": \"Engine type\",\n \"description\": \"Engine type\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_gross_tonnage\",\n \"shortId\": \"vgt\",\n \"columnName\": \"Gross tonnage\",\n \"description\": \"Vessel gross tonnage\",\n \"deprecated\": false\n },\n {\n \"id\": \"ols\",\n \"shortId\": \"ols\",\n \"columnName\": \"Last speed\",\n \"description\": \"The last speed of the vessel in nautical miles\",\n \"deprecated\": true\n },\n {\n \"id\": \"loaded_days_in_2016\",\n \"shortId\": \"16\",\n \"columnName\": \"loaded days in 2016\",\n \"description\": \"Number of days in 2016 when a vessel was carrying at last a partial cargo\",\n \"deprecated\": false\n },\n {\n \"id\": \"loaded_days_in_2019\",\n \"shortId\": \"19\",\n \"columnName\": \"loaded days in 2019\",\n \"description\": \"Number of days in 2019 when a vessel was carrying at last a partial cargo\",\n \"deprecated\": false\n },\n {\n \"id\": \"loaded_days_in_2020\",\n \"shortId\": \"20\",\n \"columnName\": \"loaded days in 2020\",\n \"description\": \"Number of days in 2020 when a vessel was carrying at last a partial cargo\",\n \"deprecated\": false\n }\n ]\n}"}],"_postman_id":"d3e6851f-47dc-483a-a7fa-4a0b219fc34d"}],"id":"2fcdbbfe-f268-45b2-9c17-251ba30c3a58","description":"

The Vessels query returns a snapshot of the current status of the fleet, including details on vessel status, last port call and next destination.

In order to select specific columns to display, please use the column ids explicited in the example called Columns id, name, description and deprecation status.

\n","event":[{"listen":"prerequest","script":{"id":"fcbc8997-4f1e-46c0-82aa-1d0a12bbaf07","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"3e355b9f-d716-4800-9c8a-cc05e89f9ced","type":"text/javascript","exec":[""]}}],"_postman_id":"2fcdbbfe-f268-45b2-9c17-251ba30c3a58"},{"name":"Flows","item":[{"name":"/v1/flows","event":[{"listen":"test","script":{"id":"e139e277-20d5-4e9a-898a-98365e81b00d","exec":[""],"type":"text/javascript","packages":{}}},{"listen":"prerequest","script":{"id":"8fcb09c7-2f87-4c13-9703-f93d6d9fba49","exec":[""],"type":"text/javascript","packages":{}}}],"id":"18b6a2ca-aa22-438b-95da-0fae8bad5dd1","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"key":"Authorization","value":"Bearer YOUR_TOKEN","description":"

Required [String] : Token

\n","type":"text"}],"url":"https://api-dry.kpler.com/v1/flows?flowDirection={{flowDirection}}&split={{split}}&granularity={{granularity}}&startDate={{startDate}}&endDate={{endDate}}&fromInstallations={{fromInstallations}}&toInstallations={{toInstallations}}&fromZones={{fromZones}}&toZones={{toZones}}&products={{products}}&onlyRealized={{onlyRealized}}&unit={{unit}}&vesselTypes={{vesselTypes}}&withIntraCountry={{withIntraCountry}}&withIntraRegion={{withIntraRegion}}&withForecast={{withForecast}}&snapshotDate={{date}}&splitValues={{splitValues}}&withProductEstimation={{withProductEstimation}}","urlObject":{"protocol":"https","path":["v1","flows"],"host":["api-dry","kpler","com"],"query":[{"description":{"content":"

Required [String]: Flow direction [\"Import\", \"Export\", \"NetImport\", \"NetExport\"]

Notes: when used with snapshotDate only \"Export\" is available

\n","type":"text/plain"},"key":"flowDirection","value":"{{flowDirection}}"},{"description":{"content":"

Required [String]: Use following splits: [\"Total\", \" Grades\", \" Products\", \" Origin Countries\", \" Destination Countries\", \" Origin Continents\", \" Destination Continents\", \" Origin Subcontinents\", \" Destination Subcontinents\", \" Origin Trading Regions\", \" Destination Trading Regions\", \" Origin Ports\", \" Destination Ports\", \" Origin Installations\", \" Destination Installations\", \" Vessel Type\", \" Trade Status\", \" Sources\", \" Charterers\", \" Buyer\", \" Seller\", \" Routes\"]

\n","type":"text/plain"},"key":"split","value":"{{split}}"},{"description":{"content":"

Required [String]: Period [\"annually\", \"monthly\", \"weekly\", \"eia-weekly\", \"daily\"]

\n","type":"text/plain"},"key":"granularity","value":"{{granularity}}"},{"description":{"content":"

Optional [Date]: Start of the period (YYYY-MM-DD)

\n","type":"text/plain"},"key":"startDate","value":"{{startDate}}"},{"description":{"content":"

Optional [Date]: End of the period (YYYY-MM-DD)

\n","type":"text/plain"},"key":"endDate","value":"{{endDate}}"},{"description":{"content":"

Optional [String]: Names of installations

\n","type":"text/plain"},"key":"fromInstallations","value":"{{fromInstallations}}"},{"description":{"content":"

Optional [String]: Names of installations

\n","type":"text/plain"},"key":"toInstallations","value":"{{toInstallations}}"},{"description":{"content":"

Optional [String]: Names of zones [\"port\", \"region\", \"country\", \"continent\"]

\n","type":"text/plain"},"key":"fromZones","value":"{{fromZones}}"},{"description":{"content":"

Optional [String]: Names of zones [\"port\", \"region\", \"country\", \"continent\"]

\n","type":"text/plain"},"key":"toZones","value":"{{toZones}}"},{"description":{"content":"

Optional [String]: Names of products

\n","type":"text/plain"},"key":"products","value":"{{products}}"},{"description":{"content":"

Optional [Boolean]: Default to false if not specified. Takes into account only the trades that have been finished. Use [\"true\", \"false\"]

\n","type":"text/plain"},"key":"onlyRealized","value":"{{onlyRealized}}"},{"description":{"content":"

Optional [String]: Use [\"bbl\", \"kb\", \"mmbbl\", \"mt\", \"kt\", \"t\", \"cm\"]. By default value is unit=kb.

\n","type":"text/plain"},"key":"unit","value":"{{unit}}"},{"description":{"content":"

\n","type":"text/plain"},"key":"vesselTypes","value":"{{vesselTypes}}"},{"description":{"content":"

Optional [Boolean]: Default to false if not specified. Takes into account the trades that originate from and are delivered to the same country. Use [\"true\", \"false\"]

\n","type":"text/plain"},"key":"withIntraCountry","value":"{{withIntraCountry}}"},{"description":{"content":"

Optional [Boolean]: Default to true if not specified. Takes into account the trades that originate from and are delivered to a specified region. Use [\"true\", \"false\"]

\n","type":"text/plain"},"key":"withIntraRegion","value":"{{withIntraRegion}}"},{"description":{"content":"

Optional [Boolean]: Default to true. Include trades predicted by our in-house model when set to \"true\". Use [\"true\", \"false\"]

\n","type":"text/plain"},"key":"withForecast","value":"{{withForecast}}"},{"description":{"content":"

Optional [Date]: Format Date : YYYY-MM-DD, if empty it's returning the last snapshot

\n","type":"text/plain"},"key":"snapshotDate","value":"{{date}}"},{"description":{"content":"

Optional [String]: Fix the values and the order of the split

\n","type":"text/plain"},"key":"splitValues","value":"{{splitValues}}"},{"description":{"content":"

\n","type":"text/plain"},"key":"withProductEstimation","value":"{{withProductEstimation}}"}],"variable":[]}},"response":[{"id":"8807120f-c870-4990-80d7-375ffd98d83b","name":" The annually Indian flows (imports) since 2019, with the volumes being split by the installation destination","originalRequest":{"method":"GET","header":[{"description":"Required [String] : Token","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":{"raw":"https://api-dry.kpler.com/v1/flows?flowDirection=import&split=destination installations&granularity=annually&startDate=2019-01-01&toZones=India","protocol":"https","host":["api-dry","kpler","com"],"path":["v1","flows"],"query":[{"key":"flowDirection","value":"import","description":"Required [String] : Flow direction [\"Import\", \"Export\", \"NetImport\", \"NetExport\"]"},{"key":"split","value":"destination installations","description":"Required [String] : Only Realized [\"Total\", \"Grades\", \"Products\", \"Origin Countries\", \"Destination Countries\", \"Origin Installations\", \"Destination Installations\", \"Vessel Type\", \"Trade Status\", \"Sources\", \"Charterers\", \"Routes\"]"},{"key":"granularity","value":"annually","description":"Required [String] : Period [\"annually, monthly, weekly, eia-weekly, daily\"]"},{"key":"startDate","value":"2019-01-01","description":"Optional [Date] : Start of the period (YYYY-MM-DD)"},{"key":"toZones","value":"India","description":"Optional [String] : Names of zones [\"port\", \"region\", \"country\", \"continent\"]"}]}},"status":"OK","code":200,"_postman_previewlanguage":"Text","header":[],"cookie":[],"responseTime":null,"body":";Bet Dwaraka;Hazira;Paradip Essar Iron Ore;Vizag West Quay Multiport;Krishnapatnam MPT;Adani Mormugao;Kakinada;Mangalore MPT;Hazira MPT;Navlakhi;Jakhau;Revdanda;Vizag Nalco;Vizag Seaport;Ennore;Pipapav;Krishnapatnam;Jaigarh;Dhamra;VGCB;Pipapav Cement;VPT Dry Bulk;Paradip Fertiliser;Kandla;Mormugao Iron Ore;VPT Coal & Bulk;Mundra;Tuticorin Break Bulk;Paradip MCHP;Muldwarka;Haldia;Tuna;unknown;Dharamtar Port;Dahej (Adani);Salaya Essar;JSW Mormugao Steel;Paradip MPT;Adani Vizag;Tuticorin MPT;Porbandar;Lakvijaya;Karaikal;Dahej (DHIJ);Tuticorin Coal;Gangavaram;Mangalore Iron Ore;Kakinada Aluminium\n2019;1770.72;31777.39;5144.13;157.46;11644.4;12158.04;14353.03;21832.63;23128.24;23966.69;2555.05;6212.98;236.17;26900.55;45456.81;4199.12;86071.41;43908.79;60080.41;22298.87;3450.21;4289.92;140.34;53628.77;16874.77;13655.57;165915.18;449.05;1305.09;1586.1;29212.47;18939.54;110071.53;333.09;20373.47;20532.47;13048.1;85904.5;8263.8;23653.15;1185.9;7336.34;21760.02;2504.58;8088.95;110401.51;25.81;841.72"}],"_postman_id":"18b6a2ca-aa22-438b-95da-0fae8bad5dd1"}],"id":"3df7bdcb-fadf-4baa-b490-cd8aa735a8d2","description":"

The Flows query returns the aggregated flows for a point of interest (installation/zone) on a daily, weekly, weekly EIA (for US), monthly and yearly basis.

\n","event":[{"listen":"prerequest","script":{"id":"2fb2d1da-fd26-48a3-89ac-8de4fb986711","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"a694eecf-4c60-4325-bc48-6e9a4f7cbb33","type":"text/javascript","exec":[""]}}],"_postman_id":"3df7bdcb-fadf-4baa-b490-cd8aa735a8d2"},{"name":"Port-calls","item":[{"name":"/v1/port-calls","event":[{"listen":"test","script":{"id":"62f08e8b-1b3c-47c8-8a67-df95a856cc37","exec":[""],"type":"text/javascript"}},{"listen":"prerequest","script":{"id":"26e1f6d4-f537-4d2b-9bf0-f5363d703540","exec":[""],"type":"text/javascript"}}],"id":"7236ddc9-660a-4296-ab26-d56b904cefa5","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"description":"

Required [String] : Token

\n","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":"https://api-dry.kpler.com/v1/port-calls?size={{size}}&vessels={{vessels}}&installations={{installations}}&zones={{zones}}&products={{products}}&startDate={{startDate}}&endDate={{endDate}}&withForecast={{withForecast}}&columns={{columns}}&hash={{hash}}&withEmptyVolume={{withEmptyVolume}}","urlObject":{"protocol":"https","path":["v1","port-calls"],"host":["api-dry","kpler","com"],"query":[{"description":{"content":"

Optional [Integer]: Maximum number of portcalls returned

\n","type":"text/plain"},"key":"size","value":"{{size}}"},{"description":{"content":"

Optional [String]: Names/IMOs of vessels

\n","type":"text/plain"},"key":"vessels","value":"{{vessels}}"},{"description":{"content":"

Optional [String]: Names of installations

\n","type":"text/plain"},"key":"installations","value":"{{installations}}"},{"description":{"content":"

Optional [String]: Names of zones [\"port\", \"region\", \"country\", \"continent\"]

\n","type":"text/plain"},"key":"zones","value":"{{zones}}"},{"description":{"content":"