![\"Alt](\"https://kp-prod-public-content.s3-eu-west-1.amazonaws.com/doc/trades_updates_1.gif\")
![\"Alt](\"https://kp-prod-public-content.s3-eu-west-1.amazonaws.com/doc/available-columns.gif\")
\n\nYou 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 :
\nEncode your email and password in base64
\n your_email@example.com:your_password = Y3VzdG9tZXJAZW1haWwuY29tOm1Zc3RSb25nUDRzc3cwUmQ=\n\nAdd your encoded credentials in the 'Authorization' header.
\n Authorization: Basic Y3VzdG9tZXJAZW1haWwuY29tOm1Zc3RSb25nUDRzc3cwUmQ=\n\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.
\npowershell \"[convert]::ToBase64String([Text.Encoding]::UTF8.GetBytes(\\\"YOUR_USERNAME:YOUR_PASSWORD\\\"))\"\n\nIf you have any problems with this section, please do not hesitate to contact us.
\nYou are able to generate custom code snippet by choosing your favorite language. You will find in this list all available programming languages.
\nRequired [string] : Content-Type \"application/json\"
\n","key":"Content-Type","name":"Content-Type","type":"text","value":"application/json"}],"body":{"mode":"raw","raw":"{\n\t\"email\": \"your_mail@example.com\",\n\t\"password\": \"your_password\"\n}"},"url":"https://api-lpg.kpler.com/v1/login","description":"curl --location --request POST \"https://api-lpg.kpler.com/v1/login\" \\\n --header \"Content-Type: application/json\" \\\n --data \"{\n \\\"email\\\": \\\"your_mail@example.com\\\",\n \\\"password\\\": \\\"your_password\\\"\n}\"\nAuthorization: Bearer YOUR_TOKEN\nRequired [String] : Token
\n","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":"https://api-lpg.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}}","urlObject":{"protocol":"https","path":["v1","trades"],"host":["api-lpg","kpler","com"],"query":[{"description":{"content":"Optional [Integer]: Maximum number of trades returned
\n","type":"text/plain"},"key":"size","value":"{{size}}"},{"description":{"content":"Optional [String]: Names/IMO's of vessels
\n","type":"text/plain"},"key":"vessels","value":"{{vessels}}"},{"description":{"content":"Optional [String]: Names of the origin installations
\n","type":"text/plain"},"key":"fromInstallations","value":"{{fromInstallations}}"},{"description":{"content":"Optional [String]: Names of the destination installations (terminal/refinery)
\n","type":"text/plain"},"key":"toInstallations","value":"{{toInstallations}}"},{"description":{"content":"Optional [String]: Names of the origin zones (port/region/country/continent)
\n","type":"text/plain"},"key":"fromZones","value":"{{fromZones}}"},{"description":{"content":"Optional [String]: Names of the destination zones (port/region/country/continent)
\n","type":"text/plain"},"key":"toZones","value":"{{toZones}}"},{"description":{"content":"Optional [String]: Buyers of the cargo
\n","type":"text/plain"},"key":"buyers","value":"{{buyers}}"},{"description":{"content":"Optional [String]: Sellers of the cargo
\n","type":"text/plain"},"key":"sellers","value":"{{sellers}}"},{"description":{"content":"Optional [String]: Names of products
\n","type":"text/plain"},"key":"products","value":"{{products}}"},{"description":{"content":"Optional [Date]: Origin Date: Start of the period (YYYY-MM-DD)
\n","type":"text/plain"},"key":"startDate","value":"{{startDate}}"},{"description":{"content":"Optional [Date]: Origin Date: End of the period (YYYY-MM-DD)
\n","type":"text/plain"},"key":"endDate","value":"{{endDate}}"},{"description":{"content":"Optional [String]: Return only trades of a particular status [“delivered”, ”loading”, ”in transit”, ”scheduled”].
\n","type":"text/plain"},"key":"tradeStatus","value":"{{tradeStatus}}"},{"description":{"content":"Optional [Date]: Destination Date: Start of the period (YYYY-MM-DD)
\n","type":"text/plain"},"key":"destinationStartDate","value":"{{destinationStartDate}}"},{"description":{"content":"Optional [Date]: Destination Date: End of the period (YYYY-MM-DD)
\n","type":"text/plain"},"key":"destinationEndDate","value":"{{destinationEndDate}}"},{"description":{"content":"Optional [String]: For given LPG vessel types\n
\nUse [\"SGC\", \"VLGC\", \"Handysize\", \"MGC\", \"LGC\", \"VLEC\"]\n
\nNote: Values are case sensitive
Optional [Boolean]: By default: withForecast=true. Include trades predicted by our in-house model when set to \"true\". Use [\"true\", \"false\"]
\n","type":"text/plain"},"key":"withForecast","value":"{{withForecast}}"},{"description":{"content":"Optional [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":"5ad7b1bd-bdc2-4cd1-8808-1846b40171a4","name":"Last 5 trades from Iran to China","originalRequest":{"method":"GET","header":[{"description":"Required [String] : Token","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":{"raw":"https://api-lpg.kpler.com/v1/trades?size=5&fromZones=iran&toZones=china&products=LPG","protocol":"https","host":["api-lpg","kpler","com"],"path":["v1","trades"],"query":[{"key":"size","value":"5","description":"Optional [String] : Maximum number of trades returned"},{"key":"fromZones","value":"iran","description":"Optional [String] : Names of the origin zones (port/region/country/continent)"},{"key":"toZones","value":"china","description":"Optional [String] : Names of the destination zones (port/region/country/continent)"},{"key":"products","value":"LPG","description":"Optional [String] : Names of products"}]}},"status":"OK","code":200,"_postman_previewlanguage":"Text","header":[],"cookie":[],"responseTime":null,"body":"Vessel;Cargo (tons);Grade;Product;Group;Family;Date (origin);Origin;Eta source (origin);Reload STS Partial (origin);Date (destination);Destination;Eta source (destination);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 m3);Vessel type;Cargo 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;Forecasted origin;Forecasted origin ETA;Forecasted origin confidence;Id (Voyage);Charterer\nGlobal Capricorn;43131;;;LPG;;2019-10-26 04:33;;;;;;;;China;2019-11-15 16:28;0.99;;;;;Scheduled;;;;;;;;;;;;;;;;78614;VLGC;Fully-Refrigerated;556;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;447558;;;;;;;;;;;Iran;2019-10-24 19:47;0.27;7853496;\nGlobal Scorpio;44182;;;LPG;;2019-09-09 19:19;;;;;;;;Longkou;2019-09-29 17:29;0.99;;;;;Scheduled;;Shandong Qiwangda;0;;;;;;;;;;;;;80530;VLGC;Fully-Refrigerated;666;CIF;Spot;;;Shandong Qiwangda;China;;;;;;;;;;;;;;;;;;;;;;;;;427598;;;;;;;;;;;Iran;2019-09-08 10:34;0.99;7846173;\nAddress Gas;43281;;;LPG;;2019-09-08 18:07;;;;;;;;China;2019-10-04 06:29;0.99;;;;;Scheduled;;;;;;;;;;;;;;;;78888;VLGC;Fully-Refrigerated;646;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;454256;;;;;;;;;;;Iran;2019-09-07 09:21;0.44;7856037;BGN\nSea Hermes;40535;;;LPG;;2019-09-07 12:59;Iran;Analyst;;;;;;China;2019-09-27 13:03;0.99;;;;;Scheduled;;;;Iran;Middle East;Asia;2019-09-05 00:00;;;;;;;;;73882;VLGC;Fully-Refrigerated;711;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;447453;Iran;224;;;;;;;;;;;;7853459;ASCA Maritime\nGas Sophia;41357;;;LPG;;2019-09-01 00:54;;;;;;;;Sinopec Fujian;2019-10-02 16:16;0.99;;;;;Scheduled;;Fujian Huaxing;0;;;;;;;;;;;;;75382;VLGC;Fully-Refrigerated;648;CIF;Spot;;;Fujian Huaxing;China;;;;;;;;;;;;;;;;;;;;;;;;;451587;;;;;;;;;;;Iran;2019-08-30 11:06;0.99;7855113;"},{"id":"07219ccc-6b58-49d8-a223-0b9241889e4b","name":"Columns id, name, description and deprecation status","originalRequest":{"method":"GET","header":[],"url":"https://api-lpg.kpler.com/v1/trades/columns"},"_postman_previewlanguage":"json","header":null,"cookie":[],"responseTime":null,"body":"{\n \"Columns by default\": [\n {\n \"id\": \"vessel_name\",\n \"shortId\": \"ven\",\n \"columnName\": \"Vessel\",\n \"description\": \"Name of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"cargo_origin_tons_split_by_product\",\n \"shortId\": \"cotsp\",\n \"columnName\": \"Cargo (tons)\",\n \"description\": \"Quantity (tons) loaded/discharged at the terminal\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_grade\",\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\": \"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\": \"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_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\": \"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\": \"voyage_id\",\n \"shortId\": \"voy\",\n \"columnName\": \"Id (Voyage)\",\n \"description\": \"Identifier in the database of Kpler\",\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 \"Optional Columns\": [\n {\n \"id\": \"cargo_sources\",\n \"shortId\": \"cargo_sources\",\n \"columnName\": \"Cargo Sources\",\n \"description\": null,\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\": \"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\": \"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\": \"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":"557c6e9d-eb4c-4a06-b476-ff3e559c3cb2","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-lpg.kpler.com/v1/trades?hash=YOUR_HASH","protocol":"https","host":["api-lpg","kpler","com"],"path":["v1","trades"],"query":[{"key":"hash","value":"YOUR_HASH","description":"Optional [String]: Generate your favorite set of columns using the hash ( Look at the next endpoint to learn more about how to generate the hash code )\n\n**Note:** You cannot use it simultaneously with the ‘columns’ parameter"}]}},"_postman_previewlanguage":"Text","header":null,"cookie":[],"responseTime":null,"body":null}],"_postman_id":"ef1279e1-f3af-4f8f-bb93-7624c9b59b87"},{"name":"/v1/trades/columns","event":[{"listen":"test","script":{"id":"45357501-e865-4575-93a1-03e1f674cba6","exec":[""],"type":"text/javascript"}},{"listen":"prerequest","script":{"id":"6dbc685c-7e4f-453b-969e-879642f01de7","exec":[""],"type":"text/javascript"}}],"id":"e020ee29-b968-4dc3-933b-8513725f6287","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 \"destination_location_name\",\n \"export_price\"\n]"},"url":"https://api-lpg.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:
\nRequired [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":"3a1d3fa4-9dbf-486a-9d32-2f347ef97594","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-lpg.kpler.com/v1/trades/columns"},"_postman_previewlanguage":"json","header":null,"cookie":[],"responseTime":null,"body":"{\n \"selected\": [\n {\n \"id\": \"vessel_name\",\n \"shortId\": \"ven\",\n \"columnName\": \"Vessel\",\n \"description\": \"Name of the vessel\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"cargo_origin_tons_split_by_product\",\n \"shortId\": \"cotsp\",\n \"columnName\": \"Cargo (tons)\",\n \"description\": \"Quantity (tons) loaded/discharged at the terminal\",\n \"deprecated\": false,\n \"type\": \"long\"\n },\n {\n \"id\": \"closest_ancestor_grade\",\n \"shortId\": \"cagrade\",\n \"columnName\": \"Grade\",\n \"description\": \"Product grade\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"closest_ancestor_product\",\n \"shortId\": \"capro\",\n \"columnName\": \"Product\",\n \"description\": \"Product type\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"closest_ancestor_group\",\n \"shortId\": \"cagroup\",\n \"columnName\": \"Group\",\n \"description\": \"Product group\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"closest_ancestor_family\",\n \"shortId\": \"cafam\",\n \"columnName\": \"Family\",\n \"description\": \"Product family\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"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\": \"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\": \"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\": \"vessel_capacity_cubic_meters\",\n \"shortId\": \"vcm\",\n \"columnName\": \"Capacity (vessel m3)\",\n \"description\": \"The maximum capacity of the vessel in cubic meters\",\n \"deprecated\": false,\n \"type\": \"long\"\n },\n {\n \"id\": \"vessel_type\",\n \"shortId\": \"vet\",\n \"columnName\": \"Vessel type\",\n \"description\": \"Type of the vessel 1\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"vessel_cargo_type\",\n \"shortId\": \"vct\",\n \"columnName\": \"Cargo type (vessel)\",\n \"description\": \"The specific cargo type of the vessel\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"vessel_id\",\n \"shortId\": \"vid\",\n \"columnName\": \"Id (vessel)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false,\n \"type\": \"long\"\n },\n {\n \"id\": \"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\": \"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\": \"voyage_id\",\n \"shortId\": \"voy\",\n \"columnName\": \"Id (Voyage)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false,\n \"type\": \"string\"\n },\n {\n \"id\": \"charterer_name\",\n \"shortId\": \"chn\",\n \"columnName\": \"Charterer\",\n \"description\": \"Current Controller of the vessel\",\n \"deprecated\": false,\n \"type\": \"string\"\n }\n ],\n \"unselected\": [\n {\n \"id\": \"cargo_sources\",\n \"shortId\": \"cargo_sources\",\n \"columnName\": \"Cargo Sources\",\n \"description\": null,\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\": \"closest_ancestor_grade_api\",\n \"shortId\": \"cagradeapi\",\n \"columnName\": \"Grade API\",\n \"description\": \"API grade of the product\",\n \"deprecated\": false,\n \"type\": \"float\"\n },\n {\n \"id\": \"closest_ancestor_grade_sulfur\",\n \"shortId\": \"cagradesulfur\",\n \"columnName\": \"Grade Sulfur\",\n \"description\": \"Sulfur grade of the product\",\n \"deprecated\": false,\n \"type\": \"float\"\n },\n {\n \"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\": \"cargo_origin_barrels_split_by_product\",\n \"shortId\": \"cobsp\",\n \"columnName\": \"Volume (bbl)\",\n \"description\": null,\n \"deprecated\": false,\n \"type\": \"long\"\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":"42ee8483-a22f-4e40-b3b4-1f5286a7aca9"},{"name":"/v1/trades/snapshot","event":[{"listen":"test","script":{"id":"3d8b9b2d-e1e4-4f67-80d3-afa9222329f7","exec":[""],"type":"text/javascript"}},{"listen":"prerequest","script":{"id":"a6202481-7d54-4275-94d2-3ffd06f08985","exec":[""],"type":"text/javascript"}}],"id":"44e14285-39dd-4ca2-9b0b-c4544b13627a","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-lpg.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":"Provides the last snapshot of all trades. The snapshot is a result of getTrades for all zones, vessels, and products, overall the history.
\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).
\nIt allows users to view the state of the trades at a specific point in time.
\nThe snapshots are stored daily on a regular basis since September 2020 (2020-09-21T200000), the date of the first snapshot can vary depending on the commodity queried. This is an add on feature, please reach out to your Account Manager for more details.
\nIf you want to use point-in-time data, you need to specify the snapshotDate parameter. The snapshotDate parameter is a date in the format YYYY-MM-DD that specifies the date for which you want to retrieve data. For example, to retrieve data for January 1, 2023, you would specify snapshotDate=2023-01-01.
It must be run at least once, for the initialization, before using /v1/trades/updates. Once the initialization step has been performed, /v1/trades/updates can be used alone.
\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/v1/trades/updates endpoint.What 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![](\"https://kp-prod-public-content.s3-eu-west-1.amazonaws.com/doc/trades_snapshot.gif\")
","urlObject":{"protocol":"https","path":["v1","trades","snapshot"],"host":["api-lpg","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":"802fd53c-0386-4d1a-a1ed-eb1a4ef3e3a0","name":"Get trades snapshot","originalRequest":{"method":"GET","header":[{"description":"Required [String] : Token","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":"https://api-lpg.kpler.com/v1/trades/snapshot"},"_postman_previewlanguage":null,"header":[{"key":"lastAvailableDate","value":"2020-10-27T140100","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"Vessel;Cargo (tons);Grade;Product;Group;Family;Date (origin);Origin;Eta source (origin);Reload STS Partial (origin);Date (destination);Destination;Eta source (destination);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 m3);Vessel type;Cargo 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;Forecasted origin;Forecasted origin ETA;Forecasted origin confidence;Id (Voyage);Charterer;Id (Product)\nTaugas;7092;;;olefins;;2021-02-11 09:45;;Model;;;;Model;;Europe;2021-03-28 06:09;0.75;;;;;Scheduled;;;;;;;;;;;;;;;;12000;SGC;Semi-Refrigerated;94567;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;1332771;;;;;;;;;;;ARA;2021-02-10 08:06;0.6;8271425;;2016\nOriental King;46086;;;LPG;;2021-01-22 12:21;;Model;;;;Model;;South Korea;2021-02-24 13:15;0.43;;;;;Scheduled;;;;;;;;;;;;;;;;84000;VLGC;Fully-Refrigerated;101938;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;1332827;;;;;;;;;;;Gulf of Mexico;2021-01-20 12:22;0.55;8271475;;1772\nGas Capricorn;43306;;;LPG;;2021-01-20 15:25;;Model;;;;Model;;Japan;2021-02-09 12:54;0.58;;;;;Scheduled;;;;;;;;;;;;;;;;78934;VLGC;Fully-Refrigerated;71662;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;1332671;;;;;;;;;;;Mideast Gulf;2021-01-19 10:24;0.43;8271329;;1772\nCorvette;46086;;;LPG;;2021-01-20 10:42;;Model;;;;Model;;Japan;2021-02-20 23:03;0.75;;;;;Scheduled;;;;;;;;;;;;;;;;84000;VLGC;Fully-Refrigerated;96058;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;1332981;;;;;;;;;;;Gulf of Mexico;2021-01-18 22:43;0.67;8271630;Equinor;1772\nJoan;2092;;;olefins;;2021-01-18 02:03;;Model;;;;Model;;ARA;2021-01-20 11:28;0.73;;;;;Scheduled;;;;;;;;;;;;;;;;3540;SGC;Pressurised;82818;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;1332725;;;;;;;;;;;North Sea;2021-01-16 22:57;0.72;8271382;;2016\nDoraji Gas;45537;;;LPG;;2021-01-17 18:24;;Model;;;;Model;;Asia;2021-02-20 04:46;0.99;;;;;Scheduled;;;;;;;;;;;;;;;;83000;VLGC;Fully-Refrigerated;99863;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;1333069;;;;;;;;;;;Gulf of Mexico;2021-01-15 18:24;0.5;8271715;Astomos;1772\n(truncated response)"},{"id":"fafb8373-f8c6-4bf3-a2be-dcb1cef17841","name":"Columns id, name, description and deprecation status","originalRequest":{"method":"GET","header":[],"url":"https://api-lpg.kpler.com/v1/trades/snapshot/columns"},"_postman_previewlanguage":"json","header":null,"cookie":[],"responseTime":null,"body":"{\n \"Columns by default\": [\n {\n \"id\": \"vessel_name\",\n \"shortId\": \"ven\",\n \"columnName\": \"Vessel\",\n \"description\": \"Name of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"cargo_origin_barrels_split_by_product\",\n \"shortId\": \"cobsp\",\n \"columnName\": \"Volume (bbl)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_grade\",\n \"shortId\": \"cagrade\",\n \"columnName\": \"Grade\",\n \"description\": \"Product grade\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_product\",\n \"shortId\": \"capro\",\n \"columnName\": \"Product\",\n \"description\": \"Product type\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_group\",\n \"shortId\": \"cagroup\",\n \"columnName\": \"Group\",\n \"description\": \"Product group\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_family\",\n \"shortId\": \"cafam\",\n \"columnName\": \"Family\",\n \"description\": \"Product family\",\n \"deprecated\": false\n },\n {\n \"id\": \"start\",\n \"shortId\": \"str\",\n \"columnName\": \"Date (origin)\",\n \"description\": \"Departure date of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_location_name\",\n \"shortId\": \"oln\",\n \"columnName\": \"Origin\",\n \"description\": \"Origin location of the cargo\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_eta_source\",\n \"shortId\": \"oes\",\n \"columnName\": \"Eta source (origin)\",\n \"description\": \"Source of the Estimated Time of Arrival to the Installation of Origin information (Port, Analyst, etc.)\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_reload_sts_partial\",\n \"shortId\": \"ota\",\n \"columnName\": \"Reload STS Partial (origin)\",\n \"description\": \"If field contains 'Partial' = Partial has occurred in this port call. Same logic applies for when “Reload” and 'STS' is returned for Re-loads and Ship-to-Ship transfers\",\n \"deprecated\": false\n },\n {\n \"id\": \"end\",\n \"shortId\": \"end\",\n \"columnName\": \"Date (destination)\",\n \"description\": \"Arrival date of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_location_name\",\n \"shortId\": \"dln\",\n \"columnName\": \"Destination\",\n \"description\": \"Destination location of the cargo\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_eta_source\",\n \"shortId\": \"des\",\n \"columnName\": \"Eta source (destination)\",\n \"description\": \"Source of the Estimated Time of Arrival to the Installation of Destination information (Port, Analyst, etc.)\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_reload_sts_partial\",\n \"shortId\": \"dta\",\n \"columnName\": \"Reload STS Partial (destination)\",\n \"description\": \"If field contains 'Partial' then Partial has occurred in this port call. Same logic applies for when 'Reload' and 'STS' is returned for Re-loads and Ship-to-Ship transfers.\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_destination_location_name\",\n \"shortId\": \"fdl\",\n \"columnName\": \"Forecasted destination\",\n \"description\": \"Next destination forecasted\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_destination_location_eta\",\n \"shortId\": \"fde\",\n \"columnName\": \"Forecasted ETA\",\n \"description\": \"Next destination ETA forecasted\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_destination_confidence\",\n \"shortId\": \"fdc\",\n \"columnName\": \"Forecasted confidence\",\n \"description\": \"Confidence (in %) of the system forecast\",\n \"deprecated\": false\n },\n {\n \"id\": \"status\",\n \"shortId\": \"stt\",\n \"columnName\": \"Trade status\",\n \"description\": \"'Scheduled' = cargo has not been picked up yet. 'In Transit' = cargo is in movement. 'Delivered' = cargo arrived to destination.\",\n \"deprecated\": false\n },\n {\n \"id\": \"initial_seller_name\",\n \"shortId\": \"isn\",\n \"columnName\": \"Seller (origin)\",\n \"description\": \"Company name that sold cargo at the installation of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"final_buyer_name\",\n \"shortId\": \"fbn\",\n \"columnName\": \"Buyer (destination)\",\n \"description\": \"Company name of the buyer at final destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"number_of_intermediaries\",\n \"shortId\": \"noi\",\n \"columnName\": \"Intermediaries\",\n \"description\": \"Number of intermediate players involved in the trade\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_country_name\",\n \"shortId\": \"ocn\",\n \"columnName\": \"Country (origin)\",\n \"description\": \"Name of the origin country\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_subcontinent_name\",\n \"shortId\": \"osn\",\n \"columnName\": \"Subcontinent (origin)\",\n \"description\": \"Subcontinent of trade origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"continent_origin_name\",\n \"shortId\": \"con\",\n \"columnName\": \"Continent Origin\",\n \"description\": \"Continent of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_eta_date\",\n \"shortId\": \"oed\",\n \"columnName\": \"Eta (origin)\",\n \"description\": \"Estimated time of arrival at origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_start\",\n \"shortId\": \"ost\",\n \"columnName\": \"Start (origin)\",\n \"description\": \"Start date of the trip\",\n \"deprecated\": false\n },\n {\n \"id\": \"origin_end\",\n \"shortId\": \"oen\",\n \"columnName\": \"End (origin)\",\n \"description\": \"End of the loading process at the origin \",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_country_name\",\n \"shortId\": \"dcn\",\n \"columnName\": \"Country (destination)\",\n \"description\": \"Name of the destination country\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_subcontinent_name\",\n \"shortId\": \"dsn\",\n \"columnName\": \"Subcontinent (destination)\",\n \"description\": \"Subcontinent of trade destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"continent_destination_name\",\n \"shortId\": \"cdn\",\n \"columnName\": \"Continent Destination\",\n \"description\": \"Continent of destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_eta\",\n \"shortId\": \"ded\",\n \"columnName\": \"Eta (destination)\",\n \"description\": \"Estimated time of arrival at destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_start\",\n \"shortId\": \"dsd\",\n \"columnName\": \"Start (destination)\",\n \"description\": \"Start of the discharge process at destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"destination_end\",\n \"shortId\": \"den\",\n \"columnName\": \"End (destination)\",\n \"description\": \"Departure datetime from the destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_capacity_cubic_meters\",\n \"shortId\": \"vcm\",\n \"columnName\": \"Capacity (vessel m3)\",\n \"description\": \"The maximum capacity of the vessel in cubic meters\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_type\",\n \"shortId\": \"vet\",\n \"columnName\": \"Vessel type\",\n \"description\": \"Type of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_cargo_type\",\n \"shortId\": \"vct\",\n \"columnName\": \"Cargo type (vessel)\",\n \"description\": \"The specific cargo type of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_id\",\n \"shortId\": \"vid\",\n \"columnName\": \"Id (vessel)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_id\",\n \"shortId\": \"tid\",\n \"columnName\": \"Id (Trade)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"zone_origin_name\",\n \"shortId\": \"zon\",\n \"columnName\": \"Zone Origin\",\n \"description\": \"Name of the origin area\",\n \"deprecated\": false\n },\n {\n \"id\": \"zone_origin_id\",\n \"shortId\": \"zoi\",\n \"columnName\": \"Zone Origin Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"zone_destination_name\",\n \"shortId\": \"zdn\",\n \"columnName\": \"Zone Destination\",\n \"description\": \"Name of the destination area\",\n \"deprecated\": false\n },\n {\n \"id\": \"zone_destination_id\",\n \"shortId\": \"zdi\",\n \"columnName\": \"Zone Destination Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_origin_name\",\n \"shortId\": \"ion\",\n \"columnName\": \"Installation origin\",\n \"description\": \"Name of the origin installation\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_origin_id\",\n \"shortId\": \"ioi\",\n \"columnName\": \"Installation origin id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_destination_name\",\n \"shortId\": \"idn\",\n \"columnName\": \"Installation Destination\",\n \"description\": \"Name of the destination installation\",\n \"deprecated\": false\n },\n {\n \"id\": \"installation_destination_id\",\n \"shortId\": \"idi\",\n \"columnName\": \"Installation Destination Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"mileage_nautical_miles\",\n \"shortId\": \"mnm\",\n \"columnName\": \"Mileage\",\n \"description\": \"Distance between origin and destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"ton_miles\",\n \"shortId\": \"tom\",\n \"columnName\": \"Ton Miles\",\n \"description\": \"Ton/mile report\",\n \"deprecated\": false\n },\n {\n \"id\": \"voyage_id\",\n \"shortId\": \"voy\",\n \"columnName\": \"Id (Voyage)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n }\n ],\n \"Optional Columns\": [\n {\n \"id\": \"cargo_origin_tons_split_by_product\",\n \"shortId\": \"cotsp\",\n \"columnName\": \"Cargo (tons)\",\n \"description\": \"Quantity (tons) loaded/discharged at the terminal\",\n \"deprecated\": false\n },\n {\n \"id\": \"cargo_sources\",\n \"shortId\": \"cargo_sources\",\n \"columnName\": \"Cargo Sources\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"charterer_name\",\n \"shortId\": \"chn\",\n \"columnName\": \"Charterer\",\n \"description\": \"Current Controller of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_country_1\",\n \"shortId\": \"stco1\",\n \"columnName\": \"Country STS 1\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_country_2\",\n \"shortId\": \"stco2\",\n \"columnName\": \"Country STS 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_country_3\",\n \"shortId\": \"stco3\",\n \"columnName\": \"Country STS 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_end_date1\",\n \"shortId\": \"sted1\",\n \"columnName\": \"Date End STS 1\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_end_date2\",\n \"shortId\": \"sted2\",\n \"columnName\": \"Date End STS 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_end_date3\",\n \"shortId\": \"sted3\",\n \"columnName\": \"Date End STS 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_start_date_1\",\n \"shortId\": \"stsd1\",\n \"columnName\": \"Date Start STS 1\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_start_date_2\",\n \"shortId\": \"stsd2\",\n \"columnName\": \"Date Start STS 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_start_date_3\",\n \"shortId\": \"stsd3\",\n \"columnName\": \"Date Start STS 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"port_call_destination_id\",\n \"shortId\": \"pcdid\",\n \"columnName\": \"Destination PortCall Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"export_price\",\n \"shortId\": \"epr\",\n \"columnName\": \"Export price\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_origin_location_name\",\n \"shortId\": \"fol\",\n \"columnName\": \"Forecasted origin\",\n \"description\": \"Next origin forecasted\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_origin_eta\",\n \"shortId\": \"foe\",\n \"columnName\": \"Forecasted origin ETA\",\n \"description\": \"Next origin ETA forecasted\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_forecasted_origin_confidence\",\n \"shortId\": \"foc\",\n \"columnName\": \"Forecasted origin confidence\",\n \"description\": \"Confidence (in %) of the system forecast\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_grade_api\",\n \"shortId\": \"cagradeapi\",\n \"columnName\": \"Grade API\",\n \"description\": \"API grade of the product\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_grade_sulfur\",\n \"shortId\": \"cagradesulfur\",\n \"columnName\": \"Grade Sulfur\",\n \"description\": \"Sulfur grade of the product\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_imo\",\n \"shortId\": \"imo\",\n \"columnName\": \"IMO (vessel)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"product_id\",\n \"shortId\": \"proid\",\n \"columnName\": \"Id (Product)\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"import_price\",\n \"shortId\": \"ipr\",\n \"columnName\": \"Import price\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"ship_to_ship_installation_1\",\n \"shortId\": \"stsi1\",\n \"columnName\": \"Installation STS 1\",\n \"description\": \"Ship to ship installation\",\n \"deprecated\": false\n },\n {\n \"id\": \"ship_to_ship_installation_2\",\n \"shortId\": \"stsi2\",\n \"columnName\": \"Installation STS 2\",\n \"description\": \"Ship to ship installation\",\n \"deprecated\": false\n },\n {\n \"id\": \"ship_to_ship_installation_3\",\n \"shortId\": \"stsi3\",\n \"columnName\": \"Installation STS 3\",\n \"description\": \"Ship to ship installation\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_buyer_country_name\",\n \"shortId\": \"b1c\",\n \"columnName\": \"Link1 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_buyer_name\",\n \"shortId\": \"n1b\",\n \"columnName\": \"Link1 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_delivery\",\n \"shortId\": \"t1d\",\n \"columnName\": \"Link1 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_seller_country_name\",\n \"shortId\": \"s1c\",\n \"columnName\": \"Link1 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_seller_name\",\n \"shortId\": \"s1n\",\n \"columnName\": \"Link1 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_1_type\",\n \"shortId\": \"t1t\",\n \"columnName\": \"Link1 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_buyer_country_name\",\n \"shortId\": \"b2c\",\n \"columnName\": \"Link2 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_buyer_name\",\n \"shortId\": \"n2b\",\n \"columnName\": \"Link2 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_delivery\",\n \"shortId\": \"t2d\",\n \"columnName\": \"Link2 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_seller_country_name\",\n \"shortId\": \"s2c\",\n \"columnName\": \"Link2 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_seller_name\",\n \"shortId\": \"s2n\",\n \"columnName\": \"Link2 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_2_type\",\n \"shortId\": \"t2t\",\n \"columnName\": \"Link2 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_buyer_country_name\",\n \"shortId\": \"b3c\",\n \"columnName\": \"Link3 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_buyer_name\",\n \"shortId\": \"n3b\",\n \"columnName\": \"Link3 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_delivery\",\n \"shortId\": \"t3d\",\n \"columnName\": \"Link3 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_seller_country_name\",\n \"shortId\": \"s3c\",\n \"columnName\": \"Link3 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_seller_name\",\n \"shortId\": \"s3n\",\n \"columnName\": \"Link3 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_3_type\",\n \"shortId\": \"t3t\",\n \"columnName\": \"Link3 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_buyer_country_name\",\n \"shortId\": \"b4c\",\n \"columnName\": \"Link4 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_buyer_name\",\n \"shortId\": \"n4b\",\n \"columnName\": \"Link4 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_delivery\",\n \"shortId\": \"t4d\",\n \"columnName\": \"Link4 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_seller_country_name\",\n \"shortId\": \"s4c\",\n \"columnName\": \"Link4 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_seller_name\",\n \"shortId\": \"s4n\",\n \"columnName\": \"Link4 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_4_type\",\n \"shortId\": \"t4t\",\n \"columnName\": \"Link4 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_buyer_country_name\",\n \"shortId\": \"b5c\",\n \"columnName\": \"Link5 buyer country\",\n \"description\": \"Cargo’s buyer country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_buyer_name\",\n \"shortId\": \"n5b\",\n \"columnName\": \"Link5 buyer name\",\n \"description\": \"Cargo’s buyer name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_delivery\",\n \"shortId\": \"t5d\",\n \"columnName\": \"Link5 delivery\",\n \"description\": \"'FOB' =The trade is Free on Board. 'DES' = The trade is Delivery EX Shipped\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_seller_country_name\",\n \"shortId\": \"s5c\",\n \"columnName\": \"Link5 seller country\",\n \"description\": \"Cargo’s seller country of origin\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_seller_name\",\n \"shortId\": \"s5n\",\n \"columnName\": \"Link5 seller name\",\n \"description\": \"Cargo’s seller name\",\n \"deprecated\": false\n },\n {\n \"id\": \"trade_link_5_type\",\n \"shortId\": \"t5t\",\n \"columnName\": \"Link5 type\",\n \"description\": \"Type of trade (contract, portfolio, group, ...)\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_mmsi\",\n \"shortId\": \"msi\",\n \"columnName\": \"MMSI (vessel)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"export_number_of_trades\",\n \"shortId\": \"ent\",\n \"columnName\": \"Number of trades (export)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"import_number_of_trades\",\n \"shortId\": \"int\",\n \"columnName\": \"Number of trades (import)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"port_call_origin_id\",\n \"shortId\": \"pcoid\",\n \"columnName\": \"Origin PortCall Id\",\n \"description\": \"Identifier in the database of Kpler\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_dwt_1\",\n \"shortId\": \"dwt1\",\n \"columnName\": \"Vessel DWT\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_dwt_2\",\n \"shortId\": \"dwt2\",\n \"columnName\": \"Vessel DWT 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_dwt_3\",\n \"shortId\": \"dwt3\",\n \"columnName\": \"Vessel DWT 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_dwt_4\",\n \"shortId\": \"dwt4\",\n \"columnName\": \"Vessel DWT 4\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_imo_2\",\n \"shortId\": \"imo2\",\n \"columnName\": \"Vessel IMO 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_imo_3\",\n \"shortId\": \"imo3\",\n \"columnName\": \"Vessel IMO 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_imo_4\",\n \"shortId\": \"imo4\",\n \"columnName\": \"Vessel IMO 4\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_id_2\",\n \"shortId\": \"vid2\",\n \"columnName\": \"Vessel Id 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_id_3\",\n \"shortId\": \"vid3\",\n \"columnName\": \"Vessel Id 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_id_4\",\n \"shortId\": \"vid4\",\n \"columnName\": \"Vessel Id 4\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_name_2\",\n \"shortId\": \"ven2\",\n \"columnName\": \"Vessel Name 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_name_3\",\n \"shortId\": \"ven3\",\n \"columnName\": \"Vessel Name 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_name_4\",\n \"shortId\": \"ven4\",\n \"columnName\": \"Vessel Name 4\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"ship_to_ship_volume_1\",\n \"shortId\": \"stsv1\",\n \"columnName\": \"Volume STS 1\",\n \"description\": \"Ship to ship volume\",\n \"deprecated\": false\n },\n {\n \"id\": \"ship_to_ship_volume_2\",\n \"shortId\": \"stsv2\",\n \"columnName\": \"Volume STS 2\",\n \"description\": \"Ship to ship volume\",\n \"deprecated\": false\n },\n {\n \"id\": \"ship_to_ship_volume_3\",\n \"shortId\": \"stsv3\",\n \"columnName\": \"Volume STS 3\",\n \"description\": \"Ship to ship volume\",\n \"deprecated\": false\n },\n {\n \"id\": \"voyage_id_2\",\n \"shortId\": \"voyage_id_2\",\n \"columnName\": \"Voyage Id 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"voyage_id_3\",\n \"shortId\": \"voyage_id_3\",\n \"columnName\": \"Voyage Id 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"voyage_id_4\",\n \"shortId\": \"voyage_id_4\",\n \"columnName\": \"Voyage Id 4\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"zone_canal_transit\",\n \"shortId\": \"zct\",\n \"columnName\": \"Zone Canal Transit\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_zone_1\",\n \"shortId\": \"st1\",\n \"columnName\": \"Zone STS 1\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_zone_2\",\n \"shortId\": \"st2\",\n \"columnName\": \"Zone STS 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_zone_3\",\n \"shortId\": \"st3\",\n \"columnName\": \"Zone STS 3\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_zone_1_id\",\n \"shortId\": \"stzid1\",\n \"columnName\": \"Zone STS Id 1\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_zone_2_id\",\n \"shortId\": \"stzid2\",\n \"columnName\": \"Zone STS Id 2\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"super_trade_zone_3_id\",\n \"shortId\": \"stzid3\",\n \"columnName\": \"Zone STS Id 3\",\n \"description\": null,\n \"deprecated\": false\n }\n ]\n}"},{"id":"1ba8fce3-e0f8-4d43-ac10-5744df40a9b4","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-lpg.kpler.com/v1/trades/snapshot?snapshotDate=2020-09-25T020000","protocol":"https","host":["api-lpg","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":null,"header":null,"cookie":[],"responseTime":null,"body":null}],"_postman_id":"44e14285-39dd-4ca2-9b0b-c4544b13627a"},{"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":"316f415b-970c-4d50-ad75-7e9dcd6314d2","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-lpg.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","urlObject":{"protocol":"https","path":["v1","trades","snapshot","list"],"host":["api-lpg","kpler","com"],"query":[{"description":{"content":"Required [Date]: Start of the period (YYYY-MM-DD)
\n","type":"text/plain"},"key":"startDate","value":"{{startDate}}"},{"description":{"content":"Required [Date]: End of the period (YYYY-MM-DD)
\n","type":"text/plain"},"key":"endDate","value":"{{endDate}}"}],"variable":[]}},"response":[{"id":"12923b17-65a1-4ad2-8095-6bf75917aa8f","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-lpg.kpler.com/v1/trades/snapshot/list?startDate=2023-05-01&endDate=2023-05-05","protocol":"https","host":["api-lpg","kpler","com"],"path":["v1","trades","snapshot","list"],"query":[{"key":"startDate","value":"2023-05-01","description":"Optional [Date]: Start of the period (YYYY-MM-DD)"},{"key":"endDate","value":"2023-05-05","description":"Optional [Date]: End of the period (YYYY-MM-DD)"}]}},"status":"OK","code":200,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Wed, 10 May 2023 15:51:52 GMT"},{"key":"Content-Type","value":"text/csv; charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"Vary","value":"*,Accept-Encoding"},{"key":"Pragma","value":"no-cache"},{"key":"Cache-Control","value":"private, no-cache, no-store, must-revalidate, max-age=0, proxy-revalidate, s-maxage=0, Expires: Sat, 12 Oct 1991 05:00:00 GMT"},{"key":"Content-Encoding","value":"gzip"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"X-Kong-Upstream-Latency","value":"640"},{"key":"X-Kong-Proxy-Latency","value":"1"},{"key":"Via","value":"kong/3.2.1.0-enterprise-edition"}],"cookie":[],"responseTime":null,"body":"2023-05-01T000100\n2023-05-01T010100\n2023-05-01T020100\n2023-05-01T030100\n2023-05-01T040100\n2023-05-01T050100\n2023-05-01T060100\n2023-05-01T070100\n2023-05-01T080100\n2023-05-01T090100\n2023-05-01T100100\n2023-05-01T110100\n2023-05-01T120100\n2023-05-01T130100\n2023-05-01T140100\n2023-05-01T150100\n2023-05-01T160100\n2023-05-01T170100\n2023-05-01T180000\n2023-05-01T190100\n2023-05-01T200100\n2023-05-01T210100\n2023-05-01T220100\n2023-05-01T230100\n2023-05-02T000100\n2023-05-02T010100\n2023-05-02T020100\n2023-05-02T030100\n2023-05-02T040100\n2023-05-02T050100\n2023-05-02T060100\n2023-05-02T070100\n2023-05-02T080100\n2023-05-02T090100\n2023-05-02T100100\n2023-05-02T110100\n2023-05-02T120100\n2023-05-02T130100\n2023-05-02T140100\n2023-05-02T150100\n2023-05-02T160100\n2023-05-02T170100\n2023-05-02T180100\n2023-05-02T190100\n2023-05-02T200100\n2023-05-02T210100\n2023-05-02T220100\n2023-05-02T230100\n2023-05-03T000100\n2023-05-03T010100\n2023-05-03T020100\n2023-05-03T030100\n2023-05-03T040100\n2023-05-03T050100\n2023-05-03T060100\n2023-05-03T070100\n2023-05-03T080100\n2023-05-03T090100\n2023-05-03T100100\n2023-05-03T110100\n2023-05-03T120100\n2023-05-03T130000\n2023-05-03T140100\n2023-05-03T150100\n2023-05-03T160100\n2023-05-03T170100\n2023-05-03T180100\n2023-05-03T190100\n2023-05-03T200100\n2023-05-03T210100\n2023-05-03T220100\n2023-05-03T230100\n2023-05-04T000100\n2023-05-04T010100\n2023-05-04T020100\n2023-05-04T030100\n2023-05-04T040100\n2023-05-04T050100\n2023-05-04T060100\n2023-05-04T070100\n2023-05-04T080100\n2023-05-04T090100\n2023-05-04T100100\n2023-05-04T110100\n2023-05-04T120100\n2023-05-04T130100\n2023-05-04T140100\n2023-05-04T150100\n2023-05-04T160100\n2023-05-04T170100\n2023-05-04T180100\n2023-05-04T190100\n2023-05-04T200100\n2023-05-04T210000\n2023-05-04T220100\n2023-05-04T230100\n2023-05-05T000100\n2023-05-05T010100\n2023-05-05T020100\n2023-05-05T030100\n2023-05-05T040000\n2023-05-05T050100\n2023-05-05T060100\n2023-05-05T070100\n2023-05-05T080000\n2023-05-05T090100\n2023-05-05T100100\n2023-05-05T110100\n2023-05-05T120100\n2023-05-05T130100\n2023-05-05T140100\n2023-05-05T150100\n2023-05-05T160100\n2023-05-05T170100\n2023-05-05T180100\n2023-05-05T190100\n2023-05-05T200100\n2023-05-05T210100\n2023-05-05T220100\n2023-05-05T230100"}],"_postman_id":"316f415b-970c-4d50-ad75-7e9dcd6314d2"},{"name":"/v1/trades/updates","event":[{"listen":"test","script":{"id":"08125df4-db02-45d7-8380-d7be6a5c6524","exec":[""],"type":"text/javascript"}},{"listen":"prerequest","script":{"id":"f27eee9c-9c30-4b11-bd55-d9230fe6d9a0","exec":[""],"type":"text/javascript"}}],"id":"3350b8f7-e2f8-4f2e-be76-45dad23d908d","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-lpg.kpler.com/v1/trades/updates?startDate={{startDate}}&showAllHistory={{showAllHistory}}&columns={{columns}}&hash={{hash}}&products={{products}}","description":"Returns the delta in trades that happened since the startDate mandatory parameter, until a point in time. That point in time is returned in the lastAvailableDate response header.
\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.
NOTE:
\n/v1/trades/snapshot once to initialize your data store/ data lake/ data warehouse, and schedule the call to /v1/trades/snapshot is more optimal than calling /v1/trades lot of times. Further more calling /v1/trades won't prevent you from inconsistency in data as it's a live endpoint.The lastAvailableSnapshot is 2020-10-28T130100. Therefore, the update is to be run against another snapshot prior to this date. Here, we used 2020-10-28T120000, prior to lastAvailableSnapshot provided by /v1/trades/snapshot earlier.
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\nThe 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\nHow showAllHistory parameter works?
This parameter is meant to provide the different states of the data over time.
\ne.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.
\ne.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
\nshowAllHistory set to false
\nExample 2
\nshowAllHistory set to true
\nshowAllHistory set to false
\nNOTE: 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-lpg","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}}"},{"description":{"content":"Optional [String]: Names of products
\n","type":"text/plain"},"key":"products","value":"{{products}}"}],"variable":[]}},"response":[{"id":"5c2cc626-17d8-42d3-8589-a0d254403c36","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-lpg.kpler.com/v1/trades/updates?startDate=2020-01-01T090721","protocol":"https","host":["api-lpg","kpler","com"],"path":["v1","trades","updates"],"query":[{"key":"startDate","value":"2020-01-01T090721"}]}},"_postman_previewlanguage":null,"header":[{"key":"lastAvailableDate","value":"2020-10-27T130100","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"productId;tradeId;date;operation;jsonUpdates\n2016;1323567;2020-10-29T040100;UPDATE;{\"Date (destination)\":\"2020-10-31 03:18\",\"Eta (destination)\":\"2020-10-30 11:00\"}\n1266;1306319;2020-10-28T150100;DELETE;\n2016;1330094;2020-10-28T150100;DELETE;\n1482;765824;2020-10-29T080100;DELETE;\n1482;765824;2020-10-29T100100;INSERT;{\"Vessel\":\"Lady Gas\",\"Country (origin)\":\"South Korea\",\"Zone Origin\":\"Ulsan\",\"Installation origin\":\"Vopak Ulsan\",\"End (origin)\":\"2018-04-18 11:01\",\"Id (Voyage)\":\"7934755\",\"Zone Origin Id\":\"2527\",\"Installation origin id\":\"2986\",\"Continent Origin\":\"Asia\",\"Date (origin)\":\"2018-04-18 11:01\",\"Origin\":\"Vopak Ulsan\",\"Reload STS Partial (origin)\":\"Partial\",\"Date (destination)\":\"2018-04-26 12:01\",\"Trade status\":\"Delivered\",\"Subcontinent (origin)\":\"Eastern Asia\",\"Start (origin)\":\"2018-04-17 19:43\",\"Capacity (vessel m3)\":\"3516\",\"Vessel type\":\"SGC\",\"Cargo type (vessel)\":\"Pressurised\",\"Id (vessel)\":\"70597\",\"Charterer\":\"Myungshin\",\"Cargo (tons)\":\"1928\"}\n1772;1330565;2020-10-28T210100;INSERT;{\"Vessel\":\"Moritz\",\"Country (origin)\":\"Venezuela\",\"Zone Origin\":\"Port of Jose\",\"Installation origin\":\"Jose Antonio\",\"Group\":\"LPG\",\"Id (Voyage)\":\"8269404\",\"Zone Origin Id\":\"1222\",\"Installation origin id\":\"2550\",\"Continent Origin\":\"Americas\",\"Date (origin)\":\"2020-10-29 16:41\",\"Origin\":\"Jose Antonio\",\"Trade status\":\"Loading\",\"Seller (origin)\":\"PDVSA\",\"Intermediaries\":\"0\",\"Subcontinent (origin)\":\"South America\",\"Start (origin)\":\"2020-10-28 14:05\",\"Capacity (vessel m3)\":\"18152\",\"Vessel type\":\"Handysize\",\"Cargo type (vessel)\":\"Fully-Refrigerated\",\"Id (vessel)\":\"66656\",\"Link1 delivery\":\"FOB\",\"Link1 type\":\"Spot\",\"Link1 seller name\":\"PDVSA\",\"Link1 seller country\":\"Venezuela\",\"Cargo (tons)\":\"9959\",\"Forecasted destination\":\"Venezuela\",\"Forecasted ETA\":\"2020-10-31 08:52\",\"Forecasted confidence\":\"0.99\",\"Eta source (destination)\":\"Model\"}\n(truncated response)"},{"id":"137a207d-aecd-4d25-8b88-801d37bd215a","name":"Columns id, name, description and deprecation status","originalRequest":{"method":"GET","header":[],"url":"https://api-lpg.kpler.com/v1/trades/updates/columns"},"_postman_previewlanguage":"json","header":null,"cookie":[],"responseTime":null,"body":"{\n \"Columns by default\": [\n {\n \"id\": \"vessel_name\",\n \"shortId\": \"ven\",\n \"columnName\": \"Vessel\",\n \"description\": \"Name of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"cargo_origin_tons_split_by_product\",\n \"shortId\": \"cotsp\",\n \"columnName\": \"Cargo (tons)\",\n \"description\": \"Quantity (tons) loaded/discharged at the terminal\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_grade\",\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\": \"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\": \"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_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\": \"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\": \"voyage_id\",\n \"shortId\": \"voy\",\n \"columnName\": \"Id (Voyage)\",\n \"description\": \"Identifier in the database of Kpler\",\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 \"Optional Columns\": [\n {\n \"id\": \"cargo_sources\",\n \"shortId\": \"cargo_sources\",\n \"columnName\": \"Cargo Sources\",\n \"description\": null,\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\": \"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\": \"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\": \"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":"3350b8f7-e2f8-4f2e-be76-45dad23d908d"}],"id":"b31a1dfa-c518-4d66-9710-2d82c5507a5d","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":{"id":"405652fc-0d90-4e48-aed6-2279fafcfa4d","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"2e196f57-912c-4b42-810c-22a119522e37","type":"text/javascript","exec":[""]}}],"_postman_id":"b31a1dfa-c518-4d66-9710-2d82c5507a5d","auth":{"type":"oauth2","oauth2":{"basicConfig":[]},"isInherited":true,"source":{"_postman_id":"84efbd19-6781-4c01-b037-8afc85d91733","id":"84efbd19-6781-4c01-b037-8afc85d91733","name":"LPG API Direct Access User Guide","type":"collection"}}},{"name":"Vessels","item":[{"name":"/v1/vessels","event":[{"listen":"test","script":{"id":"e139e277-20d5-4e9a-898a-98365e81b00d","exec":[""],"type":"text/javascript"}},{"listen":"prerequest","script":{"id":"6685f7ad-53d1-4082-9d9b-4abcb30fe489","exec":[""],"type":"text/javascript"}}],"id":"9182a24e-9c83-41a8-8b69-1d03e4a471c4","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"description":"Required [String] : Token
\n","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":"https://api-lpg.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:
\nRetrieve 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":"0f9e57ad-0741-4d71-9dbc-ed34e06da2e2","name":"Columns id, name, description and deprecation status","originalRequest":{"method":"GET","header":[],"url":"https://api-lpg.kpler.com/v1/vessels/columns"},"_postman_previewlanguage":"json","header":null,"cookie":[],"responseTime":null,"body":"{\n \"Columns by default\": [\n {\n \"id\": \"vessel_name\",\n \"shortId\": \"vna\",\n \"columnName\": \"Name\",\n \"description\": \"Name of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_status\",\n \"shortId\": \"sta\",\n \"columnName\": \"Status\",\n \"description\": \"Status of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"last_port_call_location_name\",\n \"shortId\": \"lln\",\n \"columnName\": \"Last port-call\",\n \"description\": \"Vessel’s last port call location\",\n \"deprecated\": false\n },\n {\n \"id\": \"last_port_call_end\",\n \"shortId\": \"lpe\",\n \"columnName\": \"Departure date\",\n \"description\": \"End of the last port call\",\n \"deprecated\": false\n },\n {\n \"id\": \"cargo_on_board_tons\",\n \"shortId\": \"cbt\",\n \"columnName\": \"Mass (tons)\",\n \"description\": \"Weight of the cargo on board in tons\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_destination_zone_name\",\n \"shortId\": \"nzn\",\n \"columnName\": \"Destination\",\n \"description\": \"Next destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"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\": \"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\": \"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":"30f10125-6158-4615-b05d-3d4b9106f621","name":"List of all vessels","originalRequest":{"method":"GET","header":[{"key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN","description":"Required [string] : Token"}],"url":{"raw":"https://api-lpg.kpler.com/v1/vessels?columns=vessel_id,vessel_name","protocol":"https","host":["api-lpg","kpler","com"],"path":["v1","vessels"],"query":[{"key":"columns","value":"vessel_id,vessel_name","description":"Optional [string] : Retrieve all available columns when set to \"all\""}]}},"status":"OK","code":200,"_postman_previewlanguage":"Text","header":[],"cookie":[],"responseTime":null,"body":"Name;Status;Last port-call;Departure date\nA.K. Raja-1;Inactive;;\nAddress Gas;Active;Iran;2019-07-30 00:00\nAdriatic Gas;Active;Malta Light.;2019-08-12 05:59\nAfrica Gas;Active;P66 Freeport;2019-07-26 11:47\nAgha-1;Inactive;;\nAl Barrah;Active;Paradip Products II;2019-07-28 20:59\nAl Jabirah;Active;Ras Al Khair;\nAl Wukir;Active;Ras Laffan Refinery;2019-08-07 15:39\nAlbane;Active;Port-au-Prince;\n..."},{"id":"ddff2a79-4d6d-49f0-b7c7-519fa33b0a43","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-lpg.kpler.com/v1/vessels?hash=YOUR_BASH","protocol":"https","host":["api-lpg","kpler","com"],"path":["v1","vessels"],"query":[{"key":"hash","value":"YOUR_BASH","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":null,"header":null,"cookie":[],"responseTime":null,"body":""}],"_postman_id":"9182a24e-9c83-41a8-8b69-1d03e4a471c4"},{"name":"/v1/vessels/columns","event":[{"listen":"test","script":{"id":"e139e277-20d5-4e9a-898a-98365e81b00d","exec":[""],"type":"text/javascript"}},{"listen":"prerequest","script":{"id":"6685f7ad-53d1-4082-9d9b-4abcb30fe489","exec":[""],"type":"text/javascript"}}],"id":"74d16739-87df-43d7-8395-21631d9cd4a4","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-lpg.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:
\nRequired [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-lpg.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-lpg","kpler","com"],"query":[],"variable":[]}},"response":[{"id":"83ed638d-cf05-422a-a757-1e7c61871037","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-lpg.kpler.com/v1/vessels/columns"},"_postman_previewlanguage":"json","header":null,"cookie":[],"responseTime":null,"body":"{\n \"selected\": [\n {\n \"id\": \"vessel_name\",\n \"shortId\": \"vna\",\n \"columnName\": \"Name\",\n \"description\": \"Name of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"vessel_status\",\n \"shortId\": \"sta\",\n \"columnName\": \"Status\",\n \"description\": \"Status of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"last_port_call_location_name\",\n \"shortId\": \"lln\",\n \"columnName\": \"Last port-call\",\n \"description\": \"Vessel’s last port call location\",\n \"deprecated\": false\n },\n {\n \"id\": \"last_port_call_end\",\n \"shortId\": \"lpe\",\n \"columnName\": \"Departure date\",\n \"description\": \"End of the last port call\",\n \"deprecated\": false\n },\n {\n \"id\": \"cargo_on_board_tons\",\n \"shortId\": \"cbt\",\n \"columnName\": \"Mass (tons)\",\n \"description\": \"Weight of the cargo on board in tons\",\n \"deprecated\": false\n },\n {\n \"id\": \"next_destination_zone_name\",\n \"shortId\": \"nzn\",\n \"columnName\": \"Destination\",\n \"description\": \"Next destination\",\n \"deprecated\": false\n },\n {\n \"id\": \"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\": \"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\": \"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":"69994071-ac92-415a-8a67-96c9b036c716"}],"id":"7157ea5a-38c3-468b-a62d-2e0892e1e176","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":{"id":"fcbc8997-4f1e-46c0-82aa-1d0a12bbaf07","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"3e355b9f-d716-4800-9c8a-cc05e89f9ced","type":"text/javascript","exec":[""]}}],"_postman_id":"7157ea5a-38c3-468b-a62d-2e0892e1e176","auth":{"type":"oauth2","oauth2":{"basicConfig":[]},"isInherited":true,"source":{"_postman_id":"84efbd19-6781-4c01-b037-8afc85d91733","id":"84efbd19-6781-4c01-b037-8afc85d91733","name":"LPG API Direct Access User Guide","type":"collection"}}},{"name":"Flows","item":[{"name":"/v1/flows","event":[{"listen":"test","script":{"id":"e139e277-20d5-4e9a-898a-98365e81b00d","exec":[""],"type":"text/javascript","packages":{}}},{"listen":"prerequest","script":{"id":"8fcb09c7-2f87-4c13-9703-f93d6d9fba49","exec":[""],"type":"text/javascript","packages":{}}}],"id":"f35489ba-88be-4461-8a5b-745cd2e16302","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"key":"Authorization","value":"Bearer YOUR_TOKEN","description":"Required [String] : Token
\n","type":"text"}],"url":"https://api-lpg.kpler.com/v1/flows?flowDirection={{flowDirection}}&split={{split}}&granularity={{granularity}}&startDate={{startDate}}&endDate={{endDate}}&fromInstallations={{fromInstallations}}&toInstallations={{toInstallations}}&fromZones={{fromZones}}&toZones={{toZones}}&products={{products}}&onlyRealized={{onlyRealized}}&unit={{unit}}&vesselTypes={{vesselTypes}}&withIntraCountry={{withIntraCountry}}&withIntraRegion={{withIntraRegion}}&withForecast={{withForecast}}&snapshotDate={{date}}&splitValues={{splitValues}}","auth":{"type":"oauth2","oauth2":{"basicConfig":[]},"isInherited":true,"source":{"_postman_id":"84efbd19-6781-4c01-b037-8afc85d91733","id":"84efbd19-6781-4c01-b037-8afc85d91733","name":"LPG API Direct Access User Guide","type":"collection"}},"urlObject":{"protocol":"https","path":["v1","flows"],"host":["api-lpg","kpler","com"],"query":[{"description":{"content":"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]: Only Realized [\"Total\", \" Grades\", \" Products\", \" Origin Countries\", \" Destination Countries\", \" Origin Continents\", \" Destination Continents\", \" Origin Subcontinents\", \" Destination Subcontinents\", \" Origin Trading Regions\", \" Destination Trading Regions\", \" Origin Ports\", \" Destination Ports\", \" Origin Installations\", \" Destination Installations\", \" Vessel Type\", \" Trade Status\", \" Sources\", \" Charterers\", \" Buyer\", \" Seller\", \" Routes\"]
\n","type":"text/plain"},"key":"split","value":"{{split}}"},{"description":{"content":"Required [String]: Period [\"annually\", \"monthly\", \"weekly\", \"eia-weekly\", \"daily\"]
\n","type":"text/plain"},"key":"granularity","value":"{{granularity}}"},{"description":{"content":"Optional [Date]: Start of the period (YYYY-MM-DD)
\n","type":"text/plain"},"key":"startDate","value":"{{startDate}}"},{"description":{"content":"Optional [Date]: End of the period (YYYY-MM-DD)
\n","type":"text/plain"},"key":"endDate","value":"{{endDate}}"},{"description":{"content":"Optional [String]: Names of installations
\n","type":"text/plain"},"key":"fromInstallations","value":"{{fromInstallations}}"},{"description":{"content":"Optional [String]: Names of installations
\n","type":"text/plain"},"key":"toInstallations","value":"{{toInstallations}}"},{"description":{"content":"Optional [String]: Names of zones [\"port\", \"region\", \"country\", \"continent\"]
\n","type":"text/plain"},"key":"fromZones","value":"{{fromZones}}"},{"description":{"content":"Optional [String]: Names of zones [\"port\", \"region\", \"country\", \"continent\"]
\n","type":"text/plain"},"key":"toZones","value":"{{toZones}}"},{"description":{"content":"Optional [String]: Names of products
\n","type":"text/plain"},"key":"products","value":"{{products}}"},{"description":{"content":"Optional [Boolean]: By default: onlyRealized=false. 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 [\"kbd\", \"bbl\", \"kb\", \"mmbbl\", \"mt\", \"kt\", \"t\", \"cm\"]. By default value is kb.
\n","type":"text/plain"},"key":"unit","value":"{{unit}}"},{"description":{"content":"Optional [String]: For given LPG vessel types\n
\nUse [\"SGC\", \"VLGC\", \"Handysize\", \"MGC\", \"LGC\", \"VLEC\"]\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]: By default: withForecast=true. Include trades predicted by our in-house model when set to \"true\". Use [\"true\", \"false\"]
\n","type":"text/plain"},"key":"withForecast","value":"{{withForecast}}"},{"description":{"content":"Optional [Date]: Format Date : YYYY-MM-DD, if empty it's returning the last snapshot
\n","type":"text/plain"},"key":"snapshotDate","value":"{{date}}"},{"description":{"content":"Optional [String]: Fix the values and the order of the split
\n","type":"text/plain"},"key":"splitValues","value":"{{splitValues}}"}],"variable":[]}},"response":[{"id":"d716c205-8715-4eb8-ba81-8c17ff4c3b01","name":"Monthly Chinese import from august 2018","originalRequest":{"method":"GET","header":[{"description":"Required [String] : Token","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":{"raw":"https://api-lpg.kpler.com/v1/flows?flowDirection=import&split=total&granularity=monthly&startDate=2018-10-08&toZones=china","protocol":"https","host":["api-lpg","kpler","com"],"path":["v1","flows"],"query":[{"key":"flowDirection","value":"import","description":"Required [String] : Flow direction [\"Import\", \"Export\", \"NetImport\", \"NetExport\"]"},{"key":"split","value":"total","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":"monthly","description":"Required [String] : Period [\"annually, monthly, weekly, eia-weekly, daily\"]"},{"key":"startDate","value":"2018-10-08","description":"Optional [Date] : Start of the period (YYYY-MM-DD)"},{"key":"toZones","value":"china","description":"Optional [String] : Names of zones [\"port\", \"region\", \"country\", \"continent\"]"}]}},"status":"OK","code":200,"_postman_previewlanguage":"Text","header":[],"cookie":[],"responseTime":null,"body":";\n2018-10;22709.39\n2018-11;14783.74\n2018-12;14065.22\n2019-01;18646.02\n2019-02;13843.27\n2019-03;17146.74\n2019-04;16418.61\n2019-05;19862.48\n2019-06;19760.41\n2019-07;22461.4\n2019-08;19724.51\n2019-09;13646.25"}],"_postman_id":"f35489ba-88be-4461-8a5b-745cd2e16302"}],"id":"3a50f3ee-db8c-4fb9-a00a-9a7040d72408","description":"The Flows query returns the aggregated flows for a point of interest (installation/zone) on a daily, weekly, weekly EIA (for US), monthly and yearly basis.
\n","event":[{"listen":"prerequest","script":{"id":"2fb2d1da-fd26-48a3-89ac-8de4fb986711","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"a694eecf-4c60-4325-bc48-6e9a4f7cbb33","type":"text/javascript","exec":[""]}}],"_postman_id":"3a50f3ee-db8c-4fb9-a00a-9a7040d72408","auth":{"type":"oauth2","oauth2":{"basicConfig":[]},"isInherited":true,"source":{"_postman_id":"84efbd19-6781-4c01-b037-8afc85d91733","id":"84efbd19-6781-4c01-b037-8afc85d91733","name":"LPG API Direct Access User Guide","type":"collection"}}},{"name":"Port-calls","item":[{"name":"/v1/port-calls","event":[{"listen":"test","script":{"id":"62f08e8b-1b3c-47c8-8a67-df95a856cc37","exec":[""],"type":"text/javascript"}},{"listen":"prerequest","script":{"id":"26e1f6d4-f537-4d2b-9bf0-f5363d703540","exec":[""],"type":"text/javascript"}}],"id":"bdcbf9c3-5258-48a2-9634-d1556f77d421","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"description":"Required [String] : Token
\n","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":"https://api-lpg.kpler.com/v1/port-calls?size={{size}}&vessels={{vessels}}&installations={{installations}}&zones={{zones}}&products={{products}}&startDate={{startDate}}&endDate={{endDate}}&withForecast={{withForecast}}&columns={{columns}}&hash={{hash}}&withEmptyVolume={{withEmptyVolume}}","auth":{"type":"oauth2","oauth2":{"basicConfig":[]},"isInherited":true,"source":{"_postman_id":"84efbd19-6781-4c01-b037-8afc85d91733","id":"84efbd19-6781-4c01-b037-8afc85d91733","name":"LPG API Direct Access User Guide","type":"collection"}},"urlObject":{"protocol":"https","path":["v1","port-calls"],"host":["api-lpg","kpler","com"],"query":[{"description":{"content":"Optional [Integer]: Maximum number of portcalls returned
\n","type":"text/plain"},"key":"size","value":"{{size}}"},{"description":{"content":"Optional [String]: Names/IMOs of vessels
\n","type":"text/plain"},"key":"vessels","value":"{{vessels}}"},{"description":{"content":"Optional [String]: Names of installations
\n","type":"text/plain"},"key":"installations","value":"{{installations}}"},{"description":{"content":"Optional [String]: Names of zones [\"port\", \"region\", \"country\", \"continent\"]
\n","type":"text/plain"},"key":"zones","value":"{{zones}}"},{"description":{"content":"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]: By default: withForecast=true. Include trades predicted by our in-house model when set to \"true\". Use [\"true\", \"false\"]
\n","type":"text/plain"},"key":"withForecast","value":"{{withForecast}}"},{"description":{"content":"Optional [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}}"},{"description":{"content":"Optional [Boolean]: Default to false if not specified. Provides access to the empty volume port calls. Only available via Freight subscription.
\n","type":"text/plain"},"key":"withEmptyVolume","value":"{{withEmptyVolume}}"}],"variable":[]}},"response":[{"id":"3a9e2cb8-c975-4278-bc39-b7453550aa96","name":"Columns id, name, description and deprecation status","originalRequest":{"method":"GET","header":[],"url":"https://api-lpg.kpler.com/v1/port-calls/columns"},"_postman_previewlanguage":"json","header":null,"cookie":[],"responseTime":null,"body":"{\n \"Columns by default\": [\n {\n \"id\": \"vessel_name\",\n \"shortId\": \"ven\",\n \"columnName\": \"Vessel\",\n \"description\": \"Name of the vessel\",\n \"deprecated\": false\n },\n {\n \"id\": \"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\": \"cargo_origin_barrels_split_by_product_gas\",\n \"shortId\": \"cobspg\",\n \"columnName\": \"Volume (bbl)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"cargo_origin_tons_split_by_product\",\n \"shortId\": \"cotsp\",\n \"columnName\": \"Cargo (tons)\",\n \"description\": \"Quantity (tons) loaded/discharged at the terminal\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_family\",\n \"shortId\": \"cafam\",\n \"columnName\": \"Family\",\n \"description\": \"Product family\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_group\",\n \"shortId\": \"cagroup\",\n \"columnName\": \"Group\",\n \"description\": \"Product group\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_product\",\n \"shortId\": \"capro\",\n \"columnName\": \"Product\",\n \"description\": 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 \"Optional Columns\": [\n {\n \"id\": \"berth_name\",\n \"shortId\": \"bn\",\n \"columnName\": \"Berth Name\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"lpg_vessel_capacity_cubic_meters\",\n \"shortId\": \"lvc\",\n \"columnName\": \"Capacity (vessel m3)\",\n \"description\": null,\n \"deprecated\": true\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\": \"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\": \"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\": \"Sulphur grade of the product\",\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\": \"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\": \"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\": \"flow_quantity_cubic_meters\",\n \"shortId\": \"fqm\",\n \"columnName\": \"Volume (m3)\",\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":"3bf6a36e-2c9b-432f-98d3-cc2ef5796747","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-lpg.kpler.com/v1/port-calls?hash=YOUR_HASH","protocol":"https","host":["api-lpg","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":null,"header":null,"cookie":[],"responseTime":null,"body":""},{"id":"7f4b07f1-aea2-4f4d-a011-9fffabf9ca0f","name":"Loaded/Discharged by kingcraft in Asia","originalRequest":{"method":"GET","header":[{"key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN","description":"Required [string] : Token"}],"url":{"raw":"https://api-lpg.kpler.com/v1/port-calls?size=5&vessels=Kingcraft&zones=asia","protocol":"https","host":["api-lpg","kpler","com"],"path":["v1","port-calls"],"query":[{"key":"size","value":"5","description":"Optional [Integer] : Maximum number of portcalls returned"},{"key":"vessels","value":"Kingcraft","description":"Optional [String] : Names/IMOs of vessels"},{"key":"zones","value":"asia","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 (bbl);Cargo (tons);Family;Group;Product;Grade\nKingcraft;;2019-07-21 17:00;2019-07-21 16:59;2019-07-21 17:01;68150;6035;;LPG;;\nKingcraft;LAUGFS Colombo;2019-07-14 04:01;2019-07-15 09:43;2019-07-20 09:38;-34071;-3017;;LPG;butane;\nKingcraft;LAUGFS Colombo;2019-07-14 04:01;2019-07-15 09:43;2019-07-20 09:38;-34078;-3017;;LPG;propane;\nKingcraft;Oiltank. Sohar;2019-07-07 22:00;2019-07-07 15:36;2019-07-08 22:14;34078;3017;;LPG;propane;\nKingcraft;Oiltank. Sohar;2019-07-07 22:00;2019-07-07 15:36;2019-07-08 22:14;34071;3017;;LPG;butane;\nKingcraft;Engro Vopak;2019-07-07 06:15;2019-07-04 09:15;2019-07-05 10:53;-21680;-1919;;LPG;;\nKingcraft;;;2019-06-28 06:05;2019-06-29 14:59;-23165;-2051;;LPG;butane;\nKingcraft;;;2019-06-28 06:05;2019-06-29 14:59;-23303;-2063;;LPG;propane;\n..."}],"_postman_id":"bdcbf9c3-5258-48a2-9634-d1556f77d421"},{"name":"/v1/port-calls/columns","event":[{"listen":"test","script":{"id":"62f08e8b-1b3c-47c8-8a67-df95a856cc37","exec":[""],"type":"text/javascript"}},{"listen":"prerequest","script":{"id":"26e1f6d4-f537-4d2b-9bf0-f5363d703540","exec":[""],"type":"text/javascript"}}],"id":"3a644f72-eee4-4120-a30a-179874a8b55e","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 \"start\",\n \"end\"\n]"},"url":"https://api-lpg.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:
\nRequired [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-lpg.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-lpg","kpler","com"],"query":[],"variable":[]}},"response":[{"id":"85ffb104-e772-4e11-a027-1fcba803fac8","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-lpg.kpler.com/v1/port-calls/columns"},"_postman_previewlanguage":"json","header":null,"cookie":[],"responseTime":null,"body":"{\n \"selected\": [\n {\n \"id\": \"vessel_name\",\n \"shortId\": \"ven\",\n \"columnName\": \"Vessel\",\n \"description\": \"Name of the vessel\",\n \"deprecated\": false\n },\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\": \"cargo_origin_barrels_split_by_product_gas\",\n \"shortId\": \"cobspg\",\n \"columnName\": \"Volume (bbl)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"cargo_origin_tons_split_by_product\",\n \"shortId\": \"cotsp\",\n \"columnName\": \"Cargo (tons)\",\n \"description\": \"Quantity (tons) loaded/discharged at the terminal\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_family\",\n \"shortId\": \"cafam\",\n \"columnName\": \"Family\",\n \"description\": \"Product family\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_group\",\n \"shortId\": \"cagroup\",\n \"columnName\": \"Group\",\n \"description\": \"Product group\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_product\",\n \"shortId\": \"capro\",\n \"columnName\": \"Product\",\n \"description\": 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 \"unselected\": [\n {\n \"id\": \"berth_name\",\n \"shortId\": \"bn\",\n \"columnName\": \"Berth Name\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"lpg_vessel_capacity_cubic_meters\",\n \"shortId\": \"lvc\",\n \"columnName\": \"Capacity (vessel m3)\",\n \"description\": null,\n \"deprecated\": true\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\": \"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\": \"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\": \"Sulphur grade of the product\",\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\": \"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\": \"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\": \"flow_quantity_cubic_meters\",\n \"shortId\": \"fqm\",\n \"columnName\": \"Volume (m3)\",\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":"7d386dc7-cb83-4a97-a9f2-d0d0ca75f5fb"}],"id":"e2de38d5-f9e0-4e3a-a291-dbacde5b3da0","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":{"id":"8ff82b7e-dc0c-42bc-9c4d-79de12b7c15d","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"afd66a52-c4a2-406b-9981-4006e87896e4","type":"text/javascript","exec":[""]}}],"_postman_id":"e2de38d5-f9e0-4e3a-a291-dbacde5b3da0","auth":{"type":"oauth2","oauth2":{"basicConfig":[]},"isInherited":true,"source":{"_postman_id":"84efbd19-6781-4c01-b037-8afc85d91733","id":"84efbd19-6781-4c01-b037-8afc85d91733","name":"LPG API Direct Access User Guide","type":"collection"}}},{"name":"Ship-to-ships","item":[{"name":"/v1/ship-to-ships","event":[{"listen":"test","script":{"id":"e139e277-20d5-4e9a-898a-98365e81b00d","exec":[""],"type":"text/javascript"}},{"listen":"prerequest","script":{"id":"6685f7ad-53d1-4082-9d9b-4abcb30fe489","exec":[""],"type":"text/javascript"}}],"id":"a84318ed-c83a-44b9-b8b9-dd25a0a512de","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"description":"Required [String] : Token
\n","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":"https://api-lpg.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":[]},"isInherited":true,"source":{"_postman_id":"84efbd19-6781-4c01-b037-8afc85d91733","id":"84efbd19-6781-4c01-b037-8afc85d91733","name":"LPG API Direct Access User Guide","type":"collection"}},"urlObject":{"protocol":"https","path":["v1","ship-to-ships"],"host":["api-lpg","kpler","com"],"query":[{"description":{"content":"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":"c84c966d-ecf5-4b66-bc81-d87e78a28e37","name":"Columns id, name, description and deprecation status","originalRequest":{"method":"GET","header":[],"url":"https://api-lpg.kpler.com/v1/ship-to-ships/columns"},"_postman_previewlanguage":"json","header":null,"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\": \"cargo_origin_tons_split_by_product\",\n \"shortId\": \"cotsp\",\n \"columnName\": \"Cargo (tons)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_family\",\n \"shortId\": \"cafam\",\n \"columnName\": \"Family\",\n \"description\": \"Product family\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_group\",\n \"shortId\": \"cagroup\",\n \"columnName\": \"Group\",\n \"description\": \"Product group\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_product\",\n \"shortId\": \"capro\",\n \"columnName\": \"Product\",\n \"description\": \"Product type\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_grade\",\n \"shortId\": \"cagrade\",\n \"columnName\": \"Grade\",\n \"description\": \"Product grade\",\n \"deprecated\": false\n },\n {\n \"id\": \"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\": \"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\": \"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":"c91f5a53-500d-4729-9d22-c91e039f2a54","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-lpg.kpler.com/v1/ship-to-ships?hash=YOUR_HASH","protocol":"https","host":["api-lpg","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":null,"header":null,"cookie":[],"responseTime":null,"body":""},{"id":"e301bba6-75c4-4351-8191-e2516854d7dc","name":"Ship-to-ship loading/discharges of gas husky at Male anchorage","originalRequest":{"method":"GET","header":[{"description":"Required [String] : Token","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":{"raw":"https://api-lpg.kpler.com/v1/ship-to-ships?size=10&zones=Male Anchorage&products=lpg","protocol":"https","host":["api-lpg","kpler","com"],"path":["v1","ship-to-ships"],"query":[{"key":"size","value":"10","description":"Optional [Integer] : Maximum number of sts returned"},{"key":"zones","value":"Male Anchorage","description":"Optional [String] : Names of zones [\"port\", \"lightering\", \"region\", \"country\", \"continent\"]"},{"key":"products","value":"lpg","description":"Optional [String] : Names of products"}]}},"status":"OK","code":200,"_postman_previewlanguage":"Text","header":[],"cookie":[],"responseTime":null,"body":"Vessel (load);IMO (load);Vessel (discharge);IMO (discharge);Cargo (tons);Family;Group;Product;Grade;Zone;Start;End\nPgc Periklis;9796171;Epic Shikoku;9733545;1911;;LPG;;;Male Anchorage;2019-07-22 09:49;2019-07-23 01:33\nGas Husky;9507764;Epic Shikoku;9733545;4123;;LPG;;;Male Anchorage;2019-07-20 01:53;2019-07-20 16:52\nGas Husky;9507764;Beykoz;9558945;164;;LPG;;;Male Anchorage;2019-06-24 23:15;2019-06-25 08:51\nGas Husky;9507764;Epic Borkum;9228253;3959;;LPG;;;Male Anchorage;2019-06-24 02:40;2019-06-25 06:06\nGas Esco;9507752;Kingcraft;9713648;4032;;LPG;;;Male Anchorage;2019-06-17 17:49;2019-06-17 22:26\nPacific Qingdao;9739953;Gas Dignity;9193721;42234;;LPG;;;Male Anchorage;2019-06-08 03:23;2019-06-09 20:44\nPacific Yantai;9739965;Sea Dolphin;9195494;42303;;LPG;propane;;Male Anchorage;2019-06-01 12:00;2019-06-02 12:00\nGas Beryl;9454010;Gas Tara;8818219;43059;;LPG;;;Male Anchorage;2019-05-23 06:31;2019-05-25 19:37\nGas Beryl;9454010;Sea Sapphire;9114581;31224;;LPG;propane;;Male Anchorage;2019-04-16 04:33;2019-04-18 11:42\nGas Beryl;9454010;Sea Sapphire;9114581;10970;;LPG;butane;;Male Anchorage;2019-04-16 04:33;2019-04-18 11:42\nPacific Dongying;9743722;Beatris Gas;9041655;16684;;LPG;butane;;Male Anchorage;2019-03-07 06:12;2019-03-09 06:12\nPacific Dongying;9743722;Beatris Gas;9041655;26385;;LPG;propane;;Male Anchorage;2019-03-07 06:12;2019-03-09 06:12"}],"_postman_id":"a84318ed-c83a-44b9-b8b9-dd25a0a512de"},{"name":"/v1/ship-to-ships/columns","event":[{"listen":"test","script":{"id":"e139e277-20d5-4e9a-898a-98365e81b00d","exec":[""],"type":"text/javascript"}},{"listen":"prerequest","script":{"id":"6685f7ad-53d1-4082-9d9b-4abcb30fe489","exec":[""],"type":"text/javascript"}}],"id":"7fe250bb-32f0-48b1-9753-ed594c5fa8bc","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 \"load_vessel_name\",\n \"load_vessel_imo\"\n]"},"url":"https://api-lpg.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:
\nRequired [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-lpg.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-lpg","kpler","com"],"query":[],"variable":[]}},"response":[{"id":"f59b43a5-1e88-4a64-8e5f-e632769f640e","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-lpg.kpler.com/v1/ship-to-ships/columns"},"_postman_previewlanguage":"json","header":null,"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\": \"cargo_origin_tons_split_by_product\",\n \"shortId\": \"cotsp\",\n \"columnName\": \"Cargo (tons)\",\n \"description\": null,\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_family\",\n \"shortId\": \"cafam\",\n \"columnName\": \"Family\",\n \"description\": \"Product family\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_group\",\n \"shortId\": \"cagroup\",\n \"columnName\": \"Group\",\n \"description\": \"Product group\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_product\",\n \"shortId\": \"capro\",\n \"columnName\": \"Product\",\n \"description\": \"Product type\",\n \"deprecated\": false\n },\n {\n \"id\": \"closest_ancestor_grade\",\n \"shortId\": \"cagrade\",\n \"columnName\": \"Grade\",\n \"description\": \"Product grade\",\n \"deprecated\": false\n },\n {\n \"id\": \"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\": \"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\": \"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":"59c01df1-51b7-4002-9740-7a248ec89bcc"}],"id":"1f5a5a84-552e-4652-97d7-bf1fbe9f32a5","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":{"id":"74896653-714e-484a-8acc-0d1c6693fa32","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"ca9ab749-a813-4cf2-97d5-ebaccacb1e24","type":"text/javascript","exec":[""]}}],"_postman_id":"1f5a5a84-552e-4652-97d7-bf1fbe9f32a5","auth":{"type":"oauth2","oauth2":{"basicConfig":[]},"isInherited":true,"source":{"_postman_id":"84efbd19-6781-4c01-b037-8afc85d91733","id":"84efbd19-6781-4c01-b037-8afc85d91733","name":"LPG API Direct Access User Guide","type":"collection"}}},{"name":"Fleet Metrics","item":[{"name":"/v1/fleet-metrics","event":[{"listen":"test","script":{"id":"e139e277-20d5-4e9a-898a-98365e81b00d","exec":[""],"type":"text/javascript"}},{"listen":"prerequest","script":{"id":"8fcb09c7-2f87-4c13-9703-f93d6d9fba49","exec":[""],"type":"text/javascript"}}],"id":"4ec7ccd2-3209-4bae-a9de-283003d48479","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"description":"Required [String] : Token
\n","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":"https://api-lpg.kpler.com/v1/fleet-metrics?metric={{metric}}&zones={{zones}}&floatingStorageDurationMin={{floatingStorageDurationMin}}&floatingStorageDurationMax={{floatingStorageDurationMax}}&period={{period}}&startDate={{startDate}}&endDate={{endDate}}&products={{products}}&unit={{unit}}&split={{split}}&vesselTypes={{vesselTypes}}&splitValues={{splitValues}}","description":"Retrieve the daily/weekly fleet data aggregated for a given zone.
\nAvailable for all the fleet metrics.
\nWe provide you with a CSV file containing zones available for search. Download file.
\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:
\nRequired [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 [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 [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]: Names of products. Default to all available products if not specified.
\n","type":"text/plain"},"key":"products","value":"{{products}}"},{"description":{"content":"Optional [String]: Use [\"bbl\", \"kb\", \"mmbbl\", \"mt\", \"kt\", \"t\", \"cm\"]. Default to bbl if not specified.
\n","type":"text/plain"},"key":"unit","value":"{{unit}}"},{"description":{"content":"Optional [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\", \" 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 LPG vessel types\n
\nUse [\"SGC\", \"VLGC\", \"Handysize\", \"MGC\", \"LGC\", \"VLEC\"]\n
\nNote: Values are case sensitive
Optional [String]: Fix the values and the order of the split
\n","type":"text/plain"},"key":"splitValues","value":"{{splitValues}}"}],"variable":[]}},"response":[{"id":"99731334-3b9e-4b49-9975-a4e4c838b1dc","name":"The world's floating storage (bbl), on a daily basis in March 2019.","originalRequest":{"method":"GET","header":[{"description":"Required [String] : Token","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":{"raw":"https://api-lpg.kpler.com/v1/fleet-metrics?metric=floating_storage&zones=world&floatingStorageDurationMin=7&floatingStorageDurationMax=Inf&period=daily&startDate=2019-03-01&endDate=2019-03-31&unit=bbl","protocol":"https","host":["api-lpg","kpler","com"],"path":["v1","fleet-metrics"],"query":[{"key":"metric","value":"floating_storage"},{"key":"zones","value":"world"},{"key":"floatingStorageDurationMin","value":"7"},{"key":"floatingStorageDurationMax","value":"Inf"},{"key":"period","value":"daily"},{"key":"startDate","value":"2019-03-01"},{"key":"endDate","value":"2019-03-31"},{"key":"unit","value":"bbl"}]}},"status":"OK","code":200,"_postman_previewlanguage":"Text","header":[],"cookie":[],"responseTime":null,"body":"Date;Total\n;\n2019-03-01;4623049.47\n2019-03-02;4616656\n2019-03-03;4141994.64\n2019-03-04;4689727.16\n2019-03-05;4133402.41\n2019-03-06;3724302.34\n2019-03-07;4001679.93\n2019-03-08;4115089.33\n2019-03-09;3981669.87\n2019-03-10;3335761.75\n2019-03-11;3160859.1\n..."}],"_postman_id":"4ec7ccd2-3209-4bae-a9de-283003d48479"},{"name":"/v1/fleet-metrics/vessels","event":[{"listen":"test","script":{"id":"e139e277-20d5-4e9a-898a-98365e81b00d","exec":[""],"type":"text/javascript"}},{"listen":"prerequest","script":{"id":"8fcb09c7-2f87-4c13-9703-f93d6d9fba49","exec":[""],"type":"text/javascript"}}],"id":"c9f976c2-e4e5-43e0-87f9-4e2ad5696864","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"description":"Required [String] : Token
\n","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":"https://api-lpg.kpler.com/v1/fleet-metrics/vessels?metric={{metric}}&floatingStorageDurationMin={{floatingStorageDurationMin}}&floatingStorageDurationMax={{floatingStorageDurationMax}}&zones={{zones}}&products={{products}}&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.
\nWe provide you with a CSV file containing zones available for search. Download file.
\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:
\ne.g To retrieve data for 2020-10-01, you should specified startDate=2020-10-01 and endDate=2020-10-01.
\nRequired [String]: Use following metrics\n
Minimum floating days [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 [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]: Names of products. Default to all available products if not specified
\n","type":"text/plain"},"key":"products","value":"{{products}}"},{"description":{"content":"Optional [String]: Use ['bbl', 'kb', 'mmbbl', 'mt', 'kt', 't', 'cm']. Default to bbl 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 LPG vessel types\n
\nUse [\"SGC\", \"VLGC\", \"Handysize\", \"MGC\", \"LGC\", \"VLEC\"]\n
\nNote: Values are case sensitive
Required [String] : Token
\n"}],"url":"https://api-lpg.kpler.com/v1/fleet-metrics/trades?metric={{metric}}&date={{date}}&floatingStorageDurationMin={{floatingStorageDurationMin}}&floatingStorageDurationMax={{floatingStorageDurationMax}}&zones={{zones}}&products={{products}}&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":[]},"isInherited":true,"source":{"_postman_id":"84efbd19-6781-4c01-b037-8afc85d91733","id":"84efbd19-6781-4c01-b037-8afc85d91733","name":"LPG API Direct Access User Guide","type":"collection"}},"urlObject":{"protocol":"https","path":["v1","fleet-metrics","trades"],"host":["api-lpg","kpler","com"],"query":[{"description":{"content":"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 [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 [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]: Names of products. Default to all available products if not specified
\n","type":"text/plain"},"key":"products","value":"{{products}}"},{"description":{"content":"Optional [String]: For given LPG vessel types\n
\nUse [\"SGC\", \"VLGC\", \"Handysize\", \"MGC\", \"LGC\", \"VLEC\"]\n
\nNote: Values are case sensitive
The fleet metrics endpoint returns fleet data for a given zone.
\nFollowing metrics are available:
\nThe 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","event":[{"listen":"prerequest","script":{"id":"07a359f3-5029-45d9-9516-f8481350fb76","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"d7c2717c-2214-4716-b611-4e5d8fbbb9e6","type":"text/javascript","exec":[""]}}],"_postman_id":"12891ee9-0a44-4862-8da4-82cf819fb51b","auth":{"type":"oauth2","oauth2":{"basicConfig":[]},"isInherited":true,"source":{"_postman_id":"84efbd19-6781-4c01-b037-8afc85d91733","id":"84efbd19-6781-4c01-b037-8afc85d91733","name":"LPG API Direct Access User Guide","type":"collection"}}},{"name":"Contracts","item":[{"name":"/v1/contracts","event":[{"listen":"test","script":{"id":"ef6ac75e-e2b4-4ca5-8eee-21804fce6af2","exec":[""],"type":"text/javascript"}},{"listen":"prerequest","script":{"id":"1d84d81c-90a8-466c-88d9-8461cc02d24e","exec":[""],"type":"text/javascript"}}],"id":"bafc3e0b-ff91-4b26-ac9f-1494784c5bf3","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"description":"Required [String] : Token
\n","key":"Authorization","type":"text","value":"Bearer YOUR_TOKEN"}],"url":"https://api-lpg.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":[]},"isInherited":true,"source":{"_postman_id":"84efbd19-6781-4c01-b037-8afc85d91733","id":"84efbd19-6781-4c01-b037-8afc85d91733","name":"LPG API Direct Access User Guide","type":"collection"}},"urlObject":{"protocol":"https","path":["v1","contracts"],"host":["api-lpg","kpler","com"],"query":[{"description":{"content":"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 [\"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":"4cd0d396-8be6-4407-a100-f2995e45bc13","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-lpg.kpler.com/v1/contracts?zones=europe","protocol":"https","host":["api-lpg","kpler","com"],"path":["v1","contracts"],"query":[{"key":"zones","value":"europe"}]}},"status":"OK","code":200,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Mon, 20 Mar 2023 09:19:35 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":"*"}],"cookie":[],"responseTime":null,"body":"Type;Seller;Buyer;Capacity;Slots;Delivery;Start;End;Origin Zone;Destination Zone\nContract;Petkim;Evonik;0.1;;;2020-01-01 00:00;2020-12-31 00:00;Turkey;World\nContract;Petkim;BGN;;;;2019-01-01 00:00;2019-12-31 00:00;Turkey;World\nTender;;SHV;0.044;;;2016-12-01 00:00;2016-12-31 00:00;World;France\nContract;;Borealis;0.24;;;2016-09-01 00:00;2026-09-01 00:00;World;Sweden\nLTA;AS DBT;Yara;;;;2016-03-01 00:00;;Estonia;World\nContract;Equinor;Borealis;;;;2015-10-01 00:00;2022-10-01 00:00;Norway;Sweden\nLTA;Government of Ukraine;TOAZ;3.0;;;2015-01-01 00:00;;Ukraine;World\nContract;Equinor;NORGAL;0.13;;FOB/CIF;2013-01-01 00:00;;World;France\nContract;Sonatrach;SHV;0.12;;CIF;2013-01-01 00:00;;Algeria;France\nLTA;Equinor;Shell;0.3;;;2013-01-01 00:00;;Norway;World\nContract;TotalEnergies;NORGAL;0.35;;FOB/CIF;2013-01-01 00:00;;World;France\nContract;TotalEnergies;Aygaz;0.075;;FOB/CIF;2013-01-01 00:00;;World;Turkey\nContract;ExxonMobil;Valero;0.24;;FOB/CIF;2013-01-01 00:00;;World;United Kingdom\nLTA;Ukrloudsystems;TCO;0.25;;;2013-01-01 00:00;;Ukraine;World\nContract;TCO;Aygaz;0.3;;FOB/CIF;2013-01-01 00:00;;Ukraine;World\nContract;TotalEnergies;SHV;0.08;;FOB/CIF;2013-01-01 00:00;;World;Italy\nTUA;Antwerp Gas;Borealis;;;;2013-01-01 00:00;;Belgium;World\nTUA;Antwerp Gas;Ineos;;;;2013-01-01 00:00;;Belgium;World\nContract;Shell;Equinor;0.15;;FOB;2013-01-01 00:00;;United Kingdom;World\nContract;Shell;Borealis;0.2;;CIF;2013-01-01 00:00;;World;Sweden\nContract;Equinor;Aygaz;0.22;;CIF;2013-01-01 00:00;;Norway;World\nContract;Equinor;Tupras;0.22;;CIF;2013-01-01 00:00;;Norway;World\nLTA;Equinor;Petredec;0.25;;;2013-01-01 00:00;;Norway;World\nLTA;ExxonMobil;Petredec;0.004;;;2013-01-01 00:00;;United Kingdom;World\nContract;Sonatrach;Repsol;0.15;;FOB;2013-01-01 00:00;;Algeria;Spain\nContract;Geogas;Repsol;0.25;;CIF;2013-01-01 00:00;;World;Spain\nContract;Equinor;Ineos;0.1;;FOB;2013-01-01 00:00;;Norway;World\nContract;Equinor;ExxonMobil;0.05;;FOB;2013-01-01 00:00;;Norway;World\nContract;Shell;Centrica Plc;0.15;;FOB;2013-01-01 00:00;;United Kingdom;World\nContract;Shell;ConocoPhillips;0.05;;FOB;2013-01-01 00:00;;United Kingdom;World\nContract;Sonatrach;LyondellBasell;0.15;;CIF;2013-01-01 00:00;;Algeria;France\nContract;TotalEnergies;Tupras;0.075;;FOB/CIF;2013-01-01 00:00;;World;Turkey\nContract;Shell;TotalEnergies;0.1;;;2013-01-01 00:00;;United Kingdom;World\nContract;Neste Oil;Equinor;0.09;;FOB/CIF;2013-01-01 00:00;;Finland;World\nContract;Sonatrach;BASF Sonatrach;0.43;;CIF;2013-01-01 00:00;;Algeria;Spain\nContract;TCO;SHV;0.5;;FOB/CIF;2013-01-01 00:00;;Ukraine;World\nContract;TotalEnergies;SHV;0.08;;FOB/CIF;2013-01-01 00:00;;World;Italy\nContract;Sabic;Eni;0.03;;FOB/CIF;2013-01-01 00:00;;United Kingdom;World\nContract;Equinor;Ineos;0.65;;CIF;2013-01-01 00:00;;World;Norway\nContract;Sonatrach;Oteko;0.25;;CIF;2013-01-01 00:00;;World;Turkey\nTUA;Antwerp Gas;SHV;;;;2013-01-01 00:00;;Belgium;World\nContract;BP;NORGAL;0.13;;FOB/CIF;2013-01-01 00:00;;World;France\nLTA;Equinor;TotalEnergies;0.3;;;2013-01-01 00:00;;Norway;World\nContract;Sabic;BG;0.03;;FOB/CIF;2013-01-01 00:00;;United Kingdom;World\nContract;Sabic;TotalEnergies;0.03;;FOB/CIF;2013-01-01 00:00;;United Kingdom;World\nContract;Equinor;Borealis;0.2;;FOB/CIF;2013-01-01 00:00;;World;Belgium\nContract;Equinor;Valero;0.24;;FOB/CIF;2013-01-01 00:00;;World;United Kingdom\nTUA;Vopak;Gunvor;;;;2008-01-01 00:00;;Netherlands;World\nTUA;Geogaz;BP;;;;2008-01-01 00:00;;France;World\nTUA;Geogaz;Shell;;;;2008-01-01 00:00;;France;World\nTUA;Geogaz;ExxonMobil;;;;2008-01-01 00:00;;France;World\nTUA;Geogaz;TotalEnergies;;;;2008-01-01 00:00;;France;World\nTUA;Geogaz;LyondellBasell;;;;2008-01-01 00:00;;France;World\nContract;Snohvit Cons.;Equinor;0.11;;FOB/CIF;2007-09-01 00:00;;Norway;World\nContract;Equinor;Borealis;0.15;;CIF;2005-01-01 00:00;2015-12-31 00:00;Norway;Sweden\nLTA;Equinor;TotalEnergies;0.035;;;2005-01-01 00:00;;Norway;World\nLTA;Equinor;Shell;0.035;;;2005-01-01 00:00;;Norway;World\n"},{"id":"b5054049-c30f-4cf7-8c0e-dfc388606c6d","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-lpg.kpler.com/v1/contracts?types=LTA","protocol":"https","host":["api-lpg","kpler","com"],"path":["v1","contracts"],"query":[{"key":"types","value":"LTA"}]}},"status":"OK","code":200,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Mon, 20 Mar 2023 09:24:18 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":"*"}],"cookie":[],"responseTime":null,"body":"Type;Seller;Buyer;Capacity;Slots;Delivery;Start;End;Origin Zone;Destination Zone\nLTA;NGL Energy;Mercuria;;;;2019-04-01 00:00;2024-04-01 00:00;United States;World\nLTA;AS DBT;Yara;;;;2016-03-01 00:00;;Estonia;World\nLTA;Sunoco;Mercuria;;;;2016-01-01 00:00;;United States;World\nLTA;Government of Ukraine;TOAZ;3.0;;;2015-01-01 00:00;;Ukraine;World\nLTA;DCP Mid;MarkWest;;;;2014-01-01 00:00;2019-03-31 00:00;United States;World\nLTA;Sunoco;MarkWest;;;;2014-01-01 00:00;;United States;World\nLTA;Equinor;Shell;0.3;;;2013-01-01 00:00;;Norway;World\nLTA;Ukrloudsystems;TCO;0.25;;;2013-01-01 00:00;;Ukraine;World\nLTA;Equinor;Petredec;0.25;;;2013-01-01 00:00;;Norway;World\nLTA;ExxonMobil;Petredec;0.004;;;2013-01-01 00:00;;United Kingdom;World\nLTA;Equinor;TotalEnergies;0.3;;;2013-01-01 00:00;;Norway;World\nLTA;Vopak;Petronas;1.0;;;2010-01-01 00:00;;Malaysia;World\nLTA;Equinor;TotalEnergies;0.035;;;2005-01-01 00:00;;Norway;World\nLTA;Equinor;Shell;0.035;;;2005-01-01 00:00;;Norway;World\n"},{"id":"4c4681ac-0580-4b99-b4a9-9373606cf05d","name":"Columns id, name, description and deprecation status","originalRequest":{"method":"GET","header":[],"url":"https://api-lpg.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":"5c7f61c1-1961-4983-901b-e615375481c0","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-lpg.kpler.com/v1/contracts?hash=YOUR_HASH","protocol":"https","host":["api-lpg","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":"bafc3e0b-ff91-4b26-ac9f-1494784c5bf3"},{"name":"/v1/contracts/columns","event":[{"listen":"test","script":{"id":"c6cc7fe8-212f-45f1-9e1c-9d6e68c9ef73","exec":[""],"type":"text/javascript"}},{"listen":"prerequest","script":{"id":"c0483f79-dbab-42d5-9c65-a86f6e4f91de","exec":[""],"type":"text/javascript"}}],"id":"7858c41a-11dd-428b-91b6-cc95b23170d5","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-lpg.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:
\nRequired [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-lpg.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-lpg","kpler","com"],"query":[],"variable":[]}},"response":[{"id":"fcb60fb6-5b71-42d1-8d95-7a59e60ff83a","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-lpg.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":"9529dcff-0cfe-4f67-a61a-28e9b4a6a91a"}],"id":"84624234-9306-41eb-b40b-cf6b67c16b04","description":"The /Contracts endpoint allows you to extract a list of TUAs, LTAs, and Tenders for all LPG 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":"84624234-9306-41eb-b40b-cf6b67c16b04","auth":{"type":"oauth2","oauth2":{"basicConfig":[]},"isInherited":true,"source":{"_postman_id":"84efbd19-6781-4c01-b037-8afc85d91733","id":"84efbd19-6781-4c01-b037-8afc85d91733","name":"LPG API Direct Access User Guide","type":"collection"}}},{"name":"Products","item":[{"name":"/v1/products","id":"18048b5d-5741-45f4-9077-0fa58006222e","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://api-lpg.kpler.com/v1/products?size={{size}}&ancestorFamilyIds={{ancestorFamilyIds}}&ancestorFamilyNames={{ancestorFamilyNames}}&ancestorGroupIds={{ancestorGroupIds}}&ancestorGroupNames={{ancestorGroupNames}}&ancestorProductIds={{ancestorProductIds}}&ancestorProductNames={{ancestorProductNames}}&ancestorGradeIds={{ancestorGradeIds}}&ancestorGradeNames={{ancestorGradeNames}}&products={{products}}&productIds={{productIds}}","auth":{"type":"oauth2","oauth2":{"basicConfig":[]},"isInherited":true,"source":{"_postman_id":"84efbd19-6781-4c01-b037-8afc85d91733","id":"84efbd19-6781-4c01-b037-8afc85d91733","name":"LPG API Direct Access User Guide","type":"collection"}},"urlObject":{"protocol":"https","path":["v1","products"],"host":["api-lpg","kpler","com"],"query":[{"key":"size","value":"{{size}}"},{"description":{"content":"IDs of a product Family. Can be separated by a coma.
\n","type":"text/plain"},"key":"ancestorFamilyIds","value":"{{ancestorFamilyIds}}"},{"description":{"content":"Default to the whole tree if not specified. Possible values are : ex LPG, natural gas liquids
\n","type":"text/plain"},"key":"ancestorFamilyNames","value":"{{ancestorFamilyNames}}"},{"description":{"content":"IDs of a product Group. Can be separated by a coma.
\n","type":"text/plain"},"key":"ancestorGroupIds","value":"{{ancestorGroupIds}}"},{"description":{"content":"Default to the whole tree if not specified. Possible values are : olefins, LPG
\n","type":"text/plain"},"key":"ancestorGroupNames","value":"{{ancestorGroupNames}}"},{"description":{"content":"IDs of a product Product. Can be separated by a coma.
\n","type":"text/plain"},"key":"ancestorProductIds","value":"{{ancestorProductIds}}"},{"description":{"content":"Default to the whole tree if not specified. Possible values are : Hydrogen, propylene, butane
\n","type":"text/plain"},"key":"ancestorProductNames","value":"{{ancestorProductNames}}"},{"description":{"content":"IDs of a product Grade. Can be separated by a coma.
\n","type":"text/plain"},"key":"ancestorGradeIds","value":"{{ancestorGradeIds}}"},{"description":{"content":"Default to the whole tree if not specified. Possible values are : PGP, RGP, CGP, iso butane,...
\n","type":"text/plain"},"key":"ancestorGradeNames","value":"{{ancestorGradeNames}}"},{"description":{"content":"Names of Products of all different tree levels (Family, Group, Product, Grade)
\n","type":"text/plain"},"key":"products","value":"{{products}}"},{"description":{"content":"Ids of possible products. Can be separated by a coma
\n","type":"text/plain"},"key":"productIds","value":"{{productIds}}"}],"variable":[]}},"response":[{"id":"b9db32f8-39f4-4879-b84a-144ff284d2da","name":"LPG- Products","originalRequest":{"method":"GET","header":[],"url":{"raw":"https://api-lpg.kpler.com/v1/products?ancestorGroupNames=olefins","protocol":"https","host":["api-lpg","kpler","com"],"path":["v1","products"],"query":[{"key":"ancestorGroupNames","value":"olefins"}]}},"_postman_previewlanguage":"Text","header":[],"cookie":[],"responseTime":null,"body":""}],"_postman_id":"18048b5d-5741-45f4-9077-0fa58006222e"}],"id":"7c727956-2e91-4eac-9d12-ac97b9909218","description":"The Products query requests the product tree of Kpler and the relationship between these different layers. This is a static table and works using our following layers Families > Groups > Products > Grades.
\n","_postman_id":"7c727956-2e91-4eac-9d12-ac97b9909218","auth":{"type":"oauth2","oauth2":{"basicConfig":[]},"isInherited":true,"source":{"_postman_id":"84efbd19-6781-4c01-b037-8afc85d91733","id":"84efbd19-6781-4c01-b037-8afc85d91733","name":"LPG API Direct Access User Guide","type":"collection"}}},{"name":"Zones","item":[{"name":"/v1/zones","id":"c1dc744c-e4f1-4348-8f43-24c8a50e8bb7","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://api-lpg.kpler.com/v1/zones?ancestorId={{ancestorId}}&ancestorName={{ancestorName}}&ancestorType={{ancestorType}}&descendantId={{descendantId}}&descendantName={{descendantName}}&descendantType={{descendantType}}","auth":{"type":"oauth2","oauth2":{"basicConfig":[]},"isInherited":true,"source":{"_postman_id":"84efbd19-6781-4c01-b037-8afc85d91733","id":"84efbd19-6781-4c01-b037-8afc85d91733","name":"LPG API Direct Access User Guide","type":"collection"}},"urlObject":{"protocol":"https","path":["v1","zones"],"host":["api-lpg","kpler","com"],"query":[{"description":{"content":"IDs ancestor zones. Can be separated by a coma.
\n","type":"text/plain"},"key":"ancestorId","value":"{{ancestorId}}"},{"description":{"content":"Names ancestor zones. Can be separated by a coma.
\n","type":"text/plain"},"key":"ancestorName","value":"{{ancestorName}}"},{"description":{"content":"Type of ancestor zones. Can be separated by a coma. e.g. continent, subcontinent,region, subregion, country, port, custom, bay, cape, gulf, ocean, sea, strait, ...
\n","type":"text/plain"},"key":"ancestorType","value":"{{ancestorType}}"},{"description":{"content":"IDs descendant zones. Can be separated by a coma.
\n","type":"text/plain"},"key":"descendantId","value":"{{descendantId}}"},{"description":{"content":"Names descendant zones. Can be separated by a coma.
\n","type":"text/plain"},"key":"descendantName","value":"{{descendantName}}"},{"description":{"content":"Type of descendant zones. Can be separated by a coma. e.g. continent, subcontinent,region, subregion, country, port, custom, bay, cape, gulf, ocean, sea, strait, ...
\n","type":"text/plain"},"key":"descendantType","value":"{{descendantType}}"}],"variable":[]}},"response":[{"id":"fe493073-f648-42cc-bece-2a4a7d9beee9","name":"LPG- get all ports in the Baltic Sea","originalRequest":{"method":"GET","header":[],"url":{"raw":"https://api-lpg.kpler.com/v1/zones?ancestorName=Baltic Sea&descendantType=port","protocol":"https","host":["api-lpg","kpler","com"],"path":["v1","zones"],"query":[{"key":"ancestorName","value":"Baltic Sea"},{"key":"descendantType","value":"port"}]}},"_postman_previewlanguage":"Text","header":[],"cookie":[],"responseTime":null,"body":""},{"id":"f8c4958a-7dce-4b79-bd0e-54ca35a89001","name":"LPG - get based on Descendant ID","originalRequest":{"method":"GET","header":[],"url":{"raw":"https://api-lpg.kpler.com/v1/zones?descendantId=87","protocol":"https","host":["api-lpg","kpler","com"],"path":["v1","zones"],"query":[{"key":"descendantId","value":"87"}]}},"_postman_previewlanguage":"Text","header":[],"cookie":[],"responseTime":null,"body":""}],"_postman_id":"c1dc744c-e4f1-4348-8f43-24c8a50e8bb7"}],"id":"2f6fc3fa-1ad9-4beb-ba42-175594454b90","description":"The Zones query returns the Zones Hierarchy of Kpler and the relationship between these different layers. This is a static table and works using an ancestor/desdendant relationship..
\n","_postman_id":"2f6fc3fa-1ad9-4beb-ba42-175594454b90","auth":{"type":"oauth2","oauth2":{"basicConfig":[]},"isInherited":true,"source":{"_postman_id":"84efbd19-6781-4c01-b037-8afc85d91733","id":"84efbd19-6781-4c01-b037-8afc85d91733","name":"LPG API Direct Access User Guide","type":"collection"}}},{"name":"Fixtures","item":[{"name":"/v1/fixtures","id":"a1cacf08-10a6-4a1d-89ee-4c4b9b16155d","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"{{HOST_URL}}/v1/fixtures?size={{size}}&reportedDateAfter={{reportedDateAfter}}&reportedDateBefore={{reportedDateBefore}}&layCanStartAfter={{layCanStartAfter}}&layCanStartBefore={{layCanStartBefore}}&fromZones={{fromZones}}&toZones={{toZones}}&products={{products}}&dwtMin={{dwtMin}}&dwtMax={{dwtMax}}&statuses={{statuses}}&vesselTypes={{vesselTypes}}&vessels={{vessels}}","auth":{"type":"oauth2","oauth2":{"basicConfig":[]},"isInherited":true,"source":{"_postman_id":"84efbd19-6781-4c01-b037-8afc85d91733","id":"84efbd19-6781-4c01-b037-8afc85d91733","name":"LPG API Direct Access User Guide","type":"collection"}},"urlObject":{"path":["v1","fixtures"],"host":["{{HOST_URL}}"],"query":[{"description":{"content":"Optional [Integer]: By default: size=1000 Maximum number of results returned.
\n","type":"text/plain"},"key":"size","value":"{{size}}"},{"description":{"content":"Optional [Date]: Get fixtures reported on or after this date (YYYY-MM-DD)
\n","type":"text/plain"},"key":"reportedDateAfter","value":"{{reportedDateAfter}}"},{"description":{"content":"Optional [Date]: Get fixtures reported on or before this date (YYYY-MM-DD)
\n","type":"text/plain"},"key":"reportedDateBefore","value":"{{reportedDateBefore}}"},{"description":{"content":"Optional [Date]: Get fixtures with loading window start date after this date (YYYY-MM-DD)
\n","type":"text/plain"},"key":"layCanStartAfter","value":"{{layCanStartAfter}}"},{"description":{"content":"Optional [Date]: Get fixtures with loading window start date before this date (YYYY-MM-DD)
\n","type":"text/plain"},"key":"layCanStartBefore","value":"{{layCanStartBefore}}"},{"description":{"content":"Optional [String]: From names of zones (port/region/country/continent). eg: United States,Europe
\n","type":"text/plain"},"key":"fromZones","value":"{{fromZones}}"},{"description":{"content":"Optional [String]: To names of zones (port/region/country/continent). eg: China,Gulf of Oman
\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 [Integer]: Get vessels with deadweight greater or equal to this value by default 0
\n","type":"text/plain"},"key":"dwtMin","value":"{{dwtMin}}"},{"description":{"content":"Optional [Integer]: Get vessels with deadweight lower or equal to this value by default 606550
\n","type":"text/plain"},"key":"dwtMax","value":"{{dwtMax}}"},{"description":{"content":"Optional [String]: Status of the fixture (On Subs/In Progress/Fully Fixed/Finished/Failed/Cancelled)
\n","type":"text/plain"},"key":"statuses","value":"{{statuses}}"},{"description":{"content":"Optional [String]: For given LPG vessel types\n
Optional [String]: Names of the vessel
\n","type":"text/plain"},"key":"vessels","value":"{{vessels}}"}],"variable":[]}},"response":[],"_postman_id":"a1cacf08-10a6-4a1d-89ee-4c4b9b16155d"}],"id":"a97d9f8d-4c3d-47fb-b49d-aeefbcfe53c5","_postman_id":"a97d9f8d-4c3d-47fb-b49d-aeefbcfe53c5","description":"","auth":{"type":"oauth2","oauth2":{"basicConfig":[]},"isInherited":true,"source":{"_postman_id":"84efbd19-6781-4c01-b037-8afc85d91733","id":"84efbd19-6781-4c01-b037-8afc85d91733","name":"LPG API Direct Access User Guide","type":"collection"}}},{"name":"Bills-of-lading","item":[{"name":"/v1/bills-of-lading","id":"81bc698d-3613-4d7b-a7d4-b15c26440301","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://api-lpg.kpler.com/v1/bills-of-lading?source={{source}}&billDateStart={{billDateStart}}&billDateEnd={{billDateEnd}}&size={{size}}&billNumber={{billNumber}}&movementDateStart={{movementDateStart}}&movementDateEnd={{movementDateEnd}}&portCalls={{portCalls}}","auth":{"type":"oauth2","oauth2":{"basicConfig":[]},"isInherited":true,"source":{"_postman_id":"84efbd19-6781-4c01-b037-8afc85d91733","id":"84efbd19-6781-4c01-b037-8afc85d91733","name":"LPG API Direct Access User Guide","type":"collection"}},"urlObject":{"protocol":"https","path":["v1","bills-of-lading"],"host":["api-lpg","kpler","com"],"query":[{"description":{"content":"Optional [String]: \"US Import BL\" or \"US Export BL\"
\n","type":"text/plain"},"key":"source","value":"{{source}}"},{"description":{"content":"Optional [Date]: Start of the period when BL was issued (YYYY-MM-DD)
\n","type":"text/plain"},"key":"billDateStart","value":"{{billDateStart}}"},{"description":{"content":"Optional [Date]: End of the period when BL was issued (YYYY-MM-DD)
\n","type":"text/plain"},"key":"billDateEnd","value":"{{billDateEnd}}"},{"description":{"content":"Optional [Integer]: Maximum number of BLs returned
\n","type":"text/plain"},"key":"size","value":"{{size}}"},{"description":{"content":"Optional [String]: Bill of Lading Number
\n","type":"text/plain"},"key":"billNumber","value":"{{billNumber}}"},{"description":{"content":"Optional [Date]: Start of the period when export or import took place (YYYY-MM-DD) as reported on the Bill of Lading. \nIf no export/import date is reported on the Bill of Lading, the movementDate is defaulted to the BL issue date
\n","type":"text/plain"},"key":"movementDateStart","value":"{{movementDateStart}}"},{"description":{"content":"Optional [Date]: End of the period when export or import took place (YYYY-MM-DD) as reported on the Bill of Lading. \nIf no export/import date is reported on the Bill of Lading, the movementDate is defaulted to the BL issue date
\n","type":"text/plain"},"key":"movementDateEnd","value":"{{movementDateEnd}}"},{"description":{"content":"Optional [Integer]: Port Call IDs
\n","type":"text/plain"},"key":"portCalls","value":"{{portCalls}}"}],"variable":[]}},"response":[],"_postman_id":"81bc698d-3613-4d7b-a7d4-b15c26440301"}],"id":"2d10e66a-86e4-4ae6-a0c9-d0e0d11db32b","description":"The BoL (bills-of-lading) endpoint returns all the U.S. Import & Export Bills of Lading details as well as a corresponding Port Call ID registered in Kpler system.
\n","_postman_id":"2d10e66a-86e4-4ae6-a0c9-d0e0d11db32b","auth":{"type":"oauth2","oauth2":{"basicConfig":[]},"isInherited":true,"source":{"_postman_id":"84efbd19-6781-4c01-b037-8afc85d91733","id":"84efbd19-6781-4c01-b037-8afc85d91733","name":"LPG API Direct Access User Guide","type":"collection"}}}],"auth":{"type":"oauth2","oauth2":{"basicConfig":[]}},"event":[{"listen":"prerequest","script":{"id":"caa08d05-cd4e-4e8b-87d5-ebc3d314ea93","type":"text/javascript","requests":{},"exec":["// Extract OAuth2 access token from auth configuration and add the X-Access-Token header","if (pm.request.auth && pm.request.auth.type === 'oauth2') {"," const oauth2Array = pm.request.auth.oauth2;"," const accessTokenObj = oauth2Array.find(item => item.key === 'accessToken');"," "," if (accessTokenObj && accessTokenObj.value) {"," pm.request.headers.add({key: 'X-Access-Token', value: accessTokenObj.value});"," pm.request.headers.add({key: 'use-access-token', value: true});"," console.log('Set X-Access-Token from OAuth2 configuration');"," } else {"," console.log('No accessToken found in OAuth2 configuration');"," }","} else {"," console.log('No OAuth2 authentication configured');","}"]}},{"listen":"test","script":{"id":"e9a25c03-f510-42e4-bb8f-1112a4f4c976","type":"text/javascript","requests":{},"exec":[""]}}]}![\"Alt](\"https://kp-prod-public-content.s3-eu-west-1.amazonaws.com/doc/trades_updates_2.gif\")
![\"Alt](\"https://kp-prod-public-content.s3-eu-west-1.amazonaws.com/doc/trades_updates_3.gif\")
\n