![\"Alt](\"https://kp-prod-public-content.s3-eu-west-1.amazonaws.com/doc/available-columns.gif\")
\n\nThere are two ways to get access to the data:
\n- \n
Basic Authentication
\n \n
You are able to use our API by using Basic Authentication. It is not necessary to use login endpoint to do this.
\nFollow these steps to use Basic Authentication :
\n- \n
Encode your email and password in base64
\nyour_email@example.com:your_password = Y3VzdG9tZXJAZW1haWwuY29tOm1Zc3RSb25nUDRzc3cwUmQ=\n\n\nAdd your encoded credentials in the 'Authorization' header.
\nAuthorization: Basic Y3VzdG9tZXJAZW1haWwuY29tOm1Zc3RSb25nUDRzc3cwUmQ=\n\n\n
How can I encode in base64 ?
\nIn python3
\nimport base64\ntoken = base64.b64encode(str.encode(f'your_email:your_password')).decode('ascii')\n\nIn jQuery
\nlet encodedData = btoa(\"YOUR_EMAIL:YOUR_PASSWORD\");\n/* Output */ \nencodedData = WU9VUl9FTUFJTDpZT1VSX1BBU1NXT1JE\n\nIn Node.js
\nlet data = 'YOUR_EMAIL:YOUR_PASSWORD';\nlet buffer = Buffer.from(data);\nlet encodedData = buffer.toString('base64');\n/* Output */ \nencodedData = WU9VUl9FTUFJTDpZT1VSX1BBU1NXT1JE\n\nFor Windows Users:
\nRunning this command in your command prompt to convert the string [YOUR_USERNAME]:[YOUR_PASSWORD] to a base64-encrypted string.
\n- \n
Press Windows key + R
\n \nEnter cmd to open the command prompt
\n \nCopy-paste the command below (changing the username/password) and run it
\npowershell \"[convert]::ToBase64String([Text.Encoding]::UTF8.GetBytes(\\\"YOUR_USERNAME:YOUR_PASSWORD\\\"))\"\n\n\n
If you have any problems with this section, please do not hesitate to contact us.
\n\n
- \n
Bearer Token
\n \n
We provide you with a second authentication method to access our data. This method is the most used in the examples in the documentation, but you can choose the method you prefer.
\nTo do so, you have to use the endpoint /login that will allow you to generate the Bearer Token to request our API's.
\n","event":[{"listen":"prerequest","script":{"type":"text/javascript","exec":[""],"id":"1846a324-ba45-41b7-b88e-85456244192c"}},{"listen":"test","script":{"type":"text/javascript","exec":[""],"id":"53b98d05-eb68-4c96-bdc3-45c380f7e7fc"}}],"_postman_id":"2c5121ff-ed3f-43c8-b489-c6b4f166ad88","auth":{"type":"oauth2","oauth2":{"basicConfig":[],"advancedConfig":[{"key":"authRequestParams","value":"Required [String] : Token
\n","type":"text"}],"url":"https://api-lng.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}}","auth":{"type":"oauth2","oauth2":{"basicConfig":[],"advancedConfig":[{"key":"authRequestParams","value":"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 LNG vessel types\n
\nUse [\"XL (Upper Conventional)\", \"L (Lower Conventional)\", \"Q-Flex\", \"XS (Pressure Gas)\", \"M (Med Max)\", \"S (Small Scale)\", \"Q-Max\"]\n
\nNote: Values are case sensitive
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 )
\nNote: You cannot use it simultaneously with the ‘columns’ parameter
\n","type":"text/plain"},"key":"hash","value":"{{hash}}"}],"variable":[]}},"response":[{"id":"82921889-45d7-4116-b68e-e476f8fda888","name":"All cargoes 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-lng.kpler.com/v1/trades?fromZones=Europe&toZones=Asia&columns=trade_id,vessel_name,start,end","protocol":"https","host":["api-lng","kpler","com"],"path":["v1","trades"],"query":[{"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)"},{"key":"columns","value":"trade_id,vessel_name,start,end","description":"Optional [String] : Retrieve all available columns when set to \"all\""}]}},"status":"OK","code":200,"_postman_previewlanguage":"Text","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\n192027;Gaslog Hong Kong;2019-07-11 08:29;2019-08-07 02:15\n187145;Eduard Toll;2019-07-07 04:27;2019-07-25 07:00\n192930;Nikolay Yevgenov;2019-07-03 22:50;2019-08-05 05:09\n194464;Nikolay Zubov;2019-07-02 21:20;2019-08-09 03:32\n192483;Vladimir Rusanov;2019-06-29 13:53;2019-07-25 02:39\n..."},{"id":"9f48b3d0-c56b-4739-aec3-1fcceb2e7507","name":"Columns id, name, description and deprecation status","originalRequest":{"method":"GET","header":[],"url":"this_url_is_not_valid"},"_postman_previewlanguage":"json","header":[],"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\": \"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\": \"cargo_origin_cubic_meters\",\n \"shortId\": \"com\",\n \"columnName\": \"Volume (origin m3)\",\n \"description\": null,\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\": \"cargo_destination_cubic_meters\",\n \"shortId\": \"cdm\",\n \"columnName\": \"Volume (destination m3)\",\n \"description\": null,\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\": \"export_price\",\n \"shortId\": \"epr\",\n \"columnName\": \"Export price\",\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_price\",\n \"shortId\": \"ipr\",\n \"columnName\": \"Import price\",\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\": \"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\": \"lvc\",\n \"shortId\": \"lvc\",\n \"columnName\": \"Capacity (vessel)\",\n \"description\": \"The maximum capacity of the vessel in cubic meters\",\n \"deprecated\": true\n },\n {\n \"id\": \"vessel_delivery_date\",\n \"shortId\": \"vdd\",\n \"columnName\": \"Delivery date (vessel)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_cargo_system\",\n \"shortId\": \"vcs\",\n \"columnName\": \"Cargo system (vessel)\",\n \"description\": null,\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_power_plant\",\n \"shortId\": \"vpp\",\n \"columnName\": \"Power plant type (vessel)\",\n \"description\": null,\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_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\": \"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\": \"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\": \"cargo_destination_tons\",\n \"shortId\": \"cdt\",\n \"columnName\": \"Cargo (destination tons)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"cargo_origin_tons2\",\n \"shortId\": \"cot2\",\n \"columnName\": \"Cargo (origin tons)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"cargo_origin_tons\",\n \"shortId\": \"cot\",\n \"columnName\": \"Cargo (tons)\",\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\": \"forecast_confidence_destination_2\",\n \"shortId\": \"fcd2\",\n \"columnName\": \"Forecast Confidence Destination 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"forecast_confidence_destination_3\",\n \"shortId\": \"fcd3\",\n \"columnName\": \"Forecast Confidence Destination 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"forecast_confidence_origin_2\",\n \"shortId\": \"fco2\",\n \"columnName\": \"Forecast Confidence Origin 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"forecast_confidence_origin_3\",\n \"shortId\": \"fco3\",\n \"columnName\": \"Forecast Confidence Origin 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"forecast_eta_destination_2\",\n \"shortId\": \"fed2\",\n \"columnName\": \"Forecast ETA Destination 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"forecast_eta_destination_3\",\n \"shortId\": \"fed3\",\n \"columnName\": \"Forecast ETA Destination 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"forecast_eta_origin_2\",\n \"shortId\": \"feo2\",\n \"columnName\": \"Forecast ETA Origin 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"forecast_eta_origin_3\",\n \"shortId\": \"feo3\",\n \"columnName\": \"Forecast ETA Origin 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"forecast_zone_destination_2\",\n \"shortId\": \"fzd2\",\n \"columnName\": \"Forecast Zone Destination 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"forecast_zone_destination_3\",\n \"shortId\": \"fzd3\",\n \"columnName\": \"Forecast Zone Destination 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"forecast_zone_origin_2\",\n \"shortId\": \"fzo2\",\n \"columnName\": \"Forecast Zone Origin 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"forecast_zone_origin_3\",\n \"shortId\": \"fzo3\",\n \"columnName\": \"Forecast Zone Origin 3\",\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\": \"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\": \"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\": \"vessel_mmsi\",\n \"shortId\": \"msi\",\n \"columnName\": \"MMSI (vessel)\",\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\": \"vessel_type\",\n \"shortId\": \"vet\",\n \"columnName\": \"Vessel type\",\n \"description\": \"Type of the vessel\",\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}"},{"id":"ecefc6a8-0497-4c75-883d-6db8131a0b81","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-lng.kpler.com/v1/trades?hash=YOUR_HASH","protocol":"https","host":["api-lng","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":[],"cookie":[],"responseTime":null,"body":""}],"_postman_id":"db31769b-c42f-4c4b-9717-04848e65344d"},{"name":"/v1/trades/columns","event":[{"listen":"test","script":{"exec":[""],"type":"text/javascript","id":"f7ed0d81-d6f2-4eb6-bcb8-ec7895af4eb8"}},{"listen":"prerequest","script":{"exec":[""],"type":"text/javascript","id":"252a4025-65b8-40cb-bc37-57da6ec77cdd"}}],"id":"44c4fecf-0370-4576-aa25-4e62618b390f","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":"{{HOST_URL}}/v1/trades/columns","description":"This endpoint returns a recent and updated list of all columns available for the endpoint trades.
\n","urlObject":{"path":["v1","trades","columns"],"host":["{{HOST_URL}}"],"query":[],"variable":[]}},"response":[{"id":"49f98b69-d5b0-4bef-a214-929102068d41","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-lng.kpler.com/v1/trades/columns"},"_postman_previewlanguage":"json","header":[],"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\": \"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_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\": \"cargo_origin_cubic_meters\",\n \"shortId\": \"com\",\n \"columnName\": \"Volume (origin m3)\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"long\"\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_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\": \"cargo_destination_cubic_meters\",\n \"shortId\": \"cdm\",\n \"columnName\": \"Volume (destination m3)\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"double\"\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\": \"next_forecasted_destination_location_name\",\n \"shortId\": \"fdl\",\n \"columnName\": \"Forecasted destination\",\n \"description\": \"Next destination forecasted\",\n \"deprecated\": false,\n \"type\": \"string\"\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 \"type\": \"datetime yyyy-MM-dd HH:mm\"\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 \"type\": \"double\"\n },\n {\n \"id\": \"export_price\",\n \"shortId\": \"epr\",\n \"columnName\": \"Export price\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"double\"\n },\n {\n \"id\": \"export_number_of_trades\",\n \"shortId\": \"ent\",\n \"columnName\": \"Number of trades (export)\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"long\"\n },\n {\n \"id\": \"import_price\",\n \"shortId\": \"ipr\",\n \"columnName\": \"Import price\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"double\"\n },\n {\n \"id\": \"import_number_of_trades\",\n \"shortId\": \"int\",\n \"columnName\": \"Number of trades (import)\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"long\"\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_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\": \"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\": \"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\": \"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_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\": \"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\": \"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\": \"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_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\": \"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\": \"lvc\",\n \"shortId\": \"lvc\",\n \"columnName\": \"Capacity (vessel)\",\n \"description\": \"The maximum capacity of the vessel in cubic meters\",\n \"deprecated\": true,\n \"type\": \"long\"\n },\n {\n \"id\": \"vessel_delivery_date\",\n \"shortId\": \"vdd\",\n \"columnName\": \"Delivery date (vessel)\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"date yyyy-MM-dd\"\n },\n {\n \"id\": \"vessel_cargo_system\",\n \"shortId\": \"vcs\",\n \"columnName\": \"Cargo system (vessel)\",\n \"description\": null,\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_power_plant\",\n \"shortId\": \"vpp\",\n \"columnName\": \"Power plant type (vessel)\",\n \"description\": null,\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\": \"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\": \"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\": \"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\": \"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_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\": \"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_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\": \"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_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\": \"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\": \"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\": \"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 \"unselected\": [\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\": \"cargo_destination_tons\",\n \"shortId\": \"cdt\",\n \"columnName\": \"Cargo (destination tons)\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"long\"\n },\n {\n \"id\": \"cargo_origin_tons2\",\n \"shortId\": \"cot2\",\n \"columnName\": \"Cargo (origin tons)\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"long\"\n },\n {\n \"id\": \"cargo_origin_tons\",\n \"shortId\": \"cot\",\n \"columnName\": \"Cargo (tons)\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"long\"\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\": \"super_trade_country_1\",\n \"shortId\": \"stco1\",\n \"columnName\": \"Country STS 1\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"super_trade_country_2\",\n \"shortId\": \"stco2\",\n \"columnName\": \"Country STS 2\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"super_trade_country_3\",\n \"shortId\": \"stco3\",\n \"columnName\": \"Country STS 3\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"super_trade_end_date1\",\n \"shortId\": \"sted1\",\n \"columnName\": \"Date End STS 1\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"datetime yyyy-MM-dd HH:mm\"\n },\n {\n \"id\": \"super_trade_end_date2\",\n \"shortId\": \"sted2\",\n \"columnName\": \"Date End STS 2\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"datetime yyyy-MM-dd HH:mm\"\n },\n {\n \"id\": \"super_trade_end_date3\",\n \"shortId\": \"sted3\",\n \"columnName\": \"Date End STS 3\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"datetime yyyy-MM-dd HH:mm\"\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 \"type\": \"datetime yyyy-MM-dd HH:mm\"\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 \"type\": \"datetime yyyy-MM-dd HH:mm\"\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 \"type\": \"datetime yyyy-MM-dd HH:mm\"\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\": \"forecast_confidence_destination_2\",\n \"shortId\": \"fcd2\",\n \"columnName\": \"Forecast Confidence Destination 2\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"float\"\n },\n {\n \"id\": \"forecast_confidence_destination_3\",\n \"shortId\": \"fcd3\",\n \"columnName\": \"Forecast Confidence Destination 3\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"float\"\n },\n {\n \"id\": \"forecast_confidence_origin_2\",\n \"shortId\": \"fco2\",\n \"columnName\": \"Forecast Confidence Origin 2\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"float\"\n },\n {\n \"id\": \"forecast_confidence_origin_3\",\n \"shortId\": \"fco3\",\n \"columnName\": \"Forecast Confidence Origin 3\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"float\"\n },\n {\n \"id\": \"forecast_eta_destination_2\",\n \"shortId\": \"fed2\",\n \"columnName\": \"Forecast ETA Destination 2\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"date yyyy-MM-dd\"\n },\n {\n \"id\": \"forecast_eta_destination_3\",\n \"shortId\": \"fed3\",\n \"columnName\": \"Forecast ETA Destination 3\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"date yyyy-MM-dd\"\n },\n {\n \"id\": \"forecast_eta_origin_2\",\n \"shortId\": \"feo2\",\n \"columnName\": \"Forecast ETA Origin 2\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"date yyyy-MM-dd\"\n },\n {\n \"id\": \"forecast_eta_origin_3\",\n \"shortId\": \"feo3\",\n \"columnName\": \"Forecast ETA Origin 3\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"date yyyy-MM-dd\"\n },\n {\n \"id\": \"forecast_zone_destination_2\",\n \"shortId\": \"fzd2\",\n \"columnName\": \"Forecast Zone Destination 2\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"forecast_zone_destination_3\",\n \"shortId\": \"fzd3\",\n \"columnName\": \"Forecast Zone Destination 3\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"forecast_zone_origin_2\",\n \"shortId\": \"fzo2\",\n \"columnName\": \"Forecast Zone Origin 2\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"forecast_zone_origin_3\",\n \"shortId\": \"fzo3\",\n \"columnName\": \"Forecast Zone Origin 3\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"string\"\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 \"type\": \"string\"\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 \"type\": \"datetime yyyy-MM-dd HH:mm\"\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 \"type\": \"double\"\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\": \"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\": \"ship_to_ship_installation_1\",\n \"shortId\": \"stsi1\",\n \"columnName\": \"Installation STS 1\",\n \"description\": \"Ship to ship installation\",\n \"deprecated\": false,\n \"type\": \"string\"\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 \"type\": \"string\"\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 \"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\": \"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\": \"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_dwt_2\",\n \"shortId\": \"dwt2\",\n \"columnName\": \"Vessel DWT 2\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"long\"\n },\n {\n \"id\": \"vessel_dwt_3\",\n \"shortId\": \"dwt3\",\n \"columnName\": \"Vessel DWT 3\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"long\"\n },\n {\n \"id\": \"vessel_dwt_4\",\n \"shortId\": \"dwt4\",\n \"columnName\": \"Vessel DWT 4\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"long\"\n },\n {\n \"id\": \"vessel_imo_2\",\n \"shortId\": \"imo2\",\n \"columnName\": \"Vessel IMO 2\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"vessel_imo_3\",\n \"shortId\": \"imo3\",\n \"columnName\": \"Vessel IMO 3\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"vessel_imo_4\",\n \"shortId\": \"imo4\",\n \"columnName\": \"Vessel IMO 4\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"vessel_id_2\",\n \"shortId\": \"vid2\",\n \"columnName\": \"Vessel Id 2\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"long\"\n },\n {\n \"id\": \"vessel_id_3\",\n \"shortId\": \"vid3\",\n \"columnName\": \"Vessel Id 3\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"long\"\n },\n {\n \"id\": \"vessel_id_4\",\n \"shortId\": \"vid4\",\n \"columnName\": \"Vessel Id 4\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"long\"\n },\n {\n \"id\": \"vessel_name_2\",\n \"shortId\": \"ven2\",\n \"columnName\": \"Vessel Name 2\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"vessel_name_3\",\n \"shortId\": \"ven3\",\n \"columnName\": \"Vessel Name 3\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"vessel_name_4\",\n \"shortId\": \"ven4\",\n \"columnName\": \"Vessel Name 4\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"string\"\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 \"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\": \"ship_to_ship_volume_1\",\n \"shortId\": \"stsv1\",\n \"columnName\": \"Volume STS 1\",\n \"description\": \"Ship to ship volume\",\n \"deprecated\": false,\n \"type\": \"double\"\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 \"type\": \"double\"\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 \"type\": \"double\"\n },\n {\n \"id\": \"voyage_id_2\",\n \"shortId\": \"voyage_id_2\",\n \"columnName\": \"Voyage Id 2\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"voyage_id_3\",\n \"shortId\": \"voyage_id_3\",\n \"columnName\": \"Voyage Id 3\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"voyage_id_4\",\n \"shortId\": \"voyage_id_4\",\n \"columnName\": \"Voyage Id 4\",\n \"description\": null,\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\": \"super_trade_zone_1\",\n \"shortId\": \"st1\",\n \"columnName\": \"Zone STS 1\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"super_trade_zone_2\",\n \"shortId\": \"st2\",\n \"columnName\": \"Zone STS 2\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"super_trade_zone_3\",\n \"shortId\": \"st3\",\n \"columnName\": \"Zone STS 3\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"string\"\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 \"type\": \"long\"\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 \"type\": \"long\"\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 \"type\": \"long\"\n }\n ]\n}"}],"_postman_id":"44c4fecf-0370-4576-aa25-4e62618b390f"},{"name":"/v1/trades/columns","event":[{"listen":"test","script":{"exec":[""],"type":"text/javascript","id":"eb8842c2-128c-4ec1-9eee-5412bffe045d"}},{"listen":"prerequest","script":{"exec":[""],"type":"text/javascript","id":"c3c08c94-c713-4814-b236-5e67f11cb20a"}}],"id":"5aa3d212-5cba-4c0e-8dbe-5b244374301d","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 \"vessel_name\",\n \"start\",\n \"origin_location_name\",\n \"origin_eta_source\"\n]"},"url":"https://api-lng.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.
\nTherefore 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.
\nNote: The set of columns defined with the hash code will never change and will always remain the same.
\nIn this example, we have created a hash code that will always return the following columns:
\n- \n
- vessel_name \n
- start \n
- origin_location_name \n
- origin_eta_source \n
Required [String]: Token
\n","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":"https://api-lng.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
\n- \n
Provides the last snapshot of all trades. The snapshot is a result of getTrades for all zones, vessels, and products, overall the history.
\n \nThis 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 \nIt allows users to view the state of the trades at a specific point in time.
\n \nThe snapshots are stored on an hourly basis since September 2020 (2020-09-21T200000), the date of the first snapshot can vary depending on the commodity queried.
\n \nIf you want to use point-in-time data, you need to specify the
\nsnapshotDateparameter. ThesnapshotDateparameter 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 specifysnapshotDate=2023-01-01. \n
How to use it
\nIt 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.
\nIn addition to the body response, a header lastAvailableDate is returned. It must be used as the startDate parameter for /v1/trades/updates endpoint.
NOTE:
\n- \n
- 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/updatesendpoint. \n - The result file can be heavy and exceed your platform API default Max response size. Be sure to have no such limitation. \n
FAQ
\nWhat is the difference between getTrades and Snapshot?
\nThe 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).
\n\n
How to use
\n\n![](\"https://kp-prod-public-content.s3-eu-west-1.amazonaws.com/doc/trades_snapshot.gif\")
","urlObject":{"protocol":"https","path":["v1","trades","snapshot"],"host":["api-lng","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 )
\nNote: You cannot use it simultaneously with the ‘columns’ parameter
\n","type":"text/plain"},"key":"hash","value":"{{hash}}"}],"variable":[]}},"response":[{"id":"224d71c0-32b3-43b0-900d-0225df7cc5ba","name":"Get trades snapshot","originalRequest":{"method":"GET","header":[{"description":"Required [String] : Token","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":"https://api-lng.kpler.com/v1/trades/snapshot"},"_postman_previewlanguage":"Text","header":[{"key":"lastAvailableDate","value":"2020-11-02T090100","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"Vessel;Date (origin);Origin;Eta source (origin);Volume (origin m3);Reload STS Partial (origin);Date (destination);Destination;Eta source (destination);Volume (destination m3);Reload STS Partial (destination);Forecasted destination;Forecasted ETA;Forecasted confidence;Export price;Number of trades (export);Import price;Number of trades (import);Trade status;Seller (origin);Buyer (destination);Intermediaries;Country (origin);Subcontinent (origin);Continent Origin;Eta (origin);Start (origin);End (origin);Country (destination);Subcontinent (destination);Continent Destination;Eta (destination);Start (destination);End (destination);Capacity (vessel);Delivery date (vessel);Cargo system (vessel);Cargo type (vessel);Power plant type (vessel);Id (vessel);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;Id (Trade);Zone Origin;Zone Origin Id;Zone Destination;Zone Destination Id;Installation origin;Installation origin id;Installation Destination;Installation Destination Id;Mileage;Ton Miles;Id (Voyage);Id (Product)\nSeri Bakti;2021-01-12 05:18;Bintulu;AIS;150016;;;;Model;150016.0;;Japan;2021-01-20 07:54;0.38;;;;;Scheduled;Petronas;;1;Malaysia;South-East Asia;Asia;2021-01-11 06:00;;;;;;;;;152300;2007-06-29;GT NO 96;Membrane;Steam;76372;FOB;Portfolio;Petronas;Malaysia;Jera;Japan;DES;Spot;Jera;Japan;;;;;;;;;;;;;;;;;;;;;308186;Bintulu;2767;;;Bintulu;3542;;;;;1576349;1860\nNikolay Zubov;2020-12-23 04:32;Yamal;AIS;169420;;;;Model;169420.0;;Zeebrugge;2020-12-31 20:25;0.17;;;;;Scheduled;OAO Yamal LNG;OAO Yamal LNG;0;Russian Federation;Northern Europe;Europe;2020-12-22 03:17;;;;;;;;;172000;;GT NO 96;;TFDE;100297;;Group;OAO Yamal LNG;Russia;OAO Yamal LNG;Russia;;;;;;;;;;;;;;;;;;;;;;;;;308315;Sabetta Seaport;6329;;;Yamal;3602;;;;;1576490;1750\nGaslog Genoa;2020-12-18 11:29;;Model;171390;;;;;171390.0;;;;;;;;;Scheduled;Sabine Pass LLC;;1;;;;;;;;;;;;;174000;;GTT Mk III;;LP-2S;98959;FOB;Contract;Sabine Pass LLC;United States;Shell;Netherlands;DES;Spot;Shell;Netherlands;;;;;;;;;;;;;;;;;;;;;308327;;;;;;;;;;;1576142;2520\nLNG Bonny Ii;2020-12-16 14:42;Bonny LNG;AIS;171390;;;;Model;171390.0;;N. Pacific;2021-01-17 18:36;0.33;;;;;Scheduled;NLNG;;0;Nigeria;Western Africa;Africa;2020-12-15 08:00;;;;;;;;;174000;;TZ Mk. III;Membrane;DFDE;95322;DES;Spot;NLNG;Nigeria;;;;;;;;;;;;;;;;;;;;;;;;;;;308025;Bonny Island;1701;;;Bonny LNG;3543;;;;;1576158;1908\nGaslog Chelsea;2020-12-14 03:12;Corpus Christi;AIS;149755;;;;Model;149705.0;;South-Central Asia;2021-01-11 16:11;0.38;;;;;Scheduled;Cheniere;;1;United States;Northern America;Americas;2020-12-13 00:01;;;;;;;;;153000;2010-05-31;TZ Mk. III;Membrane;TFDE;79313;FOB;Spot;Cheniere;United States;Cool Pool;Monaco;DES;Spot;Cool Pool;Monaco;;;;;;;;;;;;;;;;;;;;;308299;Corpus Christi;1284;;;Corpus Christi;3706;;;;;1576470;1750\n(truncated response)"},{"id":"d11cd76d-55ae-45ca-b242-8f32321cf476","name":"Columns id, name, description and deprecation status","originalRequest":{"method":"GET","header":[],"url":"https://api-lng.kpler.com/v1/trades/snapshot/columns"},"_postman_previewlanguage":"json","header":[],"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}"},{"id":"cc81b867-36f2-4efa-8e02-f8a6af981c32","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-lng.kpler.com/v1/trades/snapshot?snapshotDate=2020-09-25T020000","protocol":"https","host":["api-lng","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":[],"cookie":[],"responseTime":null,"body":""}],"_postman_id":"32a53865-0634-4c3d-b3ae-988788b37ea7"},{"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":"6671e911-be6f-4307-8279-ea5d6a893688","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"description":"Required [String]: Token
\n","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":"https://api-lng.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.
\nNote that the duration between the start date and end date cannot exceed one month.
\n","auth":{"type":"oauth2","oauth2":{"basicConfig":[],"advancedConfig":[{"key":"authRequestParams","value":"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":"8ac38bfa-8ef8-4454-b4a7-9d0f27f5e120","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-lng.kpler.com/v1/trades/snapshot/list?startDate=2023-05-01&endDate=2023-05-03","protocol":"https","host":["api-lng","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-03","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:53:55 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":"616"},{"key":"X-Kong-Proxy-Latency","value":"0"},{"key":"Via","value":"kong/3.2.1.0-enterprise-edition"}],"cookie":[],"responseTime":null,"body":"2023-05-01T000000\n2023-05-01T010000\n2023-05-01T020100\n2023-05-01T030000\n2023-05-01T040000\n2023-05-01T050000\n2023-05-01T060000\n2023-05-01T070000\n2023-05-01T080000\n2023-05-01T090000\n2023-05-01T100000\n2023-05-01T110000\n2023-05-01T120000\n2023-05-01T130100\n2023-05-01T140000\n2023-05-01T150000\n2023-05-01T160000\n2023-05-01T170000\n2023-05-01T180000\n2023-05-01T190000\n2023-05-01T200000\n2023-05-01T210000\n2023-05-01T220000\n2023-05-01T230000\n2023-05-02T000000\n2023-05-02T010000\n2023-05-02T020000\n2023-05-02T030000\n2023-05-02T040000\n2023-05-02T050000\n2023-05-02T060000\n2023-05-02T070000\n2023-05-02T080000\n2023-05-02T090000\n2023-05-02T100000\n2023-05-02T110000\n2023-05-02T120000\n2023-05-02T130000\n2023-05-02T140000\n2023-05-02T150000\n2023-05-02T160100\n2023-05-02T170000\n2023-05-02T180000\n2023-05-02T190000\n2023-05-02T200000\n2023-05-02T210000\n2023-05-02T220000\n2023-05-02T230000\n2023-05-03T000000\n2023-05-03T010000\n2023-05-03T020000\n2023-05-03T030000\n2023-05-03T040000\n2023-05-03T050000\n2023-05-03T060000\n2023-05-03T070000\n2023-05-03T080000\n2023-05-03T090000\n2023-05-03T100000\n2023-05-03T110000\n2023-05-03T120000\n2023-05-03T130000\n2023-05-03T140000\n2023-05-03T150100\n2023-05-03T160000\n2023-05-03T170000\n2023-05-03T180000\n2023-05-03T190100\n2023-05-03T200000\n2023-05-03T210000\n2023-05-03T220000\n2023-05-03T230000"}],"_postman_id":"6671e911-be6f-4307-8279-ea5d6a893688"},{"name":"/v1/trades/updates","event":[{"listen":"test","script":{"exec":[""],"type":"text/javascript","id":"7ca2a864-129b-4186-b67c-6fa90b2b8906"}},{"listen":"prerequest","script":{"exec":[""],"type":"text/javascript","id":"6000fcad-dc4d-4ecf-bbd0-f276d032f6f1"}}],"id":"2a805d82-4b63-407a-a2f1-34b1140ac712","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-lng.kpler.com/v1/trades/updates?startDate={{startDate}}&showAllHistory={{showAllHistory}}&columns={{columns}}&hash={{hash}}","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.
\nFor 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
NOTE:
\n- \n
- Calling
/v1/trades/snapshotonce to initialize your data store/ data lake/ data warehouse, and schedule the call to/v1/trades/snapshotis more optimal than calling/v1/tradeslot of times. Further more calling/v1/tradeswon't prevent you from inconsistency in data as it's a live endpoint. \n
\n
How to use
\nThe 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.
![\"Alt](\"https://kp-prod-public-content.s3-eu-west-1.amazonaws.com/doc/trades_updates_1.gif\")
\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.
\n\n![\"Alt](\"https://kp-prod-public-content.s3-eu-west-1.amazonaws.com/doc/trades_updates_2.gif\")
\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.
\n\n![\"Alt](\"https://kp-prod-public-content.s3-eu-west-1.amazonaws.com/doc/trades_updates_3.gif\")
\n\n
\n\n
How showAllHistory parameter works?
This parameter is meant to provide the different states of the data over time.
\n- \n
- If set to true, all states of the diffs are returned. \n
e.g 1: if a Trade changes 3 times since the startDate then you'll get 3 rows.
\ne.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.
\n- \n
- If set to false, it enable compaction, meaning that all operations since startDate will be condensed in one line. \n
e.g 1: if a Trade changes 3 times since the startDate then you'll get a single row compacting the 3 changes.
\ne.g 2: if a Trade is changes 2 times since the startDate and is eventually deleted, only the Delete operation will be returned.
\nFor 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.
\nExample 1:
\nshowAllHistory set to true
\n- \n
- trade_id 1 product_id A time t1 -> 1 update field A \n
- trade_id 1 product_id A time t2 -> 1 update field B \n
- trade_id 1 product_id A time t3 -> 1 update field C \n
showAllHistory set to false
\n- \n
- trade_id 1 product_id A time t3 -> 1 update field A, B, C \n
Example 2
\nshowAllHistory set to true
\n- \n
- trade_id 1 product_id A time t1 -> 1 update field A \n
- trade_id 1 product_id A time t2 -> 1 update field B \n
- trade_id 1 product_id A time t3 -> 1 delete \n
showAllHistory set to false
\n- \n
- trade_id 1 product_id A time t3 -> 1 delete \n
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-lng","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.
\nNote: 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}}"}],"variable":[]}},"response":[{"id":"060d2b82-7584-4517-a4cd-597ca1028c72","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-lng.kpler.com/v1/trades/updates?startDate=2020-01-01T090721","protocol":"https","host":["api-lng","kpler","com"],"path":["v1","trades","updates"],"query":[{"key":"startDate","value":"2020-01-01T090721"}]}},"_postman_previewlanguage":"Text","header":[{"key":"lastAvailableDate","value":"2020-11-02T090100","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"productId;tradeId;date;operation;jsonUpdates\n2520;304166;2020-11-02T000100;UPDATE;{\"Country (destination)\":\"India\",\"Zone Destination\":\"Dahej\",\"Installation Destination\":\"Dahej\",\"Zone Destination Id\":\"6154\",\"Installation Destination Id\":\"3450\",\"Date (destination)\":\"2020-11-15 18:30\",\"Destination\":\"Dahej\",\"Buyer (destination)\":\"BPCL,Torrent Power,GSPC,Petronet,GAIL,IOC\",\"Eta (destination)\":\"2020-11-15 18:30\",\"Link2 buyer name\":\"BPCL,Torrent Power,GSPC,Petronet,GAIL,IOC\",\"Link2 buyer country\":\"India\"}\n1860;286076;2020-10-28T150100;UPDATE;{\"Volume (origin m3)\":\"75385\"}\n2068;308169;2020-11-02T030100;UPDATE;{\"Forecasted ETA\":\"2020-11-24 01:47\"}\n1750;308276;2020-11-02T090100;INSERT;{\"Vessel\":\"Al Khaznah\",\"Country (origin)\":\"United Arab Emirates\",\"Zone Origin\":\"Das Island\",\"Installation origin\":\"Das Island\",\"Id (Voyage)\":\"1576443\",\"Zone Origin Id\":\"1117\",\"Installation origin id\":\"3552\",\"Continent Origin\":\"Asia\",\"Date (origin)\":\"2020-11-03 13:10\",\"Origin\":\"Das Island\",\"Volume (origin m3)\":\"133464\",\"Volume (destination m3)\":\"133464.0\",\"Trade status\":\"Scheduled\",\"Seller (origin)\":\"ADNOC LNG\",\"Intermediaries\":\"0\",\"Subcontinent (origin)\":\"Middle East\",\"Eta (origin)\":\"2020-11-02 10:15\",\"Eta source (origin)\":\"AIS\",\"Delivery date (vessel)\":\"1994-07-01\",\"Cargo system (vessel)\":\"Moss\",\"Cargo type (vessel)\":\"Spherical\",\"Power plant type (vessel)\":\"Steam\",\"Id (vessel)\":\"64373\",\"Link1 delivery\":\"DES\",\"Link1 type\":\"Spot\",\"Link1 seller name\":\"ADNOC LNG\",\"Link1 seller country\":\"United Arab Emirates\",\"Capacity (vessel)\":\"135496\",\"Forecasted destination\":\"Dahej\",\"Forecasted ETA\":\"2020-11-19 02:08\",\"Forecasted confidence\":\"0.33\",\"Buyer (destination)\":\"GAIL,Petronet,Torrent Power,BPCL,IOC,GSPC\",\"Eta source (destination)\":\"Model\",\"Link1 buyer name\":\"GAIL,Petronet,Torrent Power,BPCL,IOC,GSPC\",\"Link1 buyer country\":\"India\"}\n1750;308129;2020-10-31T120100;UPDATE;{\"Ton Miles\":\"1204405\",\"Volume (origin m3)\":\"925\",\"Volume (destination m3)\":\"908.0\"}\n2068;308283;2020-11-02T030100;INSERT;{\"Vessel\":\"Hyundai Technopia\",\"Country (origin)\":\"Qatar\",\"Zone Origin\":\"Ras Laffan\",\"Installation origin\":\"Ras Laffan\",\"Id (Voyage)\":\"1576451\",\"Zone Origin Id\":\"2414\",\"Installation origin id\":\"3548\",\"Continent Origin\":\"Asia\",\"Date (origin)\":\"2020-11-16 02:59\",\"Origin\":\"Ras Laffan\",\"Volume (origin m3)\":\"132975\",\"Volume (destination m3)\":\"132975.0\",\"Trade status\":\"Scheduled\",\"Seller (origin)\":\"Qatargas\",\"Intermediaries\":\"0\",\"Subcontinent (origin)\":\"Middle East\",\"Eta (origin)\":\"2020-11-15 02:00\",\"Eta source (origin)\":\"AIS\",\"Delivery date (vessel)\":\"1999-07-30\",\"Cargo system (vessel)\":\"Moss\",\"Cargo type (vessel)\":\"Spherical\",\"Power plant type (vessel)\":\"Steam\",\"Id (vessel)\":\"67294\",\"Link1 delivery\":\"FOB\",\"Link1 type\":\"Contract\",\"Link1 seller name\":\"Qatargas\",\"Link1 seller country\":\"Qatar\",\"Link1 buyer name\":\"KOGAS\",\"Link1 buyer country\":\"South Korea\",\"Link2 delivery\":\"\",\"Link2 type\":\"\",\"Link2 seller name\":\"\",\"Link2 seller country\":\"\",\"Capacity (vessel)\":\"135000\",\"Forecasted destination\":\"Incheon\",\"Forecasted ETA\":\"2020-12-04 02:31\",\"Forecasted confidence\":\"0.6\",\"Buyer (destination)\":\"KOGAS\",\"Eta source (destination)\":\"Model\"}\n1750;307858;2020-11-02T090100;UPDATE;{\"Country (destination)\":\"India\",\"Zone Destination\":\"India\",\"Zone Destination Id\":\"447\",\"Continent Destination\":\"Asia\",\"Date (destination)\":\"2020-11-04 05:41\",\"Destination\":\"India\",\"Volume (destination m3)\":\"156023.0\",\"Eta source (destination)\":\"Analyst\",\"Subcontinent (destination)\":\"South-Central Asia\",\"Eta (destination)\":\"2020-11-04 05:41\",\"Id (Voyage)\":\"1576395\"}\n2068;106411;2020-11-02T090100;DELETE;\n1750;308152;2020-10-29T000100;UPDATE;{\"End (destination)\":\"2020-10-28 23:31\"}\n(truncated response)"},{"id":"e6a582a7-c0b5-4127-a556-f70f629b1b2e","name":"Columns id, name, description and deprecation status","originalRequest":{"method":"GET","header":[],"url":"https://api-lng.kpler.com/v1/trades/updates/columns"},"_postman_previewlanguage":"json","header":[],"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\": \"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\": \"cargo_origin_cubic_meters\",\n \"shortId\": \"com\",\n \"columnName\": \"Volume (origin m3)\",\n \"description\": null,\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\": \"cargo_destination_cubic_meters\",\n \"shortId\": \"cdm\",\n \"columnName\": \"Volume (destination m3)\",\n \"description\": null,\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\": \"export_price\",\n \"shortId\": \"epr\",\n \"columnName\": \"Export price\",\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_price\",\n \"shortId\": \"ipr\",\n \"columnName\": \"Import price\",\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\": \"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\": \"lvc\",\n \"shortId\": \"lvc\",\n \"columnName\": \"Capacity (vessel)\",\n \"description\": \"The maximum capacity of the vessel in cubic meters\",\n \"deprecated\": true\n },\n {\n \"id\": \"vessel_delivery_date\",\n \"shortId\": \"vdd\",\n \"columnName\": \"Delivery date (vessel)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_cargo_system\",\n \"shortId\": \"vcs\",\n \"columnName\": \"Cargo system (vessel)\",\n \"description\": null,\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_power_plant\",\n \"shortId\": \"vpp\",\n \"columnName\": \"Power plant type (vessel)\",\n \"description\": null,\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_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\": \"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\": \"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\": \"cargo_destination_tons\",\n \"shortId\": \"cdt\",\n \"columnName\": \"Cargo (destination tons)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"cargo_origin_tons2\",\n \"shortId\": \"cot2\",\n \"columnName\": \"Cargo (origin tons)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"cargo_origin_tons\",\n \"shortId\": \"cot\",\n \"columnName\": \"Cargo (tons)\",\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\": \"forecast_confidence_destination_2\",\n \"shortId\": \"fcd2\",\n \"columnName\": \"Forecast Confidence Destination 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"forecast_confidence_destination_3\",\n \"shortId\": \"fcd3\",\n \"columnName\": \"Forecast Confidence Destination 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"forecast_confidence_origin_2\",\n \"shortId\": \"fco2\",\n \"columnName\": \"Forecast Confidence Origin 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"forecast_confidence_origin_3\",\n \"shortId\": \"fco3\",\n \"columnName\": \"Forecast Confidence Origin 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"forecast_eta_destination_2\",\n \"shortId\": \"fed2\",\n \"columnName\": \"Forecast ETA Destination 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"forecast_eta_destination_3\",\n \"shortId\": \"fed3\",\n \"columnName\": \"Forecast ETA Destination 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"forecast_eta_origin_2\",\n \"shortId\": \"feo2\",\n \"columnName\": \"Forecast ETA Origin 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"forecast_eta_origin_3\",\n \"shortId\": \"feo3\",\n \"columnName\": \"Forecast ETA Origin 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"forecast_zone_destination_2\",\n \"shortId\": \"fzd2\",\n \"columnName\": \"Forecast Zone Destination 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"forecast_zone_destination_3\",\n \"shortId\": \"fzd3\",\n \"columnName\": \"Forecast Zone Destination 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"forecast_zone_origin_2\",\n \"shortId\": \"fzo2\",\n \"columnName\": \"Forecast Zone Origin 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"forecast_zone_origin_3\",\n \"shortId\": \"fzo3\",\n \"columnName\": \"Forecast Zone Origin 3\",\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\": \"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\": \"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\": \"vessel_mmsi\",\n \"shortId\": \"msi\",\n \"columnName\": \"MMSI (vessel)\",\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\": \"vessel_type\",\n \"shortId\": \"vet\",\n \"columnName\": \"Vessel type\",\n \"description\": \"Type of the vessel\",\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":"2a805d82-4b63-407a-a2f1-34b1140ac712"}],"id":"b9e68144-473b-47ac-bdb4-d880bcfbd519","description":"The Trades query returns the volumes from one point of interest to another (installation/zone) on a cargo-by-cargo basis.
\nIn order to select specific columns to display, please use the column ids explicited in the example called Columns id, name, description and deprecation status.
\nNote: The intra-country trades are activated by default if the parameter 'withIntraCountry' is not populated.
\n","event":[{"listen":"prerequest","script":{"type":"text/javascript","exec":[""],"id":"b300a3cb-ed0a-4557-9e24-83830fb89484"}},{"listen":"test","script":{"type":"text/javascript","exec":[""],"id":"51a75a47-31ae-46e1-9f58-75ffba32db2a"}}],"_postman_id":"b9e68144-473b-47ac-bdb4-d880bcfbd519","auth":{"type":"oauth2","oauth2":{"basicConfig":[],"advancedConfig":[{"key":"authRequestParams","value":"Required [String] : Token
\n","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":"https://api-lng.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:
\n- \n
- columns: manually pass each column name you are interested in or use \"all\" to retrieve all available columns. \n
- hash: use a hash that will return the columns you have already chosen. How do I create a hash? \n
Retrieve all available columns when set to \"all\"
\nNote: 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 )
\nNote: Please see note above for details
\n","type":"text/plain"},"key":"hash","value":"{{hash}}"}],"variable":[]}},"response":[{"id":"0fdcad6b-abce-4ece-b28a-0740613c4546","name":"List of all vessels","originalRequest":{"method":"GET","header":[{"key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN","description":"Required [String] : Token"}],"url":"https://api-lng.kpler.com/v1/vessels"},"status":"OK","code":200,"_postman_previewlanguage":"Text","header":[],"cookie":[],"responseTime":null,"body":"Name;Status;Last port-call;Departure date;Volume;Destination;ETA;Destination source;Forecasted destination;Forecasted ETA;Forecast confidence;Availability;Open from;Open until;Condition;Delivery;Redelivery;IMO;MMSI;Last speed;Current controller;Owners;Operators;Builders;Build year;Vessel type;Carrier type;Capacity;Flag name;Engine type;Cargo system;Cargo type;Gross tonnage;Dead weight;Vessel id;Last port-call id;Forecasted Id;Availability id;Owners_id;Operators_id;Builders_id;loaded days in 2016;loaded days in 2017;loaded days in 2018\nAamira;Active;Rudong;2019-07-29 03:01;;Middle East;2019-08-14 00:00;AIS;;;;;;;;;;9443401;538003354;;Qatargas;Qatargas;;Samsung HI;2010;Q-Max;Ocean;266000;Marshall Islands;DRL;TZ Mk. III;Membrane;163922;130026;343;963970;;;10005;;6245;131;139;143\nAbadi;Active;Seria;;132975.0;;;;Sodegaura;2019-08-14 21:48;0.33;;;;;;;9210828;508011000;0.2;Brunei LNG;Brunei Shell Tankers;;MMHI Nagasaki;2002;L (Lower Conventional);Ocean;135000;Brunei Darussalam;Steam;Moss;Spherical;111461;72758;110;968664;2614802;;411;;6601;139;135;103\nAdam LNG;Active;Atlantic LNG;2019-08-04 00:28;159442.0;Tianjin;2019-09-13 06:00;AIS;;;;;;;;;;9501186;538005753;15.4;BP;Oman Shipping Co.;;Hyundai HI;2014;XL (Upper Conventional);Ocean;161870;Marshall Islands;DFDE;TZ Mk. III;Membrane;105975;90986;395;967144;;;2464;;2755;136;171;165\nAdriano Knutsen;Active;Ras Laffan;2019-08-07 05:13;177300.0;Suez Canal;2019-08-16 19:00;AIS;;;;open;2019-07-01 00:00;2019-09-10 00:00;gas free;Far East;;9831220;257410000;17.6;Knutsen;Knutsen;;;2019;XL (Upper Conventional);Ocean;180000;Spain;LSDF;GTT MkIII;;122261;96000;9156;956632;;727;2409;;;0;0;0\n..."},{"id":"06fbe479-3737-4fd6-bc4d-76e02059507c","name":"Columns id, name, description and deprecation status","originalRequest":{"method":"GET","header":[{"description":"Token","key":"Authorization","type":"text","value":"Required [string] "}],"url":"https://api-lng.kpler.com/v1/vessels/columns"},"_postman_previewlanguage":"json","header":[],"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_cubic_meters\",\n \"shortId\": \"cbm\",\n \"columnName\": \"Volume\",\n \"description\": null,\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\": \"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\": \"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_condition\",\n \"shortId\": \"vac\",\n \"columnName\": \"Condition\",\n \"description\": null,\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\": \"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\": \"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_carrier_type\",\n \"shortId\": \"cer\",\n \"columnName\": \"Carrier type\",\n \"description\": \"Ocean/Coastal\",\n \"deprecated\": false\n },\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_flag_name\",\n \"shortId\": \"vfn\",\n \"columnName\": \"Flag name\",\n \"description\": \"Country flag\",\n \"deprecated\": false\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_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_gross_tonnage\",\n \"shortId\": \"vgt\",\n \"columnName\": \"Gross tonnage\",\n \"description\": \"Vessel gross tonnage\",\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_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_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_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\": \"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_dead_weight\",\n \"shortId\": \"vdw\",\n \"columnName\": \"Dead weight (t)\",\n \"description\": \"Dead weight in tons\",\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_raw_destination\",\n \"shortId\": \"lrd\",\n \"columnName\": \"Last signal received\",\n \"description\": \"Last signal received by Kpler\",\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\": \"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\": \"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":"d686de87-d00d-43fd-ae7b-0dc0eed53a35","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-lng.kpler.com/v1/vessels?hash=YOUR_HASH","protocol":"https","host":["api-lng","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":[],"cookie":[],"responseTime":null,"body":""}],"_postman_id":"d9a7880c-eb72-4dc5-936f-64cea5958b95"},{"name":"/v1/vessels/columns","event":[{"listen":"test","script":{"exec":[""],"type":"text/javascript","id":"3bb7f644-0144-42b5-a3e7-4ed6846b0c91"}},{"listen":"prerequest","script":{"exec":[""],"type":"text/javascript","id":"95864175-b282-48db-9bb0-9d92be0dbf74"}}],"id":"8ea76f44-7806-4c72-be06-23f7e71de604","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 \"vessel_name\",\n \"vessel_status\"\n]"},"url":"https://api-lng.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.
\nTherefore 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.
\nNote: The set of columns defined with the hash code will never change and will always remain the same.
\nIn this example, we have created a hash code that will always return the following columns:
\n- \n
- vessel_name \n
- vessel_status \n
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-lng.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-lng","kpler","com"],"query":[],"variable":[]}},"response":[{"id":"7047fd21-90d8-4652-98ca-048523c4ad3f","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-lng.kpler.com/v1/vessels/columns"},"_postman_previewlanguage":"json","header":[],"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_cubic_meters\",\n \"shortId\": \"cbm\",\n \"columnName\": \"Volume\",\n \"description\": null,\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\": \"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\": \"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_condition\",\n \"shortId\": \"vac\",\n \"columnName\": \"Condition\",\n \"description\": null,\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\": \"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\": \"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_carrier_type\",\n \"shortId\": \"cer\",\n \"columnName\": \"Carrier type\",\n \"description\": \"Ocean/Coastal\",\n \"deprecated\": false\n },\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_flag_name\",\n \"shortId\": \"vfn\",\n \"columnName\": \"Flag name\",\n \"description\": \"Country flag\",\n \"deprecated\": false\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_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_gross_tonnage\",\n \"shortId\": \"vgt\",\n \"columnName\": \"Gross tonnage\",\n \"description\": \"Vessel gross tonnage\",\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_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_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_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\": \"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_dead_weight\",\n \"shortId\": \"vdw\",\n \"columnName\": \"Dead weight (t)\",\n \"description\": \"Dead weight in tons\",\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_raw_destination\",\n \"shortId\": \"lrd\",\n \"columnName\": \"Last signal received\",\n \"description\": \"Last signal received by Kpler\",\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\": \"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\": \"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":"8b165181-723f-4523-b7b5-e4a276ac2696"}],"id":"bdfe9a9a-e79e-4fbf-97d2-1e130aab41b0","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.
\nIn 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":{"type":"text/javascript","exec":[""],"id":"72b323be-b6a2-4751-b7ca-354872ba171d"}},{"listen":"test","script":{"type":"text/javascript","exec":[""],"id":"4406e1c9-59fc-4f32-83da-6a866414af6a"}}],"_postman_id":"bdfe9a9a-e79e-4fbf-97d2-1e130aab41b0","auth":{"type":"oauth2","oauth2":{"basicConfig":[],"advancedConfig":[{"key":"authRequestParams","value":"Required [String] : Token
\n","type":"text"}],"url":"https://api-lng.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={{snapshotDate}}","auth":{"type":"oauth2","oauth2":{"basicConfig":[],"advancedConfig":[{"key":"authRequestParams","value":"Required [String]: Flow direction [\"Import\", \"Export\", \"NetImport\", \"NetExport\"]
\nNotes: 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\", \"Trade Type\"]
\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":"Optional [String]: For given LNG vessel types\n
\nUse [\"XL (Upper Conventional)\", \"L (Lower Conventional)\", \"Q-Flex\", \"XS (Pressure Gas)\", \"M (Med Max)\", \"S (Small Scale)\", \"Q-Max\"]\n
\nNote: Values are case sensitive
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 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 [Date]: Format Date : YYYY-MM-DD, if empty it's returning the last snapshot
\n","type":"text/plain"},"key":"snapshotDate","value":"{{snapshotDate}}"}],"variable":[]}},"response":[{"id":"2ed6eb8c-dcfa-4ea3-adb4-c93811cfa20c","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-lng.kpler.com/v1/flows?flowDirection=import&split=destination installations&granularity=annually&toZones=India&startDate=2019-01-01","protocol":"https","host":["api-lng","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":"toZones","value":"India","description":"Optional [String] : Start of the period (YYYY-MM-DD)Names of zones [\"port\", \"region\", \"country\", \"continent\"]"},{"key":"startDate","value":"2019-01-01","description":"Optional [Date] : Start of the period (YYYY-MM-DD)"}]}},"_postman_previewlanguage":"Text","header":[],"cookie":[],"responseTime":null,"body":";Dahej;Dabhol;Hazira;Kochi;unknown;Ennore LNG\n2019;88534190.36;4807399.53;24039461.52;3423062.85;567432.59;809997.65"}],"_postman_id":"ae0e88e6-614e-4573-a31c-b2a31ed9156a"}],"id":"3e7a15ba-04d8-40e4-b34c-245e902bb79a","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":{"type":"text/javascript","exec":[""],"id":"3830a4fe-66f6-4842-b0a9-556d934ba956"}},{"listen":"test","script":{"type":"text/javascript","exec":[""],"id":"c1e04fba-4566-41d1-8309-b5cff4f5ef7e"}}],"_postman_id":"3e7a15ba-04d8-40e4-b34c-245e902bb79a","auth":{"type":"oauth2","oauth2":{"basicConfig":[],"advancedConfig":[{"key":"authRequestParams","value":"Required [String] : Token
\n","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":"https://api-lng.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}}","auth":{"type":"oauth2","oauth2":{"basicConfig":[],"advancedConfig":[{"key":"authRequestParams","value":"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":"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 [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 [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 )
\nNote: You cannot use it simultaneously with the ‘columns’ parameter
\n","type":"text/plain"},"key":"hash","value":"{{hash}}"}],"variable":[]}},"response":[{"id":"e22f133e-5dcf-4a8d-bdd9-37db8c51fcae","name":"Coal cargoes loaded/discharged by Triputra","originalRequest":{"method":"GET","header":[{"key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN","description":"Required [String] : Token"}],"url":{"raw":"https://api-lng.kpler.com/v1/port-calls?vessels=Triputra&products=lng","protocol":"https","host":["api-lng","kpler","com"],"path":["v1","port-calls"],"query":[{"key":"vessels","value":"Triputra","description":"Optional [String] : Names/IMOs of vessels"},{"key":"products","value":"lng","description":"Optional [String] : Names of products"}]}},"status":"OK","code":200,"_postman_previewlanguage":"Text","header":[],"cookie":[],"responseTime":null,"body":"Vessel;Installation;ETA;Start;End;Volume (m3)\nTriputra;Bontang;2019-08-09 18:00;;;22750.0\nTriputra;Benoa;2019-08-01 02:00;2019-08-01 02:39;2019-08-02 03:39;-22243.0\nTriputra;Bontang;2019-07-16 00:00;2019-07-16 07:25;2019-07-16 10:41;22750.0\nTriputra;Benoa;2019-07-11 22:30;2019-07-11 23:17;2019-07-13 00:09;-22682.0\nTriputra;Bontang;2019-07-06 00:00;2019-07-08 06:42;2019-07-09 02:18;22750.0\nTriputra;Benoa;2019-06-21 02:00;2019-06-21 04:19;2019-06-22 05:45;-22648.0\nTriputra;Bontang;2019-06-14 18:00;2019-06-17 06:45;2019-06-18 02:34;22750.0\nTriputra;Benoa;2019-06-02 02:00;2019-06-02 01:29;2019-06-03 01:42;-22682.0\nTriputra;Bontang;2019-06-02 00:00;2019-05-29 06:52;2019-05-30 02:18;22750.0\nTriputra;Benoa;2019-05-18 02:00;2019-05-18 03:01;2019-05-19 03:18;-22750.0\n..."},{"id":"a75f5a99-ce0f-47df-80fc-70d85012de31","name":"Cargoes loaded/discharged in Europe between 1st May 2019 and 31st May 2019.","originalRequest":{"method":"GET","header":[{"key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN","description":"Required [String] : Token"}],"url":{"raw":"https://api-lng.kpler.com/v1/port-calls?startDate=2019-05-01&endDate=2019-05-31&zones=europe","protocol":"https","host":["api-lng","kpler","com"],"path":["v1","port-calls"],"query":[{"key":"startDate","value":"2019-05-01","description":"Optional [Date] : Start of the period (YYYY-MM-DD)"},{"key":"endDate","value":"2019-05-31","description":"Optional [Date] : End of the period (YYYY-MM-DD)"},{"key":"zones","value":"europe","description":"Optional [String] : Names of zones [\"port\", \"region\", \"country\", \"continent\"]"}]}},"status":"OK","code":200,"_postman_previewlanguage":"Text","header":[],"cookie":[],"responseTime":null,"body":"Vessel;Installation;ETA;Start;End;Volume (m3)\nCoral Favia;Vysotsk;2019-05-31 05:00;2019-05-31 22:08;2019-06-02 03:00;9850.0\nMilaha Ras Laffan;Rovigo;2019-05-31 10:10;2019-05-31 16:14;2019-06-01 15:53;-133630.0\nLNG Lokoja;Huelva;2019-05-31 05:00;2019-05-31 11:04;2019-06-01 10:23;-144087.0\nCoralius;GO4LNG;2019-05-29 06:00;2019-05-31 09:53;2019-05-31 14:44;\nGlobal Energy;La Spezia;2019-05-31 06:05;2019-05-31 07:13;2019-06-03 06:45;-73163.0\nCoral Anthelia;Lysekil;2019-05-31 04:00;2019-05-31 05:07;2019-05-31 17:07;-6476.0\nBoris Davydov;Yamal;2019-05-29 12:00;2019-05-30 17:18;2019-05-31 21:33;169420.0\nPioneer Knutsen;Kollsnes;;2019-05-30 11:01;2019-05-30 18:03;\nHoegh Gallant;Damen Shiprepair Brest;2019-05-30 10:00;2019-05-30 08:14;2019-06-17 08:29;"},{"id":"322aaf57-2657-4ea0-94c8-3258c51e16ad","name":"Columns id, name, description and deprecation status","originalRequest":{"method":"GET","header":[],"url":"https://api-lng.kpler.com/v1/port-calls/columns"},"_postman_previewlanguage":"json","header":[],"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\": \"installation_name\",\n \"shortId\": \"inn\",\n \"columnName\": \"Installation\",\n \"description\": \"Name of the installation\",\n \"deprecated\": false\n },\n {\n \"id\": \"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\": \"start\",\n \"shortId\": \"sta\",\n \"columnName\": \"Start\",\n \"description\": \"Date and Time when the vessel started berthing at the terminal\",\n \"deprecated\": false\n },\n {\n \"id\": \"end\",\n \"shortId\": \"end\",\n \"columnName\": \"End\",\n \"description\": \"Date and Time of vessel departure from the terminal\",\n \"deprecated\": false\n },\n {\n \"id\": \"flow_quantity_cubic_meters\",\n \"shortId\": \"fqm\",\n \"columnName\": \"Volume (m3)\",\n \"description\": null,\n \"deprecated\": false\n }\n ],\n \"Optional Columns\": [\n {\n \"id\": \"berth_name\",\n \"shortId\": \"bn\",\n \"columnName\": \"Berth Name\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_capacity_cubic_meters\",\n \"shortId\": \"ccm\",\n \"columnName\": \"Capacity (m3)\",\n \"description\": \"The maximum capacity of the vessel in cubic meters\",\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\": \"vessel_cargo_system\",\n \"shortId\": \"csy\",\n \"columnName\": \"Cargo system (vessel)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_cargo_type\",\n \"shortId\": \"cty\",\n \"columnName\": \"Cargo type (vessel)\",\n \"description\": \"The specific cargo type of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"chartererName\",\n \"shortId\": \"chn\",\n \"columnName\": \"Charterer\",\n \"description\": \"Current controller of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"confidence\",\n \"shortId\": \"con\",\n \"columnName\": \"Confidence\",\n \"description\": \"Confidence (in %) of the system forecast\",\n \"deprecated\": false\n },\n {\n \"id\": \"continent_name\",\n \"shortId\": \"ctn\",\n \"columnName\": \"Continent\",\n \"description\": \"Zone location where the port call is registered\",\n \"deprecated\": false\n },\n {\n \"id\": \"country_name\",\n \"shortId\": \"cyn\",\n \"columnName\": \"Country\",\n \"description\": \"Name of the country\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_delivery_date\",\n \"shortId\": \"del\",\n \"columnName\": \"Delivery date (vessel)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"is_forecasted\",\n \"shortId\": \"isf\",\n \"columnName\": \"Forecasted\",\n \"description\": \"TRUE if this port call has been forecasted automatically by our system\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_imo\",\n \"shortId\": \"imo\",\n \"columnName\": \"IMO (vessel)\",\n \"description\": \"IMO (vessel)\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_id\",\n \"shortId\": \"iid\",\n \"columnName\": \"Id (installation)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"port_call_id\",\n \"shortId\": \"pid\",\n \"columnName\": \"Id (portCall)\",\n \"description\": \"Identifier in the database of Kpler\",\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\": \"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_id\",\n \"shortId\": \"zid\",\n \"columnName\": \"Id (zone)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"location_name\",\n \"shortId\": \"lon\",\n \"columnName\": \"Location\",\n \"description\": \"Specific location where the port call is registered\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_mmsi\",\n \"shortId\": \"mms\",\n \"columnName\": \"MMSI (vessel)\",\n \"description\": \"The Maritime Mobile Service Identity of the vessel (9 digits)\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_nominal_annual_capacity_bm3_gas\",\n \"shortId\": \"icm\",\n \"columnName\": \"NominalAnnualCap (installation bm3 gas)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"is_partial_cargo\",\n \"shortId\": \"isp\",\n \"columnName\": \"PartialCargo\",\n \"description\": \"TRUE if the vessel is partially loaded\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_power_plant\",\n \"shortId\": \"vpp\",\n \"columnName\": \"Power plant type (vessel)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"is_reexport\",\n \"shortId\": \"isr\",\n \"columnName\": \"Reexport\",\n \"description\": \"TRUE if re-export has occurred\",\n \"deprecated\": false\n },\n {\n \"id\": \"is_sts\",\n \"shortId\": \"iss\",\n \"columnName\": \"Ship to ship\",\n \"description\": \"TRUE if ship to ship transfer has occurred\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_status\",\n \"shortId\": \"ins\",\n \"columnName\": \"Status (installation)\",\n \"description\": \"Current status of the Installation (Active, Inactive, Under Construction, etc.)\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_storage_capacity\",\n \"shortId\": \"isc\",\n \"columnName\": \"Storage capacity (installation)\",\n \"description\": \"Storage capacity of the installation\",\n \"deprecated\": false\n },\n {\n \"id\": \"sub_continent_name\",\n \"shortId\": \"scn\",\n \"columnName\": \"SubContinent\",\n \"description\": \"Subcontinent where the port call is registered\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_type\",\n \"shortId\": \"ity\",\n \"columnName\": \"Type (installation)\",\n \"description\": \"Specific type of installation\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_type\",\n \"shortId\": \"typ\",\n \"columnName\": \"Vessel type\",\n \"description\": \"Type of vessel (Q-Flex,Q-Max, etc.)\",\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\": \"zone_name\",\n \"shortId\": \"zon\",\n \"columnName\": \"zone\",\n \"description\": \"Area where the port call is registered\",\n \"deprecated\": false\n }\n ]\n}"},{"id":"e4b8b70d-7ad8-4de7-bfb1-88c305885600","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-lng.kpler.com/v1/port-calls?hash=YOUR_HASH","protocol":"https","host":["api-lng","kpler","com"],"path":["v1","port-calls"],"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":[],"cookie":[],"responseTime":null,"body":""}],"_postman_id":"53415ee9-8218-4979-977b-744efb7e3ac0"},{"name":"/v1/port-calls/columns","event":[{"listen":"test","script":{"exec":[""],"type":"text/javascript","id":"c15b78f8-b0b3-4597-9cc7-c4479bbc3c49"}},{"listen":"prerequest","script":{"exec":[""],"type":"text/javascript","id":"6f79f3e9-9343-4d7f-b2de-dda562ddccbd"}}],"id":"25638f59-9e53-4c4d-823a-cda3756c934f","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 \"installation_name\",\n \"eta\",\n \"start\",\n \"end\"\n]"},"url":"https://api-lng.kpler.com/v1/port-calls/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.
\nTherefore 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.
\nNote: The set of columns defined with the hash code will never change and will always remain the same.
\nIn this example, we have created a hash code that will always return the following columns:
\n- \n
- installation_name \n
- eta \n
- start \n
- end \n
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-lng.kpler.com/v1/port-calls/columns","description":"This endpoint returns a recent and updated list of all columns available for the endpoint port-calls.
\n","urlObject":{"protocol":"https","path":["v1","port-calls","columns"],"host":["api-lng","kpler","com"],"query":[],"variable":[]}},"response":[{"id":"857bb7fe-98d8-457f-a542-8f07289f2188","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-lng.kpler.com/v1/port-calls/columns"},"_postman_previewlanguage":"json","header":[],"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 },\n {\n \"id\": \"installation_name\",\n \"shortId\": \"inn\",\n \"columnName\": \"Installation\",\n \"description\": \"Name of the installation\",\n \"deprecated\": false\n },\n {\n \"id\": \"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\": \"start\",\n \"shortId\": \"sta\",\n \"columnName\": \"Start\",\n \"description\": \"Date and Time when the vessel started berthing at the terminal\",\n \"deprecated\": false\n },\n {\n \"id\": \"end\",\n \"shortId\": \"end\",\n \"columnName\": \"End\",\n \"description\": \"Date and Time of vessel departure from the terminal\",\n \"deprecated\": false\n },\n {\n \"id\": \"flow_quantity_cubic_meters\",\n \"shortId\": \"fqm\",\n \"columnName\": \"Volume (m3)\",\n \"description\": null,\n \"deprecated\": false\n }\n ],\n \"unselected\": [\n {\n \"id\": \"berth_name\",\n \"shortId\": \"bn\",\n \"columnName\": \"Berth Name\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_capacity_cubic_meters\",\n \"shortId\": \"ccm\",\n \"columnName\": \"Capacity (m3)\",\n \"description\": \"The maximum capacity of the vessel in cubic meters\",\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\": \"vessel_cargo_system\",\n \"shortId\": \"csy\",\n \"columnName\": \"Cargo system (vessel)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_cargo_type\",\n \"shortId\": \"cty\",\n \"columnName\": \"Cargo type (vessel)\",\n \"description\": \"The specific cargo type of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"chartererName\",\n \"shortId\": \"chn\",\n \"columnName\": \"Charterer\",\n \"description\": \"Current controller of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"confidence\",\n \"shortId\": \"con\",\n \"columnName\": \"Confidence\",\n \"description\": \"Confidence (in %) of the system forecast\",\n \"deprecated\": false\n },\n {\n \"id\": \"continent_name\",\n \"shortId\": \"ctn\",\n \"columnName\": \"Continent\",\n \"description\": \"Zone location where the port call is registered\",\n \"deprecated\": false\n },\n {\n \"id\": \"country_name\",\n \"shortId\": \"cyn\",\n \"columnName\": \"Country\",\n \"description\": \"Name of the country\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_delivery_date\",\n \"shortId\": \"del\",\n \"columnName\": \"Delivery date (vessel)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"is_forecasted\",\n \"shortId\": \"isf\",\n \"columnName\": \"Forecasted\",\n \"description\": \"TRUE if this port call has been forecasted automatically by our system\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_imo\",\n \"shortId\": \"imo\",\n \"columnName\": \"IMO (vessel)\",\n \"description\": \"IMO (vessel)\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_id\",\n \"shortId\": \"iid\",\n \"columnName\": \"Id (installation)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"port_call_id\",\n \"shortId\": \"pid\",\n \"columnName\": \"Id (portCall)\",\n \"description\": \"Identifier in the database of Kpler\",\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\": \"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_id\",\n \"shortId\": \"zid\",\n \"columnName\": \"Id (zone)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"location_name\",\n \"shortId\": \"lon\",\n \"columnName\": \"Location\",\n \"description\": \"Specific location where the port call is registered\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_mmsi\",\n \"shortId\": \"mms\",\n \"columnName\": \"MMSI (vessel)\",\n \"description\": \"The Maritime Mobile Service Identity of the vessel (9 digits)\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_nominal_annual_capacity_bm3_gas\",\n \"shortId\": \"icm\",\n \"columnName\": \"NominalAnnualCap (installation bm3 gas)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"is_partial_cargo\",\n \"shortId\": \"isp\",\n \"columnName\": \"PartialCargo\",\n \"description\": \"TRUE if the vessel is partially loaded\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_power_plant\",\n \"shortId\": \"vpp\",\n \"columnName\": \"Power plant type (vessel)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"is_reexport\",\n \"shortId\": \"isr\",\n \"columnName\": \"Reexport\",\n \"description\": \"TRUE if re-export has occurred\",\n \"deprecated\": false\n },\n {\n \"id\": \"is_sts\",\n \"shortId\": \"iss\",\n \"columnName\": \"Ship to ship\",\n \"description\": \"TRUE if ship to ship transfer has occurred\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_status\",\n \"shortId\": \"ins\",\n \"columnName\": \"Status (installation)\",\n \"description\": \"Current status of the Installation (Active, Inactive, Under Construction, etc.)\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_storage_capacity\",\n \"shortId\": \"isc\",\n \"columnName\": \"Storage capacity (installation)\",\n \"description\": \"Storage capacity of the installation\",\n \"deprecated\": false\n },\n {\n \"id\": \"sub_continent_name\",\n \"shortId\": \"scn\",\n \"columnName\": \"SubContinent\",\n \"description\": \"Subcontinent where the port call is registered\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_type\",\n \"shortId\": \"ity\",\n \"columnName\": \"Type (installation)\",\n \"description\": \"Specific type of installation\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_type\",\n \"shortId\": \"typ\",\n \"columnName\": \"Vessel type\",\n \"description\": \"Type of vessel (Q-Flex,Q-Max, etc.)\",\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\": \"zone_name\",\n \"shortId\": \"zon\",\n \"columnName\": \"zone\",\n \"description\": \"Area where the port call is registered\",\n \"deprecated\": false\n }\n ]\n}"}],"_postman_id":"c598315e-ee21-469f-aa87-054befe76572"}],"id":"4e85023b-9942-4610-babb-cad677b8aa74","description":"The Port Calls query returns the cargo-by-cargo details for loadings/discharges taking place in a point of interest (installation/zone). Historical data goes back to 2013.
\nIn 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":{"type":"text/javascript","exec":[""],"id":"1c4ae2f4-0310-4ee0-86c1-277346c727b1"}},{"listen":"test","script":{"type":"text/javascript","exec":[""],"id":"d9f41084-d015-40dd-96dc-8e8eb5eb3356"}}],"_postman_id":"4e85023b-9942-4610-babb-cad677b8aa74","auth":{"type":"oauth2","oauth2":{"basicConfig":[],"advancedConfig":[{"key":"authRequestParams","value":"Required [String] : Token
\n","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":"https://api-lng.kpler.com/v1/ship-to-ships?size={{size}}&vessels={{vessels}}&zones={{zones}}&products={{products}}&startDate={{startDate}}&endDate={{endDate}}&columns={{columns}}&hash={{hash}}","auth":{"type":"oauth2","oauth2":{"basicConfig":[],"advancedConfig":[{"key":"authRequestParams","value":"Optional [Integer]: Maximum number of sts 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 zones [\"port\", \"lightering\", \"region\", \"country\", \"continent\"]
\n","type":"text/plain"},"key":"zones","value":"{{zones}}"},{"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]: 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 )
\nNote: You cannot use it simultaneously with the ‘columns’ parameter
\n","type":"text/plain"},"key":"hash","value":"{{hash}}"}],"variable":[]}},"response":[{"id":"58d13773-e6cf-4e2e-a85b-cf4088b0daac","name":"Ship-to-ships loadings/discharges of gasoline in Fujairah Light. between 1st January and 1st May 2019","originalRequest":{"method":"GET","header":[{"description":"Required [String] : Token","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":{"raw":"https://api-lng.kpler.com/v1/ship-to-ships?startDate=2019-01-01&endDate=2019-05-01","protocol":"https","host":["api-lng","kpler","com"],"path":["v1","ship-to-ships"],"query":[{"key":"startDate","value":"2019-01-01","description":"Optional [Date] : Start of the period (YYYY-MM-DD)"},{"key":"endDate","value":"2019-05-01","description":"Optional [Date] : End of the period (YYYY-MM-DD)"}]}},"status":"OK","code":200,"_postman_previewlanguage":"Text","header":[],"cookie":[],"responseTime":null,"body":"Vessel (load);IMO (load);Vessel (discharge);IMO (discharge);Volume (cm);Zone;Start;End\nClean Horizon;9655444;Boris Vilkitsky;9768368;158571;Honningsvag Light.;2019-05-01 10:49;2019-05-02 23:52\nBritish Sapphire;9333618;Vladimir Vize;9750658;151590;Honningsvag Light.;2019-05-01 07:42;2019-05-03 10:39\nBritish Diamond;9333620;Boris Davydov;9768394;152263;Honningsvag Light.;2019-04-30 17:47;2019-05-02 06:00\nScf Melampus;9654878;Eduard Toll;9750696;167296;Honningsvag Light.;2019-04-28 23:13;2019-04-30 21:01\nFlex Endeavour;9762261;Nikolay Zubov;9768526;168811;Honningsvag Light.;2019-04-26 18:27;2019-04-28 06:49\nYamal Spirit;9781920;Fedor Litke;9768370;168963;Honningsvag Light.;2019-04-24 20:21;2019-04-26 22:06\nCorcovado LNG;9636711;Georgiy Brusilov;9768382;157290;Honningsvag Light.;2019-04-23 22:06;2019-04-24 22:31\nClean Planet;9637507;Rudolf Samoylovich;9750713;159472;Zeebrugge;2019-04-23 18:36;2019-04-24 20:28\nPatris;9766889;Vladimir Rusanov;9750701;168659;Honningsvag Light.;2019-04-22 12:04;2019-04-23 23:59\nBw Tulip;9758064;Vladimir Vize;9750658;168811;Honningsvag Light.;2019-04-22 04:13;2019-04-23 20:23\nPskov;9630028;Boris Davydov;9768394;167416;Honningsvag Light.;2019-04-18 19:33;2019-04-20 08:52"},{"id":"772e63e9-930e-432c-95a4-0f7453083dad","name":"Columns id, name, description and deprecation status","originalRequest":{"method":"GET","header":[],"url":"https://api-lng.kpler.com/v1/ship-to-ships/columns"},"_postman_previewlanguage":"json","header":[],"cookie":[],"responseTime":null,"body":"{\n \"Columns by default\": [\n {\n \"id\": \"load_vessel_name\",\n \"shortId\": \"lvn\",\n \"columnName\": \"Vessel (load)\",\n \"description\": \"Name of the vessel load\",\n \"deprecated\": false\n },\n {\n \"id\": \"load_vessel_imo\",\n \"shortId\": \"lim\",\n \"columnName\": \"IMO (load)\",\n \"description\": \"IMO of the vessel load\",\n \"deprecated\": false\n },\n {\n \"id\": \"discharge_vessel_name\",\n \"shortId\": \"dvn\",\n \"columnName\": \"Vessel (discharge)\",\n \"description\": \"Name of the vessel discharge\",\n \"deprecated\": false\n },\n {\n \"id\": \"discharge_vessel_imo\",\n \"shortId\": \"dim\",\n \"columnName\": \"IMO (discharge)\",\n \"description\": \"IMO of the vessel discharge\",\n \"deprecated\": false\n },\n {\n \"id\": \"flow_quantity_cms\",\n \"shortId\": \"fqm\",\n \"columnName\": \"Volume (cm)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"zone_name\",\n \"shortId\": \"zon\",\n \"columnName\": \"Zone\",\n \"description\": \"Area where the port call is registered\",\n \"deprecated\": false\n },\n {\n \"id\": \"start\",\n \"shortId\": \"sta\",\n \"columnName\": \"Start\",\n \"description\": \"Start Datetime of the ship to ship\",\n \"deprecated\": false\n },\n {\n \"id\": \"end\",\n \"shortId\": \"end\",\n \"columnName\": \"End\",\n \"description\": \"End Datetime of the ship to ship\",\n \"deprecated\": false\n }\n ],\n \"Optional Columns\": [\n {\n \"id\": \"country_name\",\n \"shortId\": \"con\",\n \"columnName\": \"Country\",\n \"description\": \"Country where the transfer is happening\",\n \"deprecated\": false\n },\n {\n \"id\": \"country_id\",\n \"shortId\": \"cid\",\n \"columnName\": \"Country Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"discharge_port_call_id\",\n \"shortId\": \"did\",\n \"columnName\": \"PortCall Id (discharge)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"load_port_call_id\",\n \"shortId\": \"lid\",\n \"columnName\": \"PortCall Id (load)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"ship_to_ship_id\",\n \"shortId\": \"sid\",\n \"columnName\": \"STS Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_eta_discharge\",\n \"shortId\": \"ved\",\n \"columnName\": \"Vessel ETA (discharge)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_eta_load\",\n \"shortId\": \"vel\",\n \"columnName\": \"Vessel ETA (load)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"discharge_vessel_capacity\",\n \"shortId\": \"dvc\",\n \"columnName\": \"Vessel capacity (discharge)\",\n \"description\": \"Capacity of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"load_vessel_capacity\",\n \"shortId\": \"lvc\",\n \"columnName\": \"Vessel capacity (load)\",\n \"description\": \"Capacity of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"discharge_vessel_id\",\n \"shortId\": \"dbi\",\n \"columnName\": \"Vessel id (discharge)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"load_vessel_id\",\n \"shortId\": \"lbi\",\n \"columnName\": \"Vessel id (load)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"discharge_vessel_type\",\n \"shortId\": \"dvt\",\n \"columnName\": \"Vessel type (discharge)\",\n \"description\": \"Type of the vessel discharging\",\n \"deprecated\": false\n },\n {\n \"id\": \"load_vessel_type\",\n \"shortId\": \"lvt\",\n \"columnName\": \"Vessel type (load)\",\n \"description\": \"Type of the vessel discharging\",\n \"deprecated\": false\n },\n {\n \"id\": \"discharge_voyage_id\",\n \"shortId\": \"dvi\",\n \"columnName\": \"Voyage Id (discharge)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"load_voyage_id\",\n \"shortId\": \"lvi\",\n \"columnName\": \"Voyage Id (load)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"zone_id\",\n \"shortId\": \"zid\",\n \"columnName\": \"Zone Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n }\n ]\n}"},{"id":"742d3e4a-a6a4-4d52-a022-acf589c9a4a4","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-lng.kpler.com/v1/ship-to-ships?hash=YOUR_HASH","protocol":"https","host":["api-lng","kpler","com"],"path":["v1","ship-to-ships"],"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":[],"cookie":[],"responseTime":null,"body":""}],"_postman_id":"f1c37aac-7123-4014-bcd0-6f6368169db8"},{"name":"/v1/ship-to-ships/columns","event":[{"listen":"test","script":{"exec":[""],"type":"text/javascript","id":"1caf9e44-9e8e-4146-902d-259e9642808b"}},{"listen":"prerequest","script":{"exec":[""],"type":"text/javascript","id":"2408ed01-55a9-4114-a247-099fd60ef816"}}],"id":"fd500b16-064f-43fc-a2b8-242fcab2dd72","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"},{"description":"Required [String]: application/json or text/json
\n","key":"Content-Type","type":"text","value":"application/json"}],"body":{"mode":"raw","raw":"[\n \"load_vessel_name\",\n \"load_vessel_imo\",\n \"discharge_vessel_name\",\n \"discharge_vessel_imo\"\n]"},"url":"https://api-lng.kpler.com/v1/ship-to-ships/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.
\nTherefore 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.
\nNote: The set of columns defined with the hash code will never change and will always remain the same.
\nIn this example, we have created a hash code that will always return the following columns:
\n- \n
- load_vessel_name \n
- load_vessel_imo \n
- discharge_vessel_name \n
- discharge_vessel_imo \n
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-lng.kpler.com/v1/ship-to-ships/columns","description":"This endpoint returns a recent and updated list of all columns available for the endpoint ship-to-ships.
\n","urlObject":{"protocol":"https","path":["v1","ship-to-ships","columns"],"host":["api-lng","kpler","com"],"query":[],"variable":[]}},"response":[{"id":"44d595d5-4fad-48bf-996c-39f3162aa9b2","name":"List of 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-lng.kpler.com/v1/ship-to-ships/columns"},"_postman_previewlanguage":"json","header":[],"cookie":[],"responseTime":null,"body":"{\n \"selected\": [\n {\n \"id\": \"load_vessel_name\",\n \"shortId\": \"lvn\",\n \"columnName\": \"Vessel (load)\",\n \"description\": \"Name of the vessel load\",\n \"deprecated\": false\n },\n {\n \"id\": \"load_vessel_imo\",\n \"shortId\": \"lim\",\n \"columnName\": \"IMO (load)\",\n \"description\": \"IMO of the vessel load\",\n \"deprecated\": false\n },\n {\n \"id\": \"discharge_vessel_name\",\n \"shortId\": \"dvn\",\n \"columnName\": \"Vessel (discharge)\",\n \"description\": \"Name of the vessel discharge\",\n \"deprecated\": false\n },\n {\n \"id\": \"discharge_vessel_imo\",\n \"shortId\": \"dim\",\n \"columnName\": \"IMO (discharge)\",\n \"description\": \"IMO of the vessel discharge\",\n \"deprecated\": false\n },\n {\n \"id\": \"flow_quantity_cms\",\n \"shortId\": \"fqm\",\n \"columnName\": \"Volume (cm)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"zone_name\",\n \"shortId\": \"zon\",\n \"columnName\": \"Zone\",\n \"description\": \"Area where the port call is registered\",\n \"deprecated\": false\n },\n {\n \"id\": \"start\",\n \"shortId\": \"sta\",\n \"columnName\": \"Start\",\n \"description\": \"Start Datetime of the ship to ship\",\n \"deprecated\": false\n },\n {\n \"id\": \"end\",\n \"shortId\": \"end\",\n \"columnName\": \"End\",\n \"description\": \"End Datetime of the ship to ship\",\n \"deprecated\": false\n }\n ],\n \"unselected\": [\n {\n \"id\": \"country_name\",\n \"shortId\": \"con\",\n \"columnName\": \"Country\",\n \"description\": \"Country where the transfer is happening\",\n \"deprecated\": false\n },\n {\n \"id\": \"country_id\",\n \"shortId\": \"cid\",\n \"columnName\": \"Country Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"discharge_port_call_id\",\n \"shortId\": \"did\",\n \"columnName\": \"PortCall Id (discharge)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"load_port_call_id\",\n \"shortId\": \"lid\",\n \"columnName\": \"PortCall Id (load)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"ship_to_ship_id\",\n \"shortId\": \"sid\",\n \"columnName\": \"STS Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_eta_discharge\",\n \"shortId\": \"ved\",\n \"columnName\": \"Vessel ETA (discharge)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_eta_load\",\n \"shortId\": \"vel\",\n \"columnName\": \"Vessel ETA (load)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"discharge_vessel_capacity\",\n \"shortId\": \"dvc\",\n \"columnName\": \"Vessel capacity (discharge)\",\n \"description\": \"Capacity of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"load_vessel_capacity\",\n \"shortId\": \"lvc\",\n \"columnName\": \"Vessel capacity (load)\",\n \"description\": \"Capacity of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"discharge_vessel_id\",\n \"shortId\": \"dbi\",\n \"columnName\": \"Vessel id (discharge)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"load_vessel_id\",\n \"shortId\": \"lbi\",\n \"columnName\": \"Vessel id (load)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"discharge_vessel_type\",\n \"shortId\": \"dvt\",\n \"columnName\": \"Vessel type (discharge)\",\n \"description\": \"Type of the vessel discharging\",\n \"deprecated\": false\n },\n {\n \"id\": \"load_vessel_type\",\n \"shortId\": \"lvt\",\n \"columnName\": \"Vessel type (load)\",\n \"description\": \"Type of the vessel discharging\",\n \"deprecated\": false\n },\n {\n \"id\": \"discharge_voyage_id\",\n \"shortId\": \"dvi\",\n \"columnName\": \"Voyage Id (discharge)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"load_voyage_id\",\n \"shortId\": \"lvi\",\n \"columnName\": \"Voyage Id (load)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"zone_id\",\n \"shortId\": \"zid\",\n \"columnName\": \"Zone Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n }\n ]\n}"}],"_postman_id":"cf36a3fa-85c3-4efd-8551-067c5d5d1058"}],"id":"efe50209-5192-4a2b-89f5-e7e9d3947368","description":"The STS (ship-to-ship) query returns the ship-to-ship loadings/discharges in a given\nzone,with details on the vessels taking part in the operation and crude grades being exchanged for a given time period.
\nIn 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":{"type":"text/javascript","exec":[""],"id":"edc17c5d-fe1c-435e-9add-7bbba472ddd6"}},{"listen":"test","script":{"type":"text/javascript","exec":[""],"id":"30f3014b-5662-43f2-b470-184d8faec834"}}],"_postman_id":"efe50209-5192-4a2b-89f5-e7e9d3947368","auth":{"type":"oauth2","oauth2":{"basicConfig":[],"advancedConfig":[{"key":"authRequestParams","value":"Required [String] : Token
\n","type":"text"}],"url":"https://api-lng.kpler.com/v1/fleet-metrics?metric={{metric}}&zones={{zones}}&floatingStorageDurationMin={{floatingStorageDurationMin}}&floatingStorageDurationMax={{floatingStorageDurationMax}}&period={{period}}&startDate={{startDate}}&endDate={{endDate}}&unit={{unit}}&split={{split}}&vesselTypes={{vesselTypes}}","description":"Retrieve the daily/weekly fleet data aggregated for a given zone.
\nAvailable for all the fleet metrics.
\nNote: The units can change according to the metric that you have chosen. Please find below the list of default units if the parameter \"unit\" is not specified in your request:
\n- \n
- floating_storage by default return in cm unit \n
- loaded_vessels by default return in cm unit \n
- Split parameter includes continents, subcontinents, countries, subregions and seas, but not aggregation zones. \n
Required [String]: Use following metrics: \n
Optional [String]: Names of countries/geographical zones. Default to world if not specified.
\n","type":"text/plain"},"key":"zones","value":"{{zones}}"},{"description":{"content":"Minimum floating days [1-3-5-7-10-12-15-20-30-90].
\nNote: Required for metric floating_storage
\n","type":"text/plain"},"key":"floatingStorageDurationMin","value":"{{floatingStorageDurationMin}}"},{"description":{"content":"Maximum floating days [1-3-5-7-10-12-15-20-30-90-Inf].
\nNote: Required for metric floating_storage
\n","type":"text/plain"},"key":"floatingStorageDurationMax","value":"{{floatingStorageDurationMax}}"},{"description":{"content":"Optional [String]: Use [\"daily\", \"weekly\", \"eia\"]. Weekly by default if not specified.
\n","type":"text/plain"},"key":"period","value":"{{period}}"},{"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]: Use [\"bbl\", \"kb\", \"mmbbl\", \"mt\", \"kt\", \"t\", \"cm\"]. Default to cm if not specified.
\n","type":"text/plain"},"key":"unit","value":"{{unit}}"},{"description":{"content":"Optional [String]: Use following splits: [\"Total\", \" 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\", \" Current Continents\", \" Current Subcontinents\", \" Current Countries\", \" Current Subregions\", \" Current Seas\", \" Floating Days\"].\nDefault to Total if not specified.
\n","type":"text/plain"},"key":"split","value":"{{split}}"},{"description":{"content":"Optional [String]: For given LNG vessel types\n
\nUse [\"XL (Upper Conventional)\", \"L (Lower Conventional)\", \"Q-Flex\", \"XS (Pressure Gas)\", \"M (Med Max)\", \"S (Small Scale)\", \"Q-Max\"]\n
\nNote: Values are case sensitive
Required [String] : Token
\n","type":"text"}],"url":"https://api-lng.kpler.com/v1/fleet-metrics/vessels?metric={{metric}}&floatingStorageDurationMin={{floatingStorageDurationMin}}&floatingStorageDurationMax={{floatingStorageDurationMax}}&zones={{zones}}&unit={{unit}}&startDate={{startDate}}&endDate={{endDate}}&vesselTypes={{vesselTypes}}","description":"Through this endpoint is provided the list of vessels with their cargo per day on a given period and their location, for the Floating Storage and the Commodity on water metrics.
\nNote: The units can change according to the metric that you have chosen. Please find below the list of default units if the parameter \"unit\" is not specified in your request:
\n- \n
- floating_storage by default return in cm unit \n
- loaded_vessels by default return in cm unit \n
- Column names starting with \"current ...\" cover continents, subcontinents, countries, subregions and seas, but not aggregation zones. \n
How start date and end date works?
\n- \n
- If both are null, the result will be today's data only. \n
- If filled, startDate and endDate shall be less than 31 days apart. \n
e.g To retrieve data for 2020-10-01, you should specified startDate=2020-10-01 and endDate=2020-10-01.
\n- \n
- If startDate is not null and endDate is null, the data for 31 days after startDate will be retrieved (if upper bound is before or equal to today) \n
- If endDate is not null and startDate is null, the data for 31 days before endDate will be retrieved (if lower bound is after or equal to historical data limitation) \n
Required [String]: Use following metrics: \n
Minimum floating days [1-3-5-7-10-12-15-20-30-90].
\nNote: Required for metric floating_storage
\n","type":"text/plain"},"key":"floatingStorageDurationMin","value":"{{floatingStorageDurationMin}}"},{"description":{"content":"Maximum floating days [1-3-5-7-10-12-15-20-30-90-Inf].
\nNote: Required for metric floating_storage
\n","type":"text/plain"},"key":"floatingStorageDurationMax","value":"{{floatingStorageDurationMax}}"},{"description":{"content":"Optional [String]: Names of countries/geographical zones. Default to world if not specified.
\n","type":"text/plain"},"key":"zones","value":"{{zones}}"},{"description":{"content":"Optional [String]: Use ['bbl', 'kb', 'mmbbl', 'mt', 'kt', 't', 'cm']. Default to cm if not specified.
\n","type":"text/plain"},"key":"unit","value":"{{unit}}"},{"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]: For given LNG vessel types\n
\nUse [\"XL (Upper Conventional)\", \"L (Lower Conventional)\", \"Q-Flex\", \"XS (Pressure Gas)\", \"M (Med Max)\", \"S (Small Scale)\", \"Q-Max\"]\n
\nNote: Values are case sensitive
Required [String] : Token
\n"}],"url":"https://api-lng.kpler.com/v1/fleet-metrics/trades?metric={{metric}}&date={{date}}&floatingStorageDurationMin={{floatingStorageDurationMin}}&floatingStorageDurationMax={{floatingStorageDurationMax}}&zones={{zones}}&vesselTypes={{vesselTypes}}","description":"Through this endpoint you can retrieve a list of all individual trades that are used for composing the \"Fleet Metrics\" Total numbers and grain further insights by performing analysis on more granular data.
\n","auth":{"type":"oauth2","oauth2":{"basicConfig":[],"advancedConfig":[{"key":"authRequestParams","value":"Required [String]: Use following metrics: \n
Required [Date]: Selected date in YYYY-MM-DD format
\n","type":"text/plain"},"key":"date","value":"{{date}}"},{"description":{"content":"Minimum floating days [1-3-5-7-10-12-15-20-30-90].
\nNote: Required for metric floating_storage
\n","type":"text/plain"},"key":"floatingStorageDurationMin","value":"{{floatingStorageDurationMin}}"},{"description":{"content":"Maximum floating days [1-3-5-7-10-12-15-20-30-90-Inf].
\nNote: Required for metric floating_storage
\n","type":"text/plain"},"key":"floatingStorageDurationMax","value":"{{floatingStorageDurationMax}}"},{"description":{"content":"Optional [String]: Names of countries/geographical zones. Default to world if not specified.
\n","type":"text/plain"},"key":"zones","value":"{{zones}}"},{"description":{"content":"Optional [String]: For given LNG vessel types\n
\nUse [\"XL (Upper Conventional)\", \"L (Lower Conventional)\", \"Q-Flex\", \"XS (Pressure Gas)\", \"M (Med Max)\", \"S (Small Scale)\", \"Q-Max\"]\n
\nNote: Values are case sensitive
The fleet metrics endpoint returns fleet data for a given zone.
\nFollowing metrics are available:
\n- \n
- Floating storage \n
- Commodity on water \n
The granularity of the data is on a daily, weekly and EIA-weekly basis, with the ability to modify floating days for the floating storage query.
\n","_postman_id":"384da87b-b3cf-44a9-b4bb-ef36c5ea6556","auth":{"type":"oauth2","oauth2":{"basicConfig":[],"advancedConfig":[{"key":"authRequestParams","value":"Required [String] : Token
\n","type":"text"}],"url":"https://api-lng.kpler.com/v1/inventories?zones={{zones}}&installations={{installation}}&startDate={{startDate}}&endDate={{endDate}}&split={{split}}","description":"A /inventories endpoint returns detailed information about the LNG inventory levels globally.
\n*Freeport daily inventories - only take into account partial pipeline send (in) flows as not all data is publically available
\n*Cove Point daily inventories - do not take into account any regasification (send-out) volumes
\n","auth":{"type":"oauth2","oauth2":{"basicConfig":[],"advancedConfig":[{"key":"authRequestParams","value":"[String]: Names of the zones [\"port\", \"region\", \"country\", \"continent\"]
\n","type":"text/plain"},"key":"zones","value":"{{zones}}"},{"description":{"content":"Optional [String]: Names of installations
\n","type":"text/plain"},"key":"installations","value":"{{installation}}"},{"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]: Splits the inventories data \"byCountry\" or \"byInstallation\"
\n","type":"text/plain"},"key":"split","value":"{{split}}"}],"variable":[]}},"response":[{"id":"80f98de7-8fdb-4694-aefe-2609a2af0c3d","name":"/v1/inventories","originalRequest":{"method":"GET","header":[{"key":"Authorization","value":"Bearer YOUR_TOKEN","description":"Optional [String] : Names of installations","type":"text"}],"url":{"raw":"https://api-lng.kpler.com/v1/inventories?installations=South Hook","protocol":"https","host":["api-lng","kpler","com"],"path":["v1","inventories"],"query":[{"key":"zones","value":"{{zones}}","description":"[String]: Names of the zones [\"port\", \"region\", \"country\", \"continent\"]","disabled":true},{"key":"installations","value":"South Hook","description":"Optional [String]: Names of installations"},{"key":"startDate","value":"{{startDate}}","description":"Optional [Date]: Start of the period (YYYY-MM-DD)","disabled":true},{"key":"endDate","value":"{{endDate}}","description":"Optional [Date]: End of the period (YYYY-MM-DD)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"Text","header":[],"cookie":[],"responseTime":null,"body":"date;installation;storage_volume_kwh;net_gas_flow_kwhd;cargo_kwh;capacity_kwh;capacity_utilization;heel_kwh;country;continent\r\n2017-01-01;South Hook;3329114660;-85368343;0;5251247368;0.634;188028535;United Kingdom;Europe\r\n2017-01-02;South Hook;3226474796;-86913226;0;5251247368;0.614;188028535;United Kingdom;Europe\r\n2017-01-03;South Hook;3042654035;-97463151;0;5251247368;0.579;188028535;United Kingdom;Europe\r\n2017-01-04;South Hook;2920655701;-92720089;0;5251247368;0.556;188028535;United Kingdom;Europe\r\n2017-01-05;South Hook;2840653794;-103432634;0;5251247368;0.541;188028535;United Kingdom;Europe\r\n2017-01-06;South Hook;2703924864;-137196460;1280301539;5251247368;0.515;188028535;United Kingdom;Europe"}],"_postman_id":"20669bb5-00c4-422f-a53c-c9ace2743937"}],"id":"aedb19b3-3097-4482-a53f-ee713ec3d905","description":"A storages endpoint returns detailed information about the remaining LNG
levels in the storage tanks, send-out levels as well as past and future deliveries of LNG by
tankers to a pre-defined set of European Regasification installation.
Required [String] : Token
\n","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":"https://api-lng.kpler.com/v1/contracts?size={{size}}&players={{players}}&zones={{zones}}&installations={{installations}}&startDate={{startDate}}&endDate={{endDate}}&types={{types}}&columns={{columns}}&hash={{hash}}","auth":{"type":"oauth2","oauth2":{"basicConfig":[],"advancedConfig":[{"key":"authRequestParams","value":"Optional [Integer]: Maximum number of trades returned
\n","type":"text/plain"},"key":"size","value":"{{size}}"},{"description":{"content":"Optional [String]: Name of buyer or seller involved in a contract
\n","type":"text/plain"},"key":"players","value":"{{players}}"},{"description":{"content":"Optional [String]: Country, region or continent of installations involved in a contract
\n","type":"text/plain"},"key":"zones","value":"{{zones}}"},{"description":{"content":"Optional [String]: Names of installations
\n","type":"text/plain"},"key":"installations","value":"{{installations}}"},{"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]: Use [\"SPA\", \"TUA\", \"LTA\", \"Tender\"]
\n","type":"text/plain"},"key":"types","value":"{{types}}"},{"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 )
\nNote: You cannot use it simultaneously with the ‘columns’ parameter
\n","type":"text/plain"},"key":"hash","value":"{{hash}}"}],"variable":[]}},"response":[{"id":"a803ce8e-38b6-4a65-bf5f-b43070ae0c64","name":"contracts - Get contracts by zones","originalRequest":{"method":"GET","header":[{"description":"Required [string] : Token","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":{"raw":"https://api-lng.kpler.com/v1/contracts?zones=europe","protocol":"https","host":["api-lng","kpler","com"],"path":["v1","contracts"],"query":[{"key":"zones","value":"europe","description":"Optional [String] : Country, region or continent of installations involved in a contract"}]}},"status":"OK","code":200,"_postman_previewlanguage":"Text","header":[],"cookie":[],"responseTime":null,"body":"Type;Seller;Buyer;Capacity;Slots;Delivery;Start;End;Installations Origin;Installations Destination;Origin Zone;Destination Zone;Origin Zone Id;Destination Zone Id;Entity Seller;Entity Buyer;Comments;Id\nSPA;Novatek;Engie;1.0;;FOB;2023-12-31 00:00;2047-12-31 00:00;Montoir;;France;World;175;899;Novatek;Engie;14 cargoes per year. Via transshipment at Montoir.;1099\nSPA;Sempra;State Treasury of Poland;2.0;;FOB;2023-01-01 00:00;2042-12-31 00:00;Cameron (Liqu.);Swinoujscie;United States;Poland;202;235;Sempra;PGNiG;;2940\nSPA;Venture Global LNG;State Treasury of Poland;2.0;;FOB;2022-01-01 00:00;2042-01-01 00:00;Calcasieu Pass;Swinoujscie;United States;Poland;202;235;Venture Global LNG;PGNiG;Start in 2022-23. HH+Liq. Fee.;2877"},{"id":"6893124c-29c2-4928-ab8d-6fe68724d774","name":"contracts - Get contracts by types","originalRequest":{"method":"GET","header":[{"description":"Required [String] : Token","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":{"raw":"https://api-lng.kpler.com/v1/contracts?types=SPA","protocol":"https","host":["api-lng","kpler","com"],"path":["v1","contracts"],"query":[{"key":"types","value":"SPA","description":"Optional [String] : [\"SPA\", \"TUA\", \"LTA\", \"Tender\"]"}]}},"status":"OK","code":200,"_postman_previewlanguage":"Text","header":[],"cookie":[],"responseTime":null,"body":"Type;Seller;Buyer;Capacity;Slots;Delivery;Start;End;Installations Origin;Installations Destination;Origin Zone;Destination Zone;Origin Zone Id;Destination Zone Id;Entity Seller;Entity Buyer;Comments;Id\nSPA;Eni;Oxy;1.0;;DES;2025-01-01 00:00;2035-01-01 00:00;Bonny LNG;;Nigeria;World;185;899;NLNG;Oxy;2025 0.74 mtpa starting from 2026 1 mtpa. To be sourced from Train 7.;1620\nSPA;ExxonMobil;Pertamina;1.0;;FOB;2025-01-01 00:00;2045-12-31 00:00;;Nusantara, Arun;World;Indonesia;899;178;ExxonMobil;Pertamina;;2173\nSPA;Woodside;ENN;1.0;;FOB/DES;2025-01-01 00:00;2040-12-31 00:00;;Zhoushan, Dalian, Rudong;World;China;899;171;Woodside;ENN;HOA signed in April 2019.;3082\nSPA;LNG Canada;Vitol;0.8;;FOB/DES;2024-01-01 00:00;2037-12-31 00:00;;;World;World;899;899;LNG Canada;Vitol;Supply from LNG canada as well as other segments of the Petronas supply portfolio.;2921"},{"id":"75aff73a-acf1-44c8-8cb6-c4f635778873","name":"Columns id, name, description and deprecation status","originalRequest":{"method":"GET","header":[],"url":"https://api-lng.kpler.com/v1/contracts/columns"},"_postman_previewlanguage":"json","header":[],"cookie":[],"responseTime":null,"body":"{\n \"Columns by default\": [\n {\n \"id\": \"type\",\n \"shortId\": \"type\",\n \"columnName\": \"Type\",\n \"description\": \"Type of contract (SPA, LTA, TUA, Tender)\",\n \"deprecated\": false\n },\n {\n \"id\": \"seller\",\n \"shortId\": \"seller\",\n \"columnName\": \"Seller\",\n \"description\": \"Company name of the seller\",\n \"deprecated\": false\n },\n {\n \"id\": \"buyer\",\n \"shortId\": \"buyer\",\n \"columnName\": \"Buyer\",\n \"description\": \"Company name of the buyer\",\n \"deprecated\": false\n },\n {\n \"id\": \"capacity\",\n \"shortId\": \"capacity\",\n \"columnName\": \"Capacity\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"slots\",\n \"shortId\": \"slots\",\n \"columnName\": \"Slots\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"delivery\",\n \"shortId\": \"delivery\",\n \"columnName\": \"Delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' =The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"start\",\n \"shortId\": \"start\",\n \"columnName\": \"Start\",\n \"description\": \"Start date of the contract\",\n \"deprecated\": false\n },\n {\n \"id\": \"end\",\n \"shortId\": \"end\",\n \"columnName\": \"End\",\n \"description\": \"End date of the contract\",\n \"deprecated\": false\n },\n {\n \"id\": \"installations origin\",\n \"shortId\": \"installations origin\",\n \"columnName\": \"Installations Origin\",\n \"description\": \"Names of origin installations\",\n \"deprecated\": false\n },\n {\n \"id\": \"installations destination\",\n \"shortId\": \"installations destination\",\n \"columnName\": \"Installations Destination\",\n \"description\": \"Names of destination installations\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin zone\",\n \"shortId\": \"origin zone\",\n \"columnName\": \"Origin Zone\",\n \"description\": \"Origin zone\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination zone\",\n \"shortId\": \"destination zone\",\n \"columnName\": \"Destination Zone\",\n \"description\": \"Destination zone of cargo of cargo\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin zone id\",\n \"shortId\": \"origin zone id\",\n \"columnName\": \"Origin Zone Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination zone id\",\n \"shortId\": \"destination zone id\",\n \"columnName\": \"Destination Zone Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"entity seller\",\n \"shortId\": \"entity seller\",\n \"columnName\": \"Entity Seller\",\n \"description\": \"Entity selling the cargo\",\n \"deprecated\": false\n },\n {\n \"id\": \"entity buyer\",\n \"shortId\": \"entity buyer\",\n \"columnName\": \"Entity Buyer\",\n \"description\": \"Entity buying the cargo\",\n \"deprecated\": false\n },\n {\n \"id\": \"comments\",\n \"shortId\": \"comments\",\n \"columnName\": \"Comments\",\n \"description\": \"Comments\",\n \"deprecated\": false\n },\n {\n \"id\": \"id\",\n \"shortId\": \"id\",\n \"columnName\": \"Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n }\n ],\n \"Optional Columns\": []\n}"},{"id":"757616f3-cbb2-4de0-a900-f8281bfe3d34","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-lng.kpler.com/v1/contracts?hash=YOUR_HASH","protocol":"https","host":["api-lng","kpler","com"],"path":["v1","contracts"],"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":[],"cookie":[],"responseTime":null,"body":""}],"_postman_id":"6b3c6460-8ecb-43ef-adbc-875aae1ba765"},{"name":"/v1/contracts/columns","event":[{"listen":"test","script":{"exec":[""],"type":"text/javascript","id":"c6cc7fe8-212f-45f1-9e1c-9d6e68c9ef73"}},{"listen":"prerequest","script":{"exec":[""],"type":"text/javascript","id":"c0483f79-dbab-42d5-9c65-a86f6e4f91de"}}],"id":"7f266773-e3c7-4b1c-9e0f-4d2fd232fcfd","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"},{"description":"Required [String]: application/json or text/json
\n","key":"Content-Type","type":"text","value":"application/json"}],"body":{"mode":"raw","raw":"[\n \"seller\",\n \"capacity\",\n \"slots\"\n]"},"url":"https://api-lng.kpler.com/v1/contracts/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.
\nTherefore 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.
\nNote: The set of columns defined with the hash code will never change and will always remain the same.
\nIn this example, we have created a hash code that will always return the following columns:
\n- \n
- seller \n
- capacity \n
- slots \n
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-lng.kpler.com/v1/contracts/columns","description":"This endpoint returns a recent and updated list of all columns available for the endpoint contracts.
\n","urlObject":{"protocol":"https","path":["v1","contracts","columns"],"host":["api-lng","kpler","com"],"query":[],"variable":[]}},"response":[{"id":"7c84368c-3f1d-498e-8f68-78e36b7a8fcc","name":"List of 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-lng.kpler.com/v1/contracts/columns"},"_postman_previewlanguage":"json","header":[],"cookie":[],"responseTime":null,"body":"{\n \"selected\": [\n {\n \"id\": \"type\",\n \"shortId\": \"type\",\n \"columnName\": \"Type\",\n \"description\": \"Type of contract (SPA, LTA, TUA, Tender)\",\n \"deprecated\": false\n },\n {\n \"id\": \"seller\",\n \"shortId\": \"seller\",\n \"columnName\": \"Seller\",\n \"description\": \"Company name of the seller\",\n \"deprecated\": false\n },\n {\n \"id\": \"buyer\",\n \"shortId\": \"buyer\",\n \"columnName\": \"Buyer\",\n \"description\": \"Company name of the buyer\",\n \"deprecated\": false\n },\n {\n \"id\": \"capacity\",\n \"shortId\": \"capacity\",\n \"columnName\": \"Capacity\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"slots\",\n \"shortId\": \"slots\",\n \"columnName\": \"Slots\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"delivery\",\n \"shortId\": \"delivery\",\n \"columnName\": \"Delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' =The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"start\",\n \"shortId\": \"start\",\n \"columnName\": \"Start\",\n \"description\": \"Start date of the contract\",\n \"deprecated\": false\n },\n {\n \"id\": \"end\",\n \"shortId\": \"end\",\n \"columnName\": \"End\",\n \"description\": \"End date of the contract\",\n \"deprecated\": false\n },\n {\n \"id\": \"installations origin\",\n \"shortId\": \"installations origin\",\n \"columnName\": \"Installations Origin\",\n \"description\": \"Names of origin installations\",\n \"deprecated\": false\n },\n {\n \"id\": \"installations destination\",\n \"shortId\": \"installations destination\",\n \"columnName\": \"Installations Destination\",\n \"description\": \"Names of destination installations\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin zone\",\n \"shortId\": \"origin zone\",\n \"columnName\": \"Origin Zone\",\n \"description\": \"Origin zone\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination zone\",\n \"shortId\": \"destination zone\",\n \"columnName\": \"Destination Zone\",\n \"description\": \"Destination zone of cargo of cargo\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin zone id\",\n \"shortId\": \"origin zone id\",\n \"columnName\": \"Origin Zone Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination zone id\",\n \"shortId\": \"destination zone id\",\n \"columnName\": \"Destination Zone Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"entity seller\",\n \"shortId\": \"entity seller\",\n \"columnName\": \"Entity Seller\",\n \"description\": \"Entity selling the cargo\",\n \"deprecated\": false\n },\n {\n \"id\": \"entity buyer\",\n \"shortId\": \"entity buyer\",\n \"columnName\": \"Entity Buyer\",\n \"description\": \"Entity buying the cargo\",\n \"deprecated\": false\n },\n {\n \"id\": \"comments\",\n \"shortId\": \"comments\",\n \"columnName\": \"Comments\",\n \"description\": \"Comments\",\n \"deprecated\": false\n },\n {\n \"id\": \"id\",\n \"shortId\": \"id\",\n \"columnName\": \"Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n }\n ],\n \"unselected\": []\n}"}],"_postman_id":"73bc7989-7db4-40a8-8136-58a49b416bc9"}],"id":"b40a5a43-9571-42c9-b364-e4903a6019de","description":"The /Contracts endpoint allows you to extract a list of SPAs, TUAs, LTAs, and Tenders for all LNG players, installations and zones.
\nIn 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":{"type":"text/javascript","exec":[""],"id":"0f373bc8-017a-47a5-b6b5-d3e936ed3a73"}},{"listen":"test","script":{"type":"text/javascript","exec":[""],"id":"8e6d0b6c-e25f-41e4-9233-4d23fbb3686b"}}],"_postman_id":"b40a5a43-9571-42c9-b364-e4903a6019de","auth":{"type":"oauth2","oauth2":{"basicConfig":[],"advancedConfig":[{"key":"authRequestParams","value":"Required [String] : Token
\n","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":"https://api-lng.kpler.com/v1/outages?size={{size}}&zones={{zones}}&installations={{installations}}&startDate={{startDate}}&endDate={{endDate}}&outageTypes={{outageTypes}}&columns={{columns}}&hash={{hash}}","auth":{"type":"oauth2","oauth2":{"basicConfig":[],"advancedConfig":[{"key":"authRequestParams","value":"