{"info":{"_postman_id":"2bd14845-6f1a-4d44-9c9f-2f19f3fe1f3c","name":"Kronoscope","description":"<html><head></head><body><p>Kronoscope APIs are broadly classified as:</p>\n<ol>\n<li><p><strong>Authentication API</strong><br> This API is meant to fetch the auth token to be used in all other APIs.</p>\n</li>\n<li><p><strong>Forecast Data API</strong><br> This API is meant to retrieve predicted forecasts from Kronoscope at any level you want to plan for.</p>\n</li>\n<li><p><strong>Plans Data API</strong><br> This API fetches the purchase or replenishment plans which were frozen in Kronoscope. The plans created consider all the constraints provided to us by the client. All the information needed to reconcile the final order quantites are provided in the response.</p>\n</li>\n<li><p><strong>Data Integration API</strong><br> This API is used for raw data ingestion into Kronoscope.</p>\n</li>\n<li><p><strong>Order Management API</strong><br> This API fetches purchase orders created and the receives tracked using Kronoscope.</p>\n</li>\n</ol>\n</body></html>","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"owner":"21968507","collectionId":"2bd14845-6f1a-4d44-9c9f-2f19f3fe1f3c","publishedId":"2s83zcRRZ2","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"000000","highlight":"000000"},"publishDate":"2022-10-04T10:06:04.000Z"},"item":[{"name":"Authentication","item":[{"name":"Fetch Access Token","id":"ef1cbd8e-2d75-4faa-b1dc-8fc9d3844891","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n    \"user_name\": \"user@acme.com\",\r\n    \"password\": \"testpass\",\r\n    \"is_superuser\": \"false\"\r\n}","options":{"raw":{"language":"json"}}},"url":"https://acme.kronoscope.fountain9.com/atlas/auth/api/token","description":"<h4 id=\"api-endpoint-to-fetch-access-token\">API endpoint to fetch access token</h4>\n<p><code>user_name</code> and <code>password</code> for the tool is required to use this API. Ask the customer success team if you don't already have it.</p>\n","urlObject":{"protocol":"https","path":["atlas","auth","api","token"],"host":["acme","kronoscope","fountain9","com"],"query":[],"variable":[]}},"response":[{"id":"5ce9731d-31d0-4c85-9205-66856792baeb","name":"Get Access Token Example","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n    \"user_name\": \"user@acme.com\",\r\n    \"password\": \"testpass\",\r\n    \"is_superuser\": \"false\"\r\n}","options":{"raw":{"language":"json"}}},"url":"https://acme.kronoscope.fountain9.com/atlas/auth/api/token"},"_postman_previewlanguage":null,"header":null,"cookie":[],"responseTime":null,"body":"{\r\n    \"refresh\": \"eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ0b2tlbl90eXBlIjoicmVmcmVzaCIsImV4cCI6MTY0OTk1NzQzNSwianRpIjoiOWM3MzczOWJiZDQzNDc0OWE2YTE2MjQ5NDBiOTk0YzkiLCJ1c2VyX2lkIjoxLCJzY2hlbWEiOiJmb3h0cm90Y28iLCJzdXBlcnVzZXIiOiJGYWxzZSIsImdyb3VwX3R5cGUiOiJhZG1pbiJ9.uAzbAFbXN3t7I2ml2SbtVDTUwKhCDzfoKzfu5EH9Il1\",\r\n    \"access\": \"eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ0b2tlbl90eXBlIjoiYWNjZXNzIiwiZXhwIjoxNjQ5MzYzNDM1LCJqdGkiOiJkOWM1NTU1OTgyNDY0N2Q2OGI5YmU3MDQzMGQzYjAyMCIsInVzZXJfaWQiOjEsInNjaGVtYSI6ImZveHRyb3RjbyIsInN1cGVydXNlciI6IkZhbHNlIiwiZ3JvdXBfdHlwZSI6ImFkbWluIn0.4buID64Eg0GnUqPM8wmyrEh6VASh2rm3Ywy6o7cPV41\"\r\n}"}],"_postman_id":"ef1cbd8e-2d75-4faa-b1dc-8fc9d3844891"}],"id":"d0e17271-233f-4652-b25d-4dba3fbe7bf1","_postman_id":"d0e17271-233f-4652-b25d-4dba3fbe7bf1","description":""},{"name":"Forecast","item":[{"name":"Fetch Forecast Data","id":"3cef3bf4-8be7-47cb-b43f-3f05076d2271","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"<token>"}]},"isInherited":false},"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n    \"metric\": \"quantity\",\r\n    \"time_granularity\": \"day\",\r\n    \"start_date\": \"2021-12-10\",\r\n    \"end_date\": \"2021-12-10\"\r\n}","options":{"raw":{"language":"json"}}},"url":"https://acme.kronoscope.fountain9.com/atlas/timeseries/api/get_forecast_report?dataset_id=<dataset_id>&sep=<delimiter>","description":"<h4 id=\"api-endpoint-to-fetch-kronoscope-forecasts\">API endpoint to fetch Kronoscope forecasts</h4>\n<p><code>dataset_id</code> and <code>metric</code> values are needed to use this API. Ask the customer success team if you don't already have it.</p>\n<h5 id=\"request-body-field-descriptions\">Request body field descriptions:</h5>\n<p>Required fields are in bold.</p>\n<div class=\"click-to-expand-wrapper is-table-wrapper\"><table>\n<thead>\n<tr>\n<th><strong>Field</strong></th>\n<th><strong>Description</strong></th>\n<th><strong>Example</strong></th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td><strong>start_date</strong></td>\n<td>Forecast start date (YYYY-MM-DD)</td>\n<td>2022-08-20</td>\n</tr>\n<tr>\n<td><strong>end_date</strong></td>\n<td>Forecast end date (YYYY-MM-DD)</td>\n<td>2022-09-20</td>\n</tr>\n<tr>\n<td>filters</td>\n<td>The filter levels for which forecast is needed</td>\n<td>-</td>\n</tr>\n<tr>\n<td><strong>metric</strong></td>\n<td>Metric for which the forecast data is for</td>\n<td>quantity_sold/quantity</td>\n</tr>\n<tr>\n<td><strong>time_granularity</strong></td>\n<td>Time granularity at which the forecast should be aggregated</td>\n<td><strong>Supported values for this field:</strong> day, week, month</td>\n</tr>\n<tr>\n<td>dimensions_to_be_aggregated_on</td>\n<td>Dimensions at which the forecast should be aggregated</td>\n<td>date, sku</td>\n</tr>\n<tr>\n<td>calculate_safety_stock</td>\n<td><code>true</code> or <code>false</code>. If <code>true</code>, then the safety stock column will be available in the response.</td>\n<td>-</td>\n</tr>\n<tr>\n<td>level</td>\n<td>Level that will be used for safety stock calculations</td>\n<td>branch, warehouse</td>\n</tr>\n<tr>\n<td>max_capping_safety_stock_multiplier</td>\n<td>Percentage of predicted forecast at which safety stock will be capped</td>\n<td>if forecast = 200, safety stock = 50 and if max_capping_safety_stock_multiplier = 20, then safety stock = 40 (20% of 200)</td>\n</tr>\n<tr>\n<td>calculate_final_quantity</td>\n<td><code>true</code> or <code>false</code>. If <code>true</code>, it will return Purchase/Replenishment quantity</td>\n<td>-</td>\n</tr>\n</tbody>\n</table>\n</div><h5 id=\"response-field-descriptions\">Response field descriptions:</h5>\n<div class=\"click-to-expand-wrapper is-table-wrapper\"><table>\n<thead>\n<tr>\n<th><strong>Field</strong></th>\n<th><strong>Description</strong></th>\n<th><strong>Datatype</strong></th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>date</td>\n<td>Forecast date</td>\n<td>string</td>\n</tr>\n<tr>\n<td>actual</td>\n<td>Actual data</td>\n<td>float</td>\n</tr>\n<tr>\n<td>predicted_lpi</td>\n<td>Predicted forecast lower bound</td>\n<td>float</td>\n</tr>\n<tr>\n<td>predicted_baseline</td>\n<td>Predicted baseline forecast</td>\n<td>float</td>\n</tr>\n<tr>\n<td>predicted_upi</td>\n<td>Predicted forecast upper bound</td>\n<td>float</td>\n</tr>\n<tr>\n<td>predicted_final</td>\n<td>Predicted forecast considering manual edits if any</td>\n<td>float</td>\n</tr>\n<tr>\n<td>price</td>\n<td>Selling Price</td>\n<td>float</td>\n</tr>\n<tr>\n<td>actual_value</td>\n<td>Actual value</td>\n<td>float</td>\n</tr>\n<tr>\n<td>predicted_baseline_value</td>\n<td>Predicted baseline value</td>\n<td>float</td>\n</tr>\n<tr>\n<td>value</td>\n<td>Predicted value considering manual edits if any</td>\n<td>float</td>\n</tr>\n<tr>\n<td>safety_stock</td>\n<td>Recommended safety stock</td>\n<td>float</td>\n</tr>\n<tr>\n<td><em>rest of the fields</em></td>\n<td>These are the dimensions present in your data that you provided to Fountain9</td>\n<td>string</td>\n</tr>\n</tbody>\n</table>\n</div>","urlObject":{"protocol":"https","path":["atlas","timeseries","api","get_forecast_report"],"host":["acme","kronoscope","fountain9","com"],"query":[{"description":{"content":"<p>Integer</p>\n","type":"text/plain"},"key":"dataset_id","value":"<dataset_id>"},{"description":{"content":"<p>(Optional) Default is \",\"</p>\n","type":"text/plain"},"key":"sep","value":"<delimiter>"}],"variable":[]}},"response":[{"id":"00a08a34-7cc0-49e4-8658-5330463ae83b","name":"Get Forecast Data Example 1","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n    \"metric\": \"quantity_sold\",\r\n    \"time_granularity\": \"week\",\r\n    \"start_date\": \"2022-08-01\",\r\n    \"end_date\": \"2022-08-20\",\r\n    \"level\": \"branch_id\",\r\n    \"filters\": {},\r\n    \"max_capping_safety_stock_multiplier\": 10,\r\n    \"dimensions_to_be_aggregated_on\": []\r\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"https://acme.kronoscope.fountain9.com/atlas/timeseries/api/get_forecast_report?dataset_id=1","protocol":"https","host":["acme","kronoscope","fountain9","com"],"path":["atlas","timeseries","api","get_forecast_report"],"query":[{"key":"dataset_id","value":"1","description":"Integer"}]}},"_postman_previewlanguage":null,"header":null,"cookie":[],"responseTime":null,"body":"date,active_status,branch_city,branch_id,branch_name,branch_region,brand_tag,bundle_type,category_1,category_1_group,category_2,category_3,end_date,intermediary_node_1,launch_date,price_range,shelf_life,sku_id,sku_name,source_node,actual,predicted_lpi,predicted_baseline,predicted_upi,predicted_final,price,actual_value,predicted_baseline_value,value\r\n2022-08-14,ACTIVE,Seattle,14,Capitol Hill,WA,Fountain9 Cafe,none,in store cafe,in store cafe,cafe drinks,cafe coffee,Not Specified,Capitol Hill,Not Specified,medium,500,57712,Draft Cold Brew,Capitol Hill,423.0,0,490.0,0,490.0,4.0,1692.0,1960.0,1960.0\r\n2022-08-14,ACTIVE,Seattle,8,Magnolia,WA,Fountain9 Cafe,none,in store cafe,in store cafe,cafe drinks,cafe coffee,Not Specified,Magnolia,Not Specified,medium,500,57712,Draft Cold Brew,Magnolia,439.0,0,490.0,0,490.0,4.0,1756.0,1960.0,1960.0"},{"id":"ad89361c-2511-4446-93d6-86b9aa8379c4","name":"Get Forecast Data Example 2","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n    \"metric\": \"quantity_sold\",\r\n    \"time_granularity\": \"day\",\r\n    \"start_date\": \"2022-08-01\",\r\n    \"end_date\": \"2022-08-20\",\r\n    \"filters\":\r\n    {\r\n        \"category_1\": [\"prepared foods\"],\r\n        \"city\": [\"Mumbai\", \"Delhi\"]\r\n    },\r\n    \"calculate_safety_stock\": true,\r\n    \"level\": \"branch_id\",\r\n    \"max_capping_safety_stock_multiplier\": 10,\r\n    \"dimensions_to_be_aggregated_on\": [\"date\", \"branch_id\"]\r\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"https://acme.kronoscope.fountain9.com/atlas/timeseries/api/get_forecast_report?dataset_id=1","protocol":"https","host":["acme","kronoscope","fountain9","com"],"path":["atlas","timeseries","api","get_forecast_report"],"query":[{"key":"dataset_id","value":"1","description":"Integer"}]}},"_postman_previewlanguage":null,"header":null,"cookie":[],"responseTime":null,"body":"date,branch_id,actual,predicted_lpi,predicted_baseline,predicted_upi,predicted_final,price,actual_value,predicted_baseline_value,value,safety_stock\r\n2022-08-14,11,1980.0,0,2258.0,0,2258.0,8.62,18118.49,20203.91,20203.91,225.8\r\n2022-08-14,8,1683.0,0,2024.0,0,2024.0,8.99,16822.59,18070.59,18070.59,202.4"}],"_postman_id":"3cef3bf4-8be7-47cb-b43f-3f05076d2271"}],"id":"28eb7270-b5b5-4dd2-b63a-617660fca416","_postman_id":"28eb7270-b5b5-4dd2-b63a-617660fca416","description":""},{"name":"Plans","item":[{"name":"Get Plans List","id":"46417dd7-1aa3-4617-8e71-023af3fdfe86","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"<token>"}]},"isInherited":false},"method":"GET","header":[],"url":"https://acme.kronoscope.fountain9.com/atlas/timeseries/api/get_plans_list?dataset_id=<dataset_id>&created_date=<date>&updated_date=<date>&user_name=<user_name>","description":"<h4 id=\"api-endpoint-to-get-a-list-of-plans-that-were-frozen-in-kronoscope-at-a-particular-date\">API endpoint to get a list of plans that were frozen in Kronoscope at a particular date</h4>\n<p><code>dataset_id</code> value is needed to use this API. Ask the customer success team if you don't already have it.</p>\n<p>If both <code>created_date</code> and <code>updated_date</code> are mentioned, then it is an AND operation.</p>\n","urlObject":{"protocol":"https","path":["atlas","timeseries","api","get_plans_list"],"host":["acme","kronoscope","fountain9","com"],"query":[{"description":{"content":"<p>Integer value </p>\n","type":"text/plain"},"key":"dataset_id","value":"<dataset_id>"},{"description":{"content":"<p>(Optional) Plans with created_date greater than or equal to will be returned\nDate format: YYYY-MM-DD HH:MM:SS (UTC time)</p>\n","type":"text/plain"},"key":"created_date","value":"<date>"},{"description":{"content":"<p>(Optional) Plans with updated_date greater than or equal to will be returned\nDate format: YYYY-MM-DD HH:MM:SS (UTC time)</p>\n","type":"text/plain"},"key":"updated_date","value":"<date>"},{"description":{"content":"<p>(Optional) Login username</p>\n","type":"text/plain"},"key":"user_name","value":"<user_name>"}],"variable":[]}},"response":[{"id":"82b0322c-b198-4fc5-8539-e7b752c1528b","name":"Get Plans List Example","originalRequest":{"method":"GET","header":[],"url":{"raw":"https://acme.kronoscope.fountain9.com/atlas/timeseries/api/get_plans_list?dataset_id=1&created_date=2022-04-06 00:00:00&user_name=max@acme.com","protocol":"https","host":["acme","kronoscope","fountain9","com"],"path":["atlas","timeseries","api","get_plans_list"],"query":[{"key":"dataset_id","value":"1"},{"key":"created_date","value":"2022-04-06 00:00:00"},{"key":"user_name","value":"max@acme.com"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Thu, 07 Apr 2022 17:40:11 GMT"},{"key":"Content-Type","value":"application/json"},{"key":"Content-Length","value":"460"},{"key":"Connection","value":"keep-alive"},{"key":"Server","value":"nginx"},{"key":"Vary","value":"Accept, Origin, Accept-Encoding"},{"key":"Allow","value":"GET, HEAD, OPTIONS"},{"key":"X-Frame-Options","value":"SAMEORIGIN"},{"key":"Content-Encoding","value":"gzip"}],"cookie":[],"responseTime":null,"body":"{\n    \"plans_list\": [\n        {\n            \"plan_id\": \"All_Fixed_Duration_Purchase_Plan_2022_04_07_10_41_08\",\n            \"plan_name\": \"All - Fixed Duration Purchase Plan 2022_04_07_10_41_08\",\n            \"user_name\": \"max@acme.com\",\n            \"creation_date\": \"2022-04-07T15:41:08Z\",\n            \"updated_date\": \"2022-04-07T15:41:08Z\",\n            \"plan_type\": \"Purchase Plan\"\n        },\n        {\n            \"plan_id\": \"All_Fixed_Schedule_Purchase_Plan_2022_04_07_10_28_07\",\n            \"plan_name\": \"All - Fixed Schedule Purchase Plan 2022_04_07_10_28_07\",\n            \"user_name\": \"max@acme.com\",\n            \"creation_date\": \"2022-04-07T15:28:07Z\",\n            \"updated_date\": \"2022-04-07T15:28:07Z\",\n            \"plan_type\": \"Purchase Plan\"\n        },\n        {\n            \"plan_id\": \"All_Fixed_Duration_Purchase_Plan_2022_04_07_09_48_15\",\n            \"plan_name\": \"All - Fixed Duration Purchase Plan 2022_04_07_09_48_15\",\n            \"user_name\": \"max@acme.com\",\n            \"creation_date\": \"2022-04-07T14:48:15Z\",\n            \"updated_date\": \"2022-04-07T14:48:15Z\",\n            \"plan_type\": \"Purchase Plan\"\n        },\n        {\n            \"plan_id\": \"All_Fixed_Schedule_Replenishment_Plan_2022_04_07_09_45_37\",\n            \"plan_name\": \"All - Fixed Schedule Replenishment Plan 2022_04_07_09_45_37\",\n            \"user_name\": \"max@acme.com\",\n            \"creation_date\": \"2022-04-07T14:45:37Z\",\n            \"updated_date\": \"2022-04-07T14:45:37Z\",\n            \"plan_type\": \"Replenishment Plan\"\n        }\n    ]\n}"}],"_postman_id":"46417dd7-1aa3-4617-8e71-023af3fdfe86"},{"name":"Get Plans Data","id":"0d20b02b-044c-481b-8944-9690378365dd","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"<token>"}]},"isInherited":false},"method":"GET","header":[],"url":"https://acme.kronoscope.fountain9.com/atlas/timeseries/api/get_plans_data?dataset_id=<dataset_id>&plan_id=<plan id>&plan_type=<plan type>&sep=<csv delimiter>","description":"<h4 id=\"api-endpoint-to-fetch-a-frozen-purchasereplenishment-plan\">API endpoint to fetch a frozen purchase/replenishment plan</h4>\n<p><code>dataset_id</code> value is needed to use this API. Ask the customer success team if you don't already have it.</p>\n<p><strong>Fields in response when plan_type = \"Purchase Plan\"</strong></p>\n<div class=\"click-to-expand-wrapper is-table-wrapper\"><table>\n<thead>\n<tr>\n<th><strong>Field</strong></th>\n<th><strong>Description</strong></th>\n<th><strong>Datatype</strong></th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>branch_id</td>\n<td>Branch ID of the destination branch (for purchase order)</td>\n<td>string</td>\n</tr>\n<tr>\n<td>level_id</td>\n<td>Branch Name</td>\n<td>string</td>\n</tr>\n<tr>\n<td>sku_id</td>\n<td>SKU ID</td>\n<td>string</td>\n</tr>\n<tr>\n<td>sku_name</td>\n<td>SKU Name</td>\n<td>string</td>\n</tr>\n<tr>\n<td>hml_category</td>\n<td>Whether this SKU is classified a high/medium/low value SKU</td>\n<td>string</td>\n</tr>\n<tr>\n<td>mapped_user</td>\n<td>Vendor owner ID</td>\n<td>string</td>\n</tr>\n<tr>\n<td>batch_size</td>\n<td>Case size of the SKU</td>\n<td>integer</td>\n</tr>\n<tr>\n<td>primary_supplier_id</td>\n<td>Vendor ID of primary vendor for the SKU at the selected branch</td>\n<td>string</td>\n</tr>\n<tr>\n<td>primary_supplier_name</td>\n<td>Name of primary vendor for the SKU at the selected branch</td>\n<td>string</td>\n</tr>\n<tr>\n<td>primary_supplier_lead_time_in_days</td>\n<td>Delivery lead time primary vendor for the SKU at the selected branch</td>\n<td>integer</td>\n</tr>\n<tr>\n<td>preferred_supplier_price_avg</td>\n<td>Average price at which the primary vendor delivers the SKU at the selected branch</td>\n<td>float</td>\n</tr>\n<tr>\n<td>duration</td>\n<td>Difference between start and end date for which the purchase order is generated. Purchase order is generated to fulfill demand for this number of days at the destination branch</td>\n<td>integer</td>\n</tr>\n<tr>\n<td>plan_start_date</td>\n<td>Start date of the period for which purchase order is generated</td>\n<td>string</td>\n</tr>\n<tr>\n<td>plan_end_date</td>\n<td>End date of the period for which purchase order is generated</td>\n<td>string</td>\n</tr>\n<tr>\n<td>predicted_demand_for_selected_duration</td>\n<td>F9 predicted demand for this duration (between start and end date)</td>\n<td>float</td>\n</tr>\n<tr>\n<td>current_inventory</td>\n<td>Destination branch latest inventory</td>\n<td>float</td>\n</tr>\n<tr>\n<td>current_inventory_runway</td>\n<td>Number of days of inventory at the destination branch</td>\n<td>integer</td>\n</tr>\n<tr>\n<td>safety_stock</td>\n<td>Safety stock added to the predicted demand (in units)</td>\n<td>float</td>\n</tr>\n<tr>\n<td>lead_time_demand</td>\n<td>Demand of the SKU at the destination branch during the lead time. The destination branch inventory will go down by this number by the time the purchase order arrives in the destination branch.</td>\n<td>float</td>\n</tr>\n<tr>\n<td>historical_60day_average_daily_sales</td>\n<td>Average sale units per day calculated over last 60 days</td>\n<td>float</td>\n</tr>\n<tr>\n<td>historical_7day_average_daily_sales</td>\n<td>Average sale units per day calculated over last 7 days</td>\n<td>float</td>\n</tr>\n<tr>\n<td>open_orders</td>\n<td>Any existing open orders for the SKU at the destination branch</td>\n<td>float</td>\n</tr>\n<tr>\n<td>net_interstore_transfers</td>\n<td>Any existing open transfer orders at the destination branch is expected to receive</td>\n<td>float</td>\n</tr>\n<tr>\n<td>minimum_presentation_quantity</td>\n<td>Minimum presentation quantity for the SKU at the destination branch</td>\n<td>integer</td>\n</tr>\n<tr>\n<td>minimun_order_quantity</td>\n<td>Minimum order quantity for the SKU at the destination branch</td>\n<td>integer</td>\n</tr>\n<tr>\n<td>purchase_quantity_for_selected_duration</td>\n<td>Indent or purchase order recommendation in units (predicted demand + safety stock + lead time demand - current inventory at the destination branch - open orders - net interstore transfers)</td>\n<td>float</td>\n</tr>\n<tr>\n<td>purchase_quantity_for_selected_duration_min_value_adjusted</td>\n<td>Purchase quantity (in units) after vendor order minimum (across SKUs) rounding up</td>\n<td>float</td>\n</tr>\n<tr>\n<td>purchase_quantity_for_selected_duration_min_value_adjusted_editable</td>\n<td>Same as above column but edited by user (increase or decrease)</td>\n<td>float</td>\n</tr>\n<tr>\n<td>purchase_quantity_for_selected_duration_diff</td>\n<td>Difference between raw purchase quantity and vendor minimum rounded quantity</td>\n<td>float</td>\n</tr>\n<tr>\n<td>duration_min_value_adjusted</td>\n<td>Days of supply for the SKU after vendor minimum rounding is applied</td>\n<td>integer</td>\n</tr>\n<tr>\n<td>purchase_value_for_for_selected_duration_min_value_adjusted</td>\n<td>Purchase value after vendor order minimum (across SKUs) rounding up</td>\n<td>float</td>\n</tr>\n<tr>\n<td>sales_value_for_selected_duration_min_value_adjusted</td>\n<td>Sale value (revenue) expected for this purchase</td>\n<td>float</td>\n</tr>\n<tr>\n<td>max_doh</td>\n<td>Max DOH recommended for the SKU at the destination branch based on shelf life</td>\n<td>integer</td>\n</tr>\n<tr>\n<td>supplier_minimum_met</td>\n<td>Flag to indicate if vendor minimum was met before max DOH threshold was met for all SKU from the vendor</td>\n<td>string</td>\n</tr>\n<tr>\n<td>comments</td>\n<td>User comments</td>\n<td>string</td>\n</tr>\n<tr>\n<td>seasonal_impact</td>\n<td></td>\n<td></td>\n</tr>\n</tbody>\n</table>\n</div><p><strong>Fields in response when plan_type = \"Replenishment Plan\"</strong></p>\n<div class=\"click-to-expand-wrapper is-table-wrapper\"><table>\n<thead>\n<tr>\n<th><strong>Field</strong></th>\n<th><strong>Description</strong></th>\n<th><strong>Datatype</strong></th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>branch_id</td>\n<td>Branch ID of the destination branch (for purchase order)</td>\n<td>string</td>\n</tr>\n<tr>\n<td>level_id</td>\n<td>Branch Name</td>\n<td>string</td>\n</tr>\n<tr>\n<td>sku_id</td>\n<td>SKU ID</td>\n<td>string</td>\n</tr>\n<tr>\n<td>sku_name</td>\n<td>SKU Name</td>\n<td>string</td>\n</tr>\n<tr>\n<td>warehouse_branch_id</td>\n<td>Branch ID of the source branch (for transfer order)</td>\n<td>string</td>\n</tr>\n<tr>\n<td>warehouse_id</td>\n<td>Branch name of the source branch (for transfer order)</td>\n<td>string</td>\n</tr>\n<tr>\n<td>hml_category</td>\n<td>Whether this SKU is classified a high/medium/low value SKU</td>\n<td>string</td>\n</tr>\n<tr>\n<td>warehouse_inventory</td>\n<td>Latest stock for the SKU in the source branch</td>\n<td>integer</td>\n</tr>\n<tr>\n<td>safety_stock_days</td>\n<td>Safety stock of the SKU expressed as number of days of inventory</td>\n<td>integer</td>\n</tr>\n<tr>\n<td>lead_time</td>\n<td>Delivery time from source to destination branch in days</td>\n<td>integer</td>\n</tr>\n<tr>\n<td>duration</td>\n<td>Difference between start and end date for which the purchase order is generated. Tranfer order is generated to fulfill demand for this number of days at the destination branch</td>\n<td>integer</td>\n</tr>\n<tr>\n<td>plan_start_date</td>\n<td>Start date of the transfer order</td>\n<td>string</td>\n</tr>\n<tr>\n<td>plan_end_date</td>\n<td>End date of the transfer order</td>\n<td>string</td>\n</tr>\n<tr>\n<td>predicted_demand_for_selected_duration</td>\n<td>F9 predicted demand for this duration (between start and end date)</td>\n<td>float</td>\n</tr>\n<tr>\n<td>current_inventory</td>\n<td>Destination branch latest inventory</td>\n<td>float</td>\n</tr>\n<tr>\n<td>current_inventory_runway</td>\n<td>Number of days of inventory at the destination branch</td>\n<td>integer</td>\n</tr>\n<tr>\n<td>safety_stock</td>\n<td>Safety stock added to the predicted demand (in units)</td>\n<td>float</td>\n</tr>\n<tr>\n<td>lead_time_demand</td>\n<td>Demand of the SKU at the destination branch during the lead time. The destination branch inventory will go down by this number by the time the purchase order arrives in the destination branch.</td>\n<td>float</td>\n</tr>\n<tr>\n<td>historical_60day_average_daily_sales</td>\n<td>Average sale units per day calculated over last 60 days</td>\n<td>float</td>\n</tr>\n<tr>\n<td>historical_7day_average_daily_sales</td>\n<td>Average sale units per day calculated over last 7 days</td>\n<td>float</td>\n</tr>\n<tr>\n<td>open_orders</td>\n<td>Any existing open orders for the SKU at the destination branch</td>\n<td>float</td>\n</tr>\n<tr>\n<td>net_interstore_transfers</td>\n<td>Any existing open transfer orders at the destination branch is expected to receive</td>\n<td>float</td>\n</tr>\n<tr>\n<td>minimum_presentation_quantity</td>\n<td>Minimum presentation quantity for the SKU at the destination branch</td>\n<td>integer</td>\n</tr>\n<tr>\n<td>replenishment_quantity_for_selected_duration</td>\n<td>Final indent or transfer order recommendation in units (predicted demand + safety stock + lead time demand - current inventory at the destination branch - open orders - net interstore transfers)</td>\n<td>float</td>\n</tr>\n<tr>\n<td>replenishment_quantity_for_selected_duration_editable</td>\n<td>Same as above but edited by user (increased or decreased)</td>\n<td>float</td>\n</tr>\n<tr>\n<td>allocated_quantity</td>\n<td>If inventory at the source branch is constrained/limited, this is the number of units that still can be transferred to the destination branch to minimize the stock outs</td>\n<td>float</td>\n</tr>\n<tr>\n<td>comments</td>\n<td>User comments</td>\n<td>string</td>\n</tr>\n</tbody>\n</table>\n</div>","urlObject":{"protocol":"https","path":["atlas","timeseries","api","get_plans_data"],"host":["acme","kronoscope","fountain9","com"],"query":[{"description":{"content":"<p>Integer</p>\n","type":"text/plain"},"key":"dataset_id","value":"<dataset_id>"},{"description":{"content":"<p>String</p>\n","type":"text/plain"},"key":"plan_id","value":"<plan id>"},{"description":{"content":"<p>String</p>\n","type":"text/plain"},"key":"plan_type","value":"<plan type>"},{"description":{"content":"<p>(Optional) Default is \",\"</p>\n","type":"text/plain"},"key":"sep","value":"<csv delimiter>"}],"variable":[]}},"response":[{"id":"bff30779-47c0-438f-a2c8-f82b1ee26ed3","name":"Get Purchase Plans Data Example","originalRequest":{"method":"GET","header":[],"url":{"raw":"https://domain.kronoscope.fountain9.com/atlas/timeseries/api/get_plans_data?dataset_id=1&plan_id=All_Fixed_Duration_Purchase_Plan_2022_09_01_12_29_37&plan_type=Purchase Plan","protocol":"https","host":["domain","kronoscope","fountain9","com"],"path":["atlas","timeseries","api","get_plans_data"],"query":[{"key":"dataset_id","value":"1"},{"key":"plan_id","value":"All_Fixed_Duration_Purchase_Plan_2022_09_01_12_29_37"},{"key":"plan_type","value":"Purchase Plan"}]}},"status":"OK","code":200,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Thu, 07 Apr 2022 17:42:03 GMT"},{"key":"Content-Type","value":"text/csv"},{"key":"Content-Length","value":"11960"},{"key":"Connection","value":"keep-alive"},{"key":"Server","value":"nginx"},{"key":"Content-Disposition","value":"attachment; filename=\"All_Fixed_Duration_Purchase_Plan_2022_04_07_10_41_08.csv\""},{"key":"Vary","value":"Accept, Origin, Accept-Encoding"},{"key":"Allow","value":"GET, HEAD, OPTIONS"},{"key":"X-Frame-Options","value":"SAMEORIGIN"},{"key":"Content-Encoding","value":"gzip"}],"cookie":[],"responseTime":null,"body":"level_id,sku_id,sku_name,hml_category,mapped_user,primary_supplier_id,primary_supplier_name,primary_supplier_lead_time_in_days,batch_size,preferred_supplier_price_avg,open_orders,net_interstore_transfers,current_inventory,lead_time_demand,predicted_inventory_at_start_of_selected_duration,plan_start_date,plan_end_date,duration,predicted_demand_for_selected_duration,historical_60day_average_daily_sales,historical_7day_average_daily_sales,current_inventory_runway,safety_stock,minimun_order_quantity,minimum_presentation_quantity,purchase_quantity_for_selected_duration,purchase_quantity_for_selected_duration_min_value_adjusted,purchase_quantity_for_selected_duration_min_value_adjusted_editable,purchase_quantity_for_selected_duration_diff,duration_min_value_adjusted,purchase_value_for_for_selected_duration_min_value_adjusted,sales_value_for_selected_duration_min_value_adjusted,supplier_minimum_met,max_doh,comments,seasonal_impact\nMumbai,1,Orange,high,-,237,Juicery,4,6,0,0,0,0,5,-19,2022-04-19,2022-05-01,14,19,0,0,0,1,1,1,25,24,18,-1,14,0.0,0.0,TRUE,150,Add Comment,0\nMumbai,2,Apple,high,-,237,Juicery,4,6,0,0,0,0,5,-19,2022-04-18,2022-05-01,14,19,0,0,0,1,1,1,25,24,48,-1,14,0.0,0.0,TRUE,150,Add Comment,0\n"},{"id":"7d268185-f606-4240-be8b-b0367c20c159","name":"Get Replenishment Plans Data Example","originalRequest":{"method":"GET","header":[],"url":{"raw":"https://domain.kronoscope.fountain9.com/atlas/timeseries/api/get_plans_data?dataset_id=1&plan_id=All_Fixed_Duration_Replenishment_Plan_2022_09_01_12_29_37&plan_type=Replenishment Plan","protocol":"https","host":["domain","kronoscope","fountain9","com"],"path":["atlas","timeseries","api","get_plans_data"],"query":[{"key":"dataset_id","value":"1"},{"key":"plan_id","value":"All_Fixed_Duration_Replenishment_Plan_2022_09_01_12_29_37"},{"key":"plan_type","value":"Replenishment Plan"}]}},"status":"OK","code":200,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Thu, 07 Apr 2022 17:42:03 GMT"},{"key":"Content-Type","value":"text/csv"},{"key":"Content-Length","value":"11960"},{"key":"Connection","value":"keep-alive"},{"key":"Server","value":"nginx"},{"key":"Content-Disposition","value":"attachment; filename=\"All_Fixed_Duration_Purchase_Plan_2022_04_07_10_41_08.csv\""},{"key":"Vary","value":"Accept, Origin, Accept-Encoding"},{"key":"Allow","value":"GET, HEAD, OPTIONS"},{"key":"X-Frame-Options","value":"SAMEORIGIN"},{"key":"Content-Encoding","value":"gzip"}],"cookie":[],"responseTime":null,"body":"level_id,sku_id,sku_name,warehouse_id,branch_id,hml_category,warehouse_branch_id,warehouse_inventory,lead_time,open_orders,net_interstore_transfers,current_inventory,lead_time_demand,plan_start_date,plan_end_date,duration,predicted_demand_for_selected_duration,historical_60day_average_daily_sales,historical_7day_average_daily_sales,current_inventory_runway,safety_stock,safety_stock_days,minimum_presentation_quantity,batch_size,replenishment_quantity_for_selected_duration,replenishment_quantity_for_selected_duration_editable,allocated_quantity,comments\nBranch 1,6100,iHealth COVID Test,Branch 2,1,low,2,0,3,0,0,0,5,2022-07-14,2022-07-20,7,7,0.27,0.0,0,6,5.0,6,1,18,0,0,Add Comment\nBranch 3,6100,iHealth COVID Test,Branch 4,3,low,2,0,3,0,0,0,4,2022-07-14,2022-07-20,7,5,0.27,0.0,0,6,6.67,6,1,15,0,0,Add Comment\nBranch 1,5900,Coconut Milk Hand Mask,Branch 2,1,low,300,23,2,0,0,0,0,2022-07-13,2022-07-15,3,4,0.1,0.0,0,6,7.5,6,50,10,0,10,Add Comment"}],"_postman_id":"0d20b02b-044c-481b-8944-9690378365dd"}],"id":"43de8e03-c6ae-4fbe-95be-033fd9cfc72f","_postman_id":"43de8e03-c6ae-4fbe-95be-033fd9cfc72f","description":""},{"name":"Data Integration","item":[{"name":"Create Mapping","event":[{"listen":"test","script":{"id":"af6a6740-959a-4358-b299-a6553aea59f1","exec":[""],"type":"text/javascript","packages":{}}}],"id":"180d0139-cb10-4ea6-bf80-6711df7e8bf6","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"<token>"}]},"isInherited":false},"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n    \"payload\": [\r\n        {\r\n            \"column_name\": \"sku_id\",\r\n            \"display_name\": \"SKU ID\",\r\n            \"type\": \"sales\",\r\n            \"data_type\": \"int\",\r\n            \"dataset_id\": 1\r\n        },\r\n        {\r\n            \"column_name\": \"sales_date\",\r\n            \"display_name\": \"Sales Date\",\r\n            \"type\": \"sales\",\r\n            \"data_type\": \"date\",\r\n            \"dataset_id\": 1\r\n        }\r\n    ]\r\n}","options":{"raw":{"language":"json"}}},"url":"https://acme.kronoscope.fountain9.com/atlas/data_integration/mapping/create?dataset_id=<dataset_id>","description":"<h3 id=\"api-to-create-column-definition-and-mapping\">API to create column definition and mapping</h3>\n<h4 id=\"request-body\">Request Body</h4>\n<p>The following is the structure of the request JSON.</p>\n<pre class=\"click-to-expand-wrapper is-snippet-wrapper\"><code class=\"language-json\">{\n\"payload\": {}\n}\n\n</code></pre>\n<p>The following are the fields that are needed:</p>\n<div class=\"click-to-expand-wrapper is-table-wrapper\"><table>\n<thead>\n<tr>\n<th>Field</th>\n<th>Description</th>\n<th>Datatype</th>\n<th><strong>Supported Values</strong></th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>column_name</td>\n<td>Name of the column in the data</td>\n<td>string</td>\n<td>-</td>\n</tr>\n<tr>\n<td>display_name</td>\n<td>Name of the column that will be displayed in the tool</td>\n<td>string</td>\n<td>-</td>\n</tr>\n<tr>\n<td>format</td>\n<td>Format of the field required for date fields</td>\n<td>string</td>\n<td>-</td>\n</tr>\n<tr>\n<td>show_in_tool</td>\n<td>Indicates whether the column should be displayed in the tool</td>\n<td>boolean</td>\n<td>-</td>\n</tr>\n<tr>\n<td>type</td>\n<td>Type of dataset</td>\n<td>string</td>\n<td>sales, inventory, product_master, branch_master, purchase_orders, transfer_orders, supplier_master, raw_material_master, products_branches_suppliers, products_branches_warehouses, external_variable</td>\n</tr>\n<tr>\n<td>data_type</td>\n<td>The data type of the column</td>\n<td>string</td>\n<td>int, float, string, date</td>\n</tr>\n<tr>\n<td>dataset_id</td>\n<td>Dataset ID provided</td>\n<td>integer</td>\n<td>-</td>\n</tr>\n</tbody>\n</table>\n</div><h5 id=\"once-you-are-done-creating-the-mapping-please-inform-the-customer-success-team-to-enable-data-ingestion\">Once you are done creating the mapping, please inform the customer success team to enable data ingestion.</h5>\n","urlObject":{"protocol":"https","path":["atlas","data_integration","mapping","create"],"host":["acme","kronoscope","fountain9","com"],"query":[{"description":{"content":"<p>Integer</p>\n","type":"text/plain"},"key":"dataset_id","value":"<dataset_id>"}],"variable":[]}},"response":[{"id":"38676057-4b59-468a-aa95-92c576d3441d","name":"Sales Example","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n    \"payload\": [\r\n        {\r\n            \"column_name\": \"sku_id\",\r\n            \"display_name\": \"SKU ID\",\r\n            \"type\": \"sales\",\r\n            \"data_type\": \"int\",\r\n            \"dataset_id\": 1\r\n        },\r\n        {\r\n            \"column_name\": \"sales_date\",\r\n            \"display_name\": \"Sales Date\",\r\n            \"type\": \"sales\",\r\n            \"data_type\": \"date\",\r\n            \"dataset_id\": 1\r\n        },\r\n        {\r\n            \"column_name\": \"branch_name\",\r\n            \"display_name\": \"Branch Name\",\r\n            \"type\": \"sales\",\r\n            \"data_type\": \"str\",\r\n            \"dataset_id\": 1\r\n        },\r\n        {\r\n            \"column_name\": \"quantity\",\r\n            \"display_name\": \"Quantity\",\r\n            \"type\": \"sales\",\r\n            \"data_type\": \"float\",\r\n            \"dataset_id\": 1\r\n        }\r\n    ]\r\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"https://acme.kronoscope.fountain9.com/atlas/data_integration/mapping/create?dataset_id=1","protocol":"https","host":["acme","kronoscope","fountain9","com"],"path":["atlas","data_integration","mapping","create"],"query":[{"key":"dataset_id","value":"1","description":"Integer"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"success\"\n}"},{"id":"20eb3c7f-b71b-4fbc-b2df-7214798a46e3","name":"Products-Branches-Suppliers Example","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n    \"payload\": [\r\n        {\r\n            \"column_name\": \"sku_id\",\r\n            \"display_name\": \"SKU ID\",\r\n            \"type\": \"products_branches_suppliers\",\r\n            \"data_type\": \"int\",\r\n            \"dataset_id\": 1\r\n        },\r\n        {\r\n            \"column_name\": \"supplier_id\",\r\n            \"display_name\": \"Supplier ID\",\r\n            \"type\": \"products_branches_suppliers\",\r\n            \"data_type\": \"int\",\r\n            \"dataset_id\": 1\r\n        },\r\n        {\r\n            \"column_name\": \"branch_name\",\r\n            \"display_name\": \"Branch Name\",\r\n            \"type\": \"products_branches_suppliers\",\r\n            \"data_type\": \"str\",\r\n            \"dataset_id\": 1\r\n        },\r\n        {\r\n            \"column_name\": \"lead_time\",\r\n            \"display_name\": \"Lead Time\",\r\n            \"type\": \"products_branches_suppliers\",\r\n            \"data_type\": \"string\",\r\n            \"dataset_id\": 1\r\n        },\r\n        {\r\n            \"column_name\": \"moq\",\r\n            \"display_name\": \"MOQ\",\r\n            \"type\": \"products_branches_suppliers\",\r\n            \"data_type\": \"float\",\r\n            \"dataset_id\": 1\r\n        }\r\n    ]\r\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"https://acme.kronoscope.fountain9.com/atlas/data_integration/mapping/create?dataset_id=1","protocol":"https","host":["acme","kronoscope","fountain9","com"],"path":["atlas","data_integration","mapping","create"],"query":[{"key":"dataset_id","value":"1","description":"Integer"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"success\"\n}"}],"_postman_id":"180d0139-cb10-4ea6-bf80-6711df7e8bf6"},{"name":"Read Mapping","id":"5a30f869-5d2f-495d-96e1-07819f6dce13","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"<token>"}]},"isInherited":false},"method":"GET","header":[],"body":{"mode":"raw","raw":"{\r\n    \"search_filter\": {\r\n        \"column_name\": \"sku_id\",\r\n        \"type\": \"sales\",\r\n        \"dataset_id\": 1\r\n    }\r\n}","options":{"raw":{"language":"json"}}},"url":"https://acme.kronoscope.fountain9.com/atlas/data_integration/mapping/read?dataset_id=<dataset_id>","description":"<h3 id=\"api-to-read-column-definition-and-mapping\">API to read column definition and mapping</h3>\n<h4 id=\"request-body\">Request Body</h4>\n<p>Request body should contain filters for the rows that need to be read.</p>\n<p>The following is the structure of the request JSON.</p>\n<pre class=\"click-to-expand-wrapper is-snippet-wrapper\"><code class=\"language-json\">{\n\"search_filter\": {}\n}\n\n</code></pre>\n<p>The following are the fields that can used to filter rows that need to be read:</p>\n<div class=\"click-to-expand-wrapper is-table-wrapper\"><table>\n<thead>\n<tr>\n<th>Field</th>\n<th>Description</th>\n<th>Datatype</th>\n<th><strong>Supported Values</strong></th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>column_name</td>\n<td>Name of the column in the data</td>\n<td>string</td>\n<td>-</td>\n</tr>\n<tr>\n<td>display_name</td>\n<td>Name of the column that will be displayed in the tool</td>\n<td>string</td>\n<td>-</td>\n</tr>\n<tr>\n<td>format</td>\n<td>Format of the field required for date fields</td>\n<td>string</td>\n<td>-</td>\n</tr>\n<tr>\n<td>show_in_tool</td>\n<td>Indicates whether the column should be displayed in the tool</td>\n<td>boolean</td>\n<td>-</td>\n</tr>\n<tr>\n<td>type</td>\n<td>Type of dataset</td>\n<td>string</td>\n<td>sales, inventory, product_master, branch_master, purchase_orders, transfer_orders, supplier_master, raw_material_master, products_branches_suppliers, products_branches_warehouses, external_variable</td>\n</tr>\n<tr>\n<td>data_type</td>\n<td>The data type of the column</td>\n<td>string</td>\n<td>int, float, string, list, date</td>\n</tr>\n<tr>\n<td>dataset_id</td>\n<td>Dataset ID provided</td>\n<td>integer</td>\n<td>-</td>\n</tr>\n</tbody>\n</table>\n</div>","urlObject":{"protocol":"https","path":["atlas","data_integration","mapping","read"],"host":["acme","kronoscope","fountain9","com"],"query":[{"description":{"content":"<p>Integer</p>\n","type":"text/plain"},"key":"dataset_id","value":"<dataset_id>"}],"variable":[]}},"response":[{"id":"def33286-f412-47df-9aea-ff0163f02d8c","name":"Read Mapping Example","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n    \"search_filter\": {\r\n        \"column_name\": [\r\n            \"product_id\",\r\n            \"moq\"\r\n        ],\r\n        \"type\": \"product_master\",\r\n        \"dataset_id\": 1\r\n    }\r\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"https://acme.kronoscope.fountain9.com/atlas/data_integration/mapping/read?dataset_id=1","protocol":"https","host":["acme","kronoscope","fountain9","com"],"path":["atlas","data_integration","mapping","read"],"query":[{"key":"dataset_id","value":"1"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"success\",\n    \"data\": [\n        {\n            \"id\": 140,\n            \"column_name\": \"product_id\",\n            \"internal_name\": \"product_id\",\n            \"display_name\": \"Product_ID\",\n            \"data_type\": \"int\",\n            \"column_type\": \"sku_id\",\n            \"format\": \"\",\n            \"show_in_tool\": false,\n            \"type\": \"product_master\",\n            \"dataset_id\": 1\n        },\n        {\n            \"id\": 163,\n            \"column_name\": \"moq\",\n            \"internal_name\": \"moq\",\n            \"display_name\": \"MOQ\",\n            \"data_type\": \"int\",\n            \"column_type\": \"\",\n            \"format\": \"\",\n            \"show_in_tool\": false,\n            \"type\": \"product_master\",\n            \"dataset_id\": 1\n        }\n    ]\n}"}],"_postman_id":"5a30f869-5d2f-495d-96e1-07819f6dce13"},{"name":"Update Mapping","id":"13398790-95b9-40a0-a4c7-b1a5b3bdd54f","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"<token>"}]},"isInherited":false},"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n    \"search_filter\": {\r\n        \"column_name\": \"product_id\"\r\n    },\r\n    \"update_filter\": {\r\n        \"data_type\": \"int\"\r\n    }\r\n}","options":{"raw":{"language":"json"}}},"url":"https://acme.kronoscope.fountain9.com/atlas/data_integration/mapping/update?dataset_id=<dataset_id>","description":"<h3 id=\"api-to-update-column-definition-and-mapping\">API to update column definition and mapping</h3>\n<h4 id=\"request-body\">Request Body</h4>\n<p>Request body should contain two fields, one for searching the rows that you want to update and second for updating the field and value in those rows.</p>\n<p>The following is the structure of the request JSON. <code>search_filter</code> is optional.</p>\n<pre class=\"click-to-expand-wrapper is-snippet-wrapper\"><code class=\"language-json\">{\n\"search_filter\": {},    \n\"update_filter\": {}\n}\n\n</code></pre>\n<p>The following are the fields that can be updated:</p>\n<div class=\"click-to-expand-wrapper is-table-wrapper\"><table>\n<thead>\n<tr>\n<th>Field</th>\n<th>Description</th>\n<th>Datatype</th>\n<th><strong>Supported Values</strong></th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>column_name</td>\n<td>Name of the column in the data</td>\n<td>string</td>\n<td>-</td>\n</tr>\n<tr>\n<td>display_name</td>\n<td>Name of the column that will be displayed in the tool</td>\n<td>string</td>\n<td>-</td>\n</tr>\n<tr>\n<td>format</td>\n<td>Format of the field required for date fields</td>\n<td>string</td>\n<td>-</td>\n</tr>\n<tr>\n<td>show_in_tool</td>\n<td>Indicates whether the column should be displayed in the tool</td>\n<td>boolean</td>\n<td>-</td>\n</tr>\n<tr>\n<td>type</td>\n<td>Type of dataset</td>\n<td>string</td>\n<td>sales, inventory, product_master, branch_master, purchase_orders, transfer_orders, supplier_master, raw_material_master, products_branches_suppliers, products_branches_warehouses, external_variable</td>\n</tr>\n<tr>\n<td>data_type</td>\n<td>The data type of the column</td>\n<td>string</td>\n<td>int, float, string, list, date</td>\n</tr>\n<tr>\n<td>dataset_id</td>\n<td>Dataset ID provided</td>\n<td>integer</td>\n<td>-</td>\n</tr>\n</tbody>\n</table>\n</div>","urlObject":{"protocol":"https","path":["atlas","data_integration","mapping","update"],"host":["acme","kronoscope","fountain9","com"],"query":[{"description":{"content":"<p>Integer</p>\n","type":"text/plain"},"key":"dataset_id","value":"<dataset_id>"}],"variable":[]}},"response":[{"id":"abdf4c40-d3cf-4980-9e78-32db88e3024e","name":"Update Mapping Example","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n    \"search_filter\": {\r\n        \"column_name\": \"product_id\"\r\n    },\r\n    \"update_filter\": {\r\n        \"data_type\": \"int\"\r\n    }\r\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"https://acme.kronoscope.fountain9.com/atlas/data_integration/mapping/update?dataset_id=1","protocol":"https","host":["acme","kronoscope","fountain9","com"],"path":["atlas","data_integration","mapping","update"],"query":[{"key":"dataset_id","value":"1"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"success\"\n}"}],"_postman_id":"13398790-95b9-40a0-a4c7-b1a5b3bdd54f"},{"name":"Delete Mapping","id":"247851e8-f0f3-4c28-a1ce-d24a9dbaddb2","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"<token>"}]},"isInherited":false},"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n    \"delete_filter\": {\r\n        \"type\": \"sales\",\r\n        \"column_name\": \"sku_id\"\r\n    }\r\n}","options":{"raw":{"language":"json"}}},"url":"https://acme.kronoscope.fountain9.com/atlas/data_integration/mapping/delete?dataset_id=<dataset_id>","description":"<h3 id=\"api-to-delete-column-definition-and-mapping\">API to delete column definition and mapping</h3>\n<h4 id=\"request-body\">Request Body</h4>\n<p>Request body should contain filters for the rows that need to be deleted. The filter cannot be empty.</p>\n<p>The following is the structure of the request JSON.</p>\n<pre class=\"click-to-expand-wrapper is-snippet-wrapper\"><code class=\"language-json\">{\n\"delete_filter\": {}\n}\n\n</code></pre>\n<p>The following are the fields that can used to filter rows that need to be deleted:</p>\n<div class=\"click-to-expand-wrapper is-table-wrapper\"><table>\n<thead>\n<tr>\n<th>Field</th>\n<th>Description</th>\n<th>Datatype</th>\n<th><strong>Supported Values</strong></th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>column_name</td>\n<td>Name of the column in the data</td>\n<td>string</td>\n<td>-</td>\n</tr>\n<tr>\n<td>display_name</td>\n<td>Name of the column that will be displayed in the tool</td>\n<td>string</td>\n<td>-</td>\n</tr>\n<tr>\n<td>format</td>\n<td>Format of the field required for date fields</td>\n<td>string</td>\n<td>-</td>\n</tr>\n<tr>\n<td>show_in_tool</td>\n<td>Indicates whether the column should be displayed in the tool</td>\n<td>boolean</td>\n<td>-</td>\n</tr>\n<tr>\n<td>type</td>\n<td>Type of dataset</td>\n<td>string</td>\n<td>sales, inventory, product_master, branch_master, purchase_orders, transfer_orders, supplier_master, raw_material_master, products_branches_suppliers, products_branches_warehouses, external_variable</td>\n</tr>\n<tr>\n<td>data_type</td>\n<td>The data type of the column</td>\n<td>string</td>\n<td>int, float, string, list, date</td>\n</tr>\n<tr>\n<td>dataset_id</td>\n<td>Dataset ID provided</td>\n<td>integer</td>\n<td>-</td>\n</tr>\n</tbody>\n</table>\n</div>","urlObject":{"protocol":"https","path":["atlas","data_integration","mapping","delete"],"host":["acme","kronoscope","fountain9","com"],"query":[{"description":{"content":"<p>Integer</p>\n","type":"text/plain"},"key":"dataset_id","value":"<dataset_id>"}],"variable":[]}},"response":[{"id":"ac817be3-8e0f-4b2b-a15e-a34857c9cecd","name":"Delete Mapping","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n    \"delete_filter\": {\r\n        \"type\": [\"sales\", \"product_master\"],\r\n        \"column_name\": \"sku_id\"\r\n    }\r\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"https://acme.kronoscope.fountain9.com/atlas/data_integration/mapping/delete?dataset_id=1","protocol":"https","host":["acme","kronoscope","fountain9","com"],"path":["atlas","data_integration","mapping","delete"],"query":[{"key":"dataset_id","value":"1"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"success\"\n}"}],"_postman_id":"247851e8-f0f3-4c28-a1ce-d24a9dbaddb2"},{"name":"Create Data","id":"ea19a8d0-17f0-41be-bbdb-79da619e4c0f","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"<token>"}]},"isInherited":false},"method":"POST","header":[],"body":{"mode":"formdata","formdata":[{"key":"payload","type":"file","value":null}]},"url":"https://acme.kronoscope.fountain9.com/atlas/data_integration/data/create?dataset_id=<dataset_id>&type=<dataset>","description":"<h3 id=\"api-to-ingest-raw-data\">API to ingest raw data</h3>\n<p>Please make sure the mapping is created using <code>Create Mapping API</code> before ingesting data.</p>\n<h4 id=\"request-body\">Request Body</h4>\n<p>This request is requires you to specify two query parameters:<br /><code>dataset_id</code> can be obtained from the customer success team</p>\n<p><code>type</code> indicates the type of dataset that needs to be ingested.</p>\n<p>Possbile values for <code>type</code> field: <strong>sales, inventory, product_master, branch_master, purchase_orders, transfer_orders, supplier_master, raw_material_master, products_branches_suppliers, products_branches_warehouses, demand_drivers</strong></p>\n<p>The request body should be of form-data type and include a key <code>payload</code> with value as a <strong>csv file</strong>.</p>\n<p>The csv file <strong>cannot have more than 250,000 rows</strong>. If data is larger than that, then break down the data and then send it using multiple API requests.</p>\n<p>The csv file should have the same fields as defined using the <code>Create Mapping API</code> else it will be rejected.</p>\n<p>Python code snippet for reference:</p>\n<pre class=\"click-to-expand-wrapper is-snippet-wrapper\"><code class=\"language-python\">import requests\nimport json\nurl = 'https://acme.kronoscope.fountain9.com/atlas'\nresponse = requests.post(url + \"/auth/api/token?domain=acme.com\",\n                         json={\"user_name\": 'demo@acme.com', \"password\": 'password',\n                               \"is_superuser\": False})\nd = json.loads(response.text)\nheaders = {\"Authorization\": \"Bearer \" + d['access']}\ntest_file = open(r'/path/to/test_sales.csv', \"rb\")\nresponse = requests.post(url + \"/data_integration/data/create?dataset_id=1&amp;type=sales\", files = {\"payload\": test_file}, headers=headers) \n\n</code></pre>\n","urlObject":{"protocol":"https","path":["atlas","data_integration","data","create"],"host":["acme","kronoscope","fountain9","com"],"query":[{"description":{"content":"<p>Integer</p>\n","type":"text/plain"},"key":"dataset_id","value":"<dataset_id>"},{"description":{"content":"<p>String</p>\n","type":"text/plain"},"key":"type","value":"<dataset>"}],"variable":[]}},"response":[{"id":"1082adae-5849-4bf2-b01e-37d28830f2cc","name":"Sales Example","originalRequest":{"method":"POST","header":[],"body":{"mode":"formdata","formdata":[{"key":"data","type":"file","src":"postman-cloud:///1eef664d-b7d7-49a0-a870-c0eb4ec3c462"}]},"url":{"raw":"https://acme.kronoscope.fountain9.com/atlas/data_integration/data/create?dataset_id=1&type=sales","protocol":"https","host":["acme","kronoscope","fountain9","com"],"path":["atlas","data_integration","data","create"],"query":[{"key":"dataset_id","value":"1","description":"Integer"},{"key":"type","value":"sales","description":"String"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"success\",\n    \"Documents created\": 4\n}"},{"id":"261f7e58-04f7-4acd-a19a-8ef6be7798cf","name":"Products-Branches-Suppliers Example","originalRequest":{"method":"POST","header":[],"body":{"mode":"formdata","formdata":[{"key":"data","type":"file","fileNotInWorkingDirectoryWarning":"This file isn't in your working directory. Teammates you share this request with won't be able to use this file. To make collaboration easier you can setup your working directory in Settings.","filesNotInWorkingDirectory":["/C:/Users/tanay/Downloads/products_branches_suppliers.csv"],"src":"postman-cloud:///1eef6836-9079-4f80-87db-fe534be7ba83"}]},"url":{"raw":"https://acme.kronoscope.fountain9.com/atlas/data_integration/data/create?dataset_id=1&type=products_branches_suppliers","protocol":"https","host":["acme","kronoscope","fountain9","com"],"path":["atlas","data_integration","data","create"],"query":[{"key":"dataset_id","value":"1","description":"Integer"},{"key":"type","value":"products_branches_suppliers","description":"String"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"success\",\n    \"Documents created\": 4\n}"}],"_postman_id":"ea19a8d0-17f0-41be-bbdb-79da619e4c0f"},{"name":"Read Data","id":"1c964936-3aea-4a11-b9e6-4ca98e312e0a","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"<token>"}]},"isInherited":false},"method":"GET","header":[],"body":{"mode":"raw","raw":"{\r\n    \"search_filter\": {\r\n        \"created_at\": {\r\n            \"start_value\": \"2023-11-01\"\r\n            }\r\n        }\r\n}","options":{"raw":{"language":"json"}}},"url":"https://acme.kronoscope.fountain9.com/atlas/data_integration/data/read?dataset_id=<dataset_id>&type=<dataset>","description":"<h3 id=\"api-to-read-raw-data\">API to read raw data</h3>\n<h4 id=\"request-body\">Request Body</h4>\n<p>This request is requires you to specify two query parameters:<br /><code>dataset_id</code> can be obtained from the customer success team</p>\n<p><code>type</code> indicates the type of dataset that needs to be ingested.</p>\n<p>Possbile values for <code>type</code> field: <strong>sales, inventory, product_master, branch_master, purchase_orders, transfer_orders, supplier_master, raw_material_master, products_branches_suppliers, products_branches_warehouses, external_variable</strong></p>\n<p>The following is the structure of the request JSON.</p>\n<pre class=\"click-to-expand-wrapper is-snippet-wrapper\"><code class=\"language-json\">{\n\"search_filter\": {}\n}\n\n</code></pre>\n<p>The <code>search_filter</code> should have the same fields as defined using the <code>Create Mapping API</code> else it will be rejected.</p>\n<p>Search operations supported in <code>search_filter</code>:</p>\n<div class=\"click-to-expand-wrapper is-table-wrapper\"><table>\n<thead>\n<tr>\n<th>Search Type</th>\n<th>Key to be used</th>\n<th><strong>Example</strong></th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>Range based search</td>\n<td><code>start_value</code>  <br />and <code>end_value</code> are the keys. They are both inclusive - [start_value, end_value]</td>\n<td><code>\"quantity\":{ {\"start_value\": 5, \"end_value\": 10} }</code>  <br />  <br /><code>\"date\":{ {\"start_value\": \"2024-03-01\", \"end_value\": \"2024-04-01\"} }</code></td>\n</tr>\n<tr>\n<td>Multiple values search</td>\n<td>Put all values that need to be searched in a list</td>\n<td><code>\"sku_id\": [100, 101, 102]</code></td>\n</tr>\n</tbody>\n</table>\n</div>","urlObject":{"protocol":"https","path":["atlas","data_integration","data","read"],"host":["acme","kronoscope","fountain9","com"],"query":[{"description":{"content":"<p>Integer</p>\n","type":"text/plain"},"key":"dataset_id","value":"<dataset_id>"},{"description":{"content":"<p>String</p>\n","type":"text/plain"},"key":"type","value":"<dataset>"}],"variable":[]}},"response":[{"id":"c1483b01-9f43-4d91-9d05-de5dc0ec989d","name":"Read Data Example","originalRequest":{"method":"GET","header":[],"body":{"mode":"raw","raw":"{\r\n    \"search_filter\": {\r\n        \"created_at\": {\r\n            \"start_value\": \"2023-11-01\"\r\n        },\r\n        \"warehouse_id\": [\r\n            19,\r\n            21\r\n        ],\r\n        \"quantity\": {\r\n            \"start_value\": 1,\r\n            \"end_value\": 10\r\n        }\r\n    }\r\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"https://acme.kronoscope.fountain9.com/atlas/data_integration/data/read?dataset_id=1&type=sales","protocol":"https","host":["acme","kronoscope","fountain9","com"],"path":["atlas","data_integration","data","read"],"query":[{"key":"dataset_id","value":"1","description":"Integer"},{"key":"type","value":"sales","description":"String"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"success\",\n    \"data\": [\n        {\n            \"created_at\": \"2023-10-31 02:35:04\",\n            \"warehouse_id\": 19,\n            \"sku_id\": 2465,\n            \"quantity\": 2\n        },\n        {\n            \"created_at\": \"2023-10-31 02:19:17\",\n            \"warehouse_id\": 21,\n            \"sku_id\": 1905,\n            \"quantity\": 2\n        },\n        {\n            \"created_at\": \"2023-10-31 02:19:17\",\n            \"warehouse_id\": 21,\n            \"sku_id\": 331,\n            \"quantity\": 2\n        },\n        {\n            \"created_at\": \"2023-10-31 02:19:17\",\n            \"warehouse_id\": 21,\n            \"sku_id\": 266,\n            \"quantity\": 2\n        },\n        {\n            \"created_at\": \"2023-10-31 02:00:44\",\n            \"warehouse_id\": 19,\n            \"sku_id\": 583,\n            \"quantity\": 5\n        },\n        {\n            \"created_at\": \"2023-10-31 02:04:18\",\n            \"warehouse_id\": 21,\n            \"sku_id\": 3222,\n            \"quantity\": 2\n        },\n        {\n            \"created_at\": \"2023-10-31 01:57:21\",\n            \"warehouse_id\": 21,\n            \"sku_id\": 2803,\n            \"quantity\": 2\n        },\n        {\n            \"created_at\": \"2023-10-31 02:02:07\",\n            \"warehouse_id\": 21,\n            \"sku_id\": 3772,\n            \"quantity\": 2\n        },\n        {\n            \"created_at\": \"2023-10-31 02:08:26\",\n            \"warehouse_id\": 19,\n            \"sku_id\": 2697,\n            \"quantity\": 2\n        },\n        {\n            \"created_at\": \"2023-10-31 02:00:02\",\n            \"warehouse_id\": 19,\n            \"sku_id\": 192,\n            \"quantity\": 2\n        },\n        {\n            \"created_at\": \"2023-10-31 02:00:44\",\n            \"warehouse_id\": 19,\n            \"sku_id\": 2397,\n            \"quantity\": 4\n        },\n        {\n            \"created_at\": \"2023-10-31 02:02:07\",\n            \"warehouse_id\": 21,\n            \"sku_id\": 799,\n            \"quantity\": 2\n        },\n        {\n            \"created_at\": \"2023-10-31 01:57:23\",\n            \"warehouse_id\": 21,\n            \"sku_id\": 4058,\n            \"quantity\": 2\n        },\n        {\n            \"created_at\": \"2023-10-31 02:09:38\",\n            \"warehouse_id\": 19,\n            \"sku_id\": 1735,\n            \"quantity\": 2\n        },\n        {\n            \"created_at\": \"2023-10-31 02:10:18\",\n            \"warehouse_id\": 19,\n            \"sku_id\": 3464,\n            \"quantity\": 3\n        },\n        {\n            \"created_at\": \"2023-10-31 02:09:38\",\n            \"warehouse_id\": 19,\n            \"sku_id\": 15,\n            \"quantity\": 4\n        },\n        {\n            \"created_at\": \"2023-10-31 01:56:55\",\n            \"warehouse_id\": 21,\n            \"sku_id\": 768,\n            \"quantity\": 2\n        },\n        {\n            \"created_at\": \"2023-10-31 01:46:57\",\n            \"warehouse_id\": 21,\n            \"sku_id\": 197,\n            \"quantity\": 2\n        },\n        {\n            \"created_at\": \"2023-10-31 01:48:34\",\n            \"warehouse_id\": 19,\n            \"sku_id\": 859,\n            \"quantity\": 2\n        },\n        {\n            \"created_at\": \"2023-10-31 01:47:19\",\n            \"warehouse_id\": 21,\n            \"sku_id\": 732,\n            \"quantity\": 2\n        },\n        {\n            \"created_at\": \"2023-10-31 01:45:27\",\n            \"warehouse_id\": 19,\n            \"sku_id\": 2618,\n            \"quantity\": 2\n        },\n        {\n            \"created_at\": \"2023-10-31 01:53:56\",\n            \"warehouse_id\": 21,\n            \"sku_id\": 69,\n            \"quantity\": 2\n        },\n        {\n            \"created_at\": \"2023-10-31 01:53:56\",\n            \"warehouse_id\": 21,\n            \"sku_id\": 3255,\n            \"quantity\": 2\n        },\n        {\n            \"created_at\": \"2023-10-31 01:27:20\",\n            \"warehouse_id\": 19,\n            \"sku_id\": 1927,\n            \"quantity\": 2\n        },\n        {\n            \"created_at\": \"2023-10-31 01:35:31\",\n            \"warehouse_id\": 21,\n            \"sku_id\": 6304,\n            \"quantity\": 4\n        },\n        {\n            \"created_at\": \"2023-10-31 01:22:02\",\n            \"warehouse_id\": 21,\n            \"sku_id\": 478,\n            \"quantity\": 2\n        },\n        {\n            \"created_at\": \"2023-10-31 01:22:54\",\n            \"warehouse_id\": 19,\n            \"sku_id\": 150,\n            \"quantity\": 2\n        },\n        {\n            \"created_at\": \"2023-10-31 01:22:02\",\n            \"warehouse_id\": 21,\n            \"sku_id\": 3292,\n            \"quantity\": 3\n        },\n        {\n            \"created_at\": \"2023-10-31 01:22:02\",\n            \"warehouse_id\": 21,\n            \"sku_id\": 2725,\n            \"quantity\": 3\n        },\n        {\n            \"created_at\": \"2023-10-31 01:16:20\",\n            \"warehouse_id\": 19,\n            \"sku_id\": 1457,\n            \"quantity\": 2\n        }\n    ]\n}"}],"_postman_id":"1c964936-3aea-4a11-b9e6-4ca98e312e0a"},{"name":"Update Data","id":"3520b920-87f2-44d2-8fa3-aac3eaea34e6","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"<token>"}]},"isInherited":false},"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n    \"search_filter\": {\r\n        \"retail_id\": 200\r\n    },\r\n    \"update_filter\": {\r\n        \"mov\": 12\r\n    }\r\n}","options":{"raw":{"language":"json"}}},"url":"https://acme.kronoscope.fountain9.com/atlas/data_integration/data/update?dataset_id=<dataset_id>&type=<dataset>","description":"<h3 id=\"api-to-update-raw-data\">API to update raw data</h3>\n<h4 id=\"request-body\">Request Body</h4>\n<p>Request body should contain two fields, one for searching the rows that you want to update and second for updating the field and value in those rows.</p>\n<p>Update is only allowed for the following datasets: <strong>product_master, branch_master, supplier_master, raw_material_master, products_branches_suppliers, products_branches_warehouses</strong></p>\n<p>The following is the structure of the request JSON. <code>search_filter</code> is optional.</p>\n<pre class=\"click-to-expand-wrapper is-snippet-wrapper\"><code class=\"language-json\">{\n\"search_filter\": {},    \n\"update_filter\": {}\n}\n\n</code></pre>\n<p>Search operations supported in <code>search_filter</code>:</p>\n<div class=\"click-to-expand-wrapper is-table-wrapper\"><table>\n<thead>\n<tr>\n<th>Search Type</th>\n<th>Key to be used</th>\n<th><strong>Example</strong></th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>Range based search</td>\n<td><code>start_value</code>  <br />and <code>end_value</code> are the keys. They are both inclusive - [start_value, end_value]</td>\n<td><code>\"quantity\":{ {\"start_value\": 5, \"end_value\": 10} }</code>  <br />  <br /><code>\"date\":{ {\"start_value\": \"2024-03-01\", \"end_value\": \"2024-04-01\"} }</code></td>\n</tr>\n<tr>\n<td>Multiple values search</td>\n<td>Put all values that need to be searched in a list</td>\n<td><code>\"sku_id\": [100, 101, 102]</code></td>\n</tr>\n</tbody>\n</table>\n</div>","urlObject":{"protocol":"https","path":["atlas","data_integration","data","update"],"host":["acme","kronoscope","fountain9","com"],"query":[{"description":{"content":"<p>Integer</p>\n","type":"text/plain"},"key":"dataset_id","value":"<dataset_id>"},{"description":{"content":"<p>String</p>\n","type":"text/plain"},"key":"type","value":"<dataset>"}],"variable":[]}},"response":[{"id":"4f167e25-ff2e-4a52-b8db-55af55661d50","name":"Update Data Example","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n    \"search_filter\": {\r\n        \"supplier_id\": [\r\n            200,\r\n            201\r\n        ]\r\n    },\r\n    \"update_filter\": {\r\n        \"moq\": 12,\r\n        \"lead_time\": 4\r\n    }\r\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"https://acme.kronoscope.fountain9.com/atlas/data_integration/data/update?dataset_id=1&type=products_branches_suppliers","protocol":"https","host":["acme","kronoscope","fountain9","com"],"path":["atlas","data_integration","data","update"],"query":[{"key":"dataset_id","value":"1"},{"key":"type","value":"products_branches_suppliers"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"success\",\n    \"Documents updated\": 10\n}"}],"_postman_id":"3520b920-87f2-44d2-8fa3-aac3eaea34e6"},{"name":"Delete Data","id":"667b95d1-355b-4f42-9ea5-dece116b0d05","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"<token>"}]},"isInherited":false},"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n    \"delete_filter\": {\r\n        \"sku_id\": 1320\r\n    }\r\n}","options":{"raw":{"language":"json"}}},"url":"https://acme.kronoscope.fountain9.com/atlas/data_integration/data/delete?dataset_id=<dataset_id>&type=<dataset>","description":"<h3 id=\"api-to-delete-raw-data\">API to delete raw data</h3>\n<h4 id=\"request-body\">Request Body</h4>\n<p>Request body should contain filters for the rows that need to be deleted. The filter cannot be empty.</p>\n<p>The following is the structure of the request JSON.</p>\n<pre class=\"click-to-expand-wrapper is-snippet-wrapper\"><code class=\"language-json\">{\n\"delete_filter\": {}\n}\n\n</code></pre>\n<p>Search operations supported in <code>search_filter</code>:</p>\n<div class=\"click-to-expand-wrapper is-table-wrapper\"><table>\n<thead>\n<tr>\n<th>Search Type</th>\n<th>Key to be used</th>\n<th><strong>Example</strong></th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>Range based search</td>\n<td><code>start_value</code>  <br />and <code>end_value</code> are the keys. They are both inclusive - [start_value, end_value]</td>\n<td><code>\"quantity\":{ {\"start_value\": 5, \"end_value\": 10} }</code>  <br />  <br /><code>\"date\":{ {\"start_value\": \"2024-03-01\", \"end_value\": \"2024-04-01\"} }</code></td>\n</tr>\n<tr>\n<td>Multiple values search</td>\n<td>Put all values that need to be searched in a list</td>\n<td><code>\"sku_id\": [100, 101, 102]</code></td>\n</tr>\n</tbody>\n</table>\n</div>","urlObject":{"protocol":"https","path":["atlas","data_integration","data","delete"],"host":["acme","kronoscope","fountain9","com"],"query":[{"description":{"content":"<p>Integer</p>\n","type":"text/plain"},"key":"dataset_id","value":"<dataset_id>"},{"description":{"content":"<p>String</p>\n","type":"text/plain"},"key":"type","value":"<dataset>"}],"variable":[]}},"response":[{"id":"dcb03227-ab98-4854-8014-649b5df4e5d5","name":"Delete Data Example","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n    \"delete_filter\": {\r\n        \"sku_id\": [\r\n            1320,\r\n            1321\r\n        ],\r\n        \"date\": {\r\n            \"start_value\": \"2023-10-01\",\r\n            \"end_value\": \"2023-10-15\"\r\n        },\r\n        \"branch_id\": 30\r\n    }\r\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"https://acme.kronoscope.fountain9.com/atlas/data_integration/data/delete?dataset_id=1&type=sales","protocol":"https","host":["acme","kronoscope","fountain9","com"],"path":["atlas","data_integration","data","delete"],"query":[{"key":"dataset_id","value":"1"},{"key":"type","value":"sales"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n    \"status\": \"success\",\n    \"Documents deleted\": 30\n}"}],"_postman_id":"667b95d1-355b-4f42-9ea5-dece116b0d05"}],"id":"9f4ca29d-510a-4eae-9282-f8f41df22fb6","_postman_id":"9f4ca29d-510a-4eae-9282-f8f41df22fb6","description":""},{"name":"Order Management","item":[{"name":"Order Receives","id":"5c9c5eab-41c6-45ac-a6de-b176223c6039","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"<token>"}]},"isInherited":false},"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n    \"data\": {\r\n        \"order_id\": [\"12323564\"],\r\n        \"order_status\": [\"Released\"],\r\n        \"external_order_id\": [\"4200001781\"],\r\n        \"created_date\": [\"2023-06-19\"],\r\n        \"source_id\": [\"10917\"],\r\n        \"dest_id\": [\"W1112\"],\r\n        \"plan_id\": [\"All_Fixed_Duration_Purchase_Plan_2023_05_30_20_39_56\"],\r\n        \"sku_id\": [\"8904780852223\", \"8904650852005\"],\r\n        \"line_item_status\": [\"Released\"],\r\n        \"expected_received_date\": [\"2023-06-29\"],\r\n        \"modified_after\": \"2023-06-19\"\r\n        }\r\n}","options":{"raw":{"language":"json"}}},"url":"https://acme.kronoscope.fountain9.com/atlas/order_management/api/orders_received?dataset_id=<dataset_id>","description":"<h4 id=\"api-endpoint-to-fetch-order-receives\">API endpoint to fetch order receives</h4>\n<p><code>dataset_id</code> value is needed to use this API. Ask the customer success team if you don't already have it.</p>\n<p><strong>Request field descriptions:</strong></p>\n<div class=\"click-to-expand-wrapper is-table-wrapper\"><table>\n<thead>\n<tr>\n<th><strong>Field</strong></th>\n<th><strong>Description</strong></th>\n<th><strong>Example</strong></th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>order_id</td>\n<td>Order ID of the purchase order</td>\n<td>1234563</td>\n</tr>\n<tr>\n<td>order_status</td>\n<td>Status of the order</td>\n<td><strong>Supported values for this field:</strong>  <br />Cancelled, Released, Received, Partially Received, Closed</td>\n</tr>\n<tr>\n<td>external_order_id</td>\n<td>Order ID corresponding to an external tool/system like SAP</td>\n<td>-</td>\n</tr>\n<tr>\n<td>created_date</td>\n<td>Order creation date</td>\n<td>2023-06-19</td>\n</tr>\n<tr>\n<td>source_id</td>\n<td>Supplier/Vendor ID</td>\n<td>-</td>\n</tr>\n<tr>\n<td>dest_id</td>\n<td>Receiving node ID</td>\n<td>-</td>\n</tr>\n<tr>\n<td>plan_id</td>\n<td>Kronoscope Plan ID</td>\n<td>All_Fixed_Duration_Purchase_Plan_2023_05_30_20_39_56</td>\n</tr>\n<tr>\n<td>sku_id</td>\n<td>SKU ID</td>\n<td>-</td>\n</tr>\n<tr>\n<td>sku_name</td>\n<td>SKU Name</td>\n<td>-</td>\n</tr>\n<tr>\n<td>line_item_status</td>\n<td>Status of a line item in an order</td>\n<td><strong>Supported values for this field:</strong>  <br />Cancelled, Released, Received, Partially Received, Closed</td>\n</tr>\n<tr>\n<td>expected_received_date</td>\n<td>Expected receiving date of the order</td>\n<td>2023-06-30</td>\n</tr>\n<tr>\n<td>modified_after</td>\n<td>Date to filter records modified after the given date. If provided, only records modified after the given date will be returned (inclusive of the given date)</td>\n<td>2023-06-30</td>\n</tr>\n</tbody>\n</table>\n</div><h5 id=\"response-field-descriptions\">Response field descriptions:</h5>\n<div class=\"click-to-expand-wrapper is-table-wrapper\"><table>\n<thead>\n<tr>\n<th><strong>Field</strong></th>\n<th><strong>Description</strong></th>\n<th><strong>Datatype</strong></th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>order_id</td>\n<td>Order ID of the purchase order</td>\n<td>string</td>\n</tr>\n<tr>\n<td>source_id</td>\n<td>Supplier/Vendor ID</td>\n<td>string</td>\n</tr>\n<tr>\n<td>source_name</td>\n<td>Supplier/Vendor Name</td>\n<td>string</td>\n</tr>\n<tr>\n<td>dest_id</td>\n<td>Receiving node ID</td>\n<td>string</td>\n</tr>\n<tr>\n<td>sku_id</td>\n<td>SKU ID</td>\n<td>string</td>\n</tr>\n<tr>\n<td>sku_name</td>\n<td>SKU name</td>\n<td>string</td>\n</tr>\n<tr>\n<td>line_item_id</td>\n<td>Line item ID</td>\n<td>string</td>\n</tr>\n<tr>\n<td>ordered_quantity</td>\n<td>Ordered Quantity Units</td>\n<td>float</td>\n</tr>\n<tr>\n<td>ordered_quantity_batch</td>\n<td>Ordered Quantity in Batches</td>\n<td>float</td>\n</tr>\n<tr>\n<td>ordered_price</td>\n<td>Ordered Price of SKU ID</td>\n<td>float</td>\n</tr>\n<tr>\n<td>ordered_batch_size</td>\n<td>Batch Size of SKU</td>\n<td>float</td>\n</tr>\n<tr>\n<td>sales_price</td>\n<td>Sales price of the SKU</td>\n<td>float</td>\n</tr>\n<tr>\n<td>sales_price_updated</td>\n<td>Updated sales price of the SKU</td>\n<td>float</td>\n</tr>\n<tr>\n<td>external_order_id</td>\n<td>Order ID corresponding to an external tool/system like SAP</td>\n<td>string</td>\n</tr>\n<tr>\n<td>received_id</td>\n<td>Received Order ID</td>\n<td>string</td>\n</tr>\n<tr>\n<td>batch_id</td>\n<td>Batch ID</td>\n<td>string</td>\n</tr>\n<tr>\n<td>expected_received_date</td>\n<td>Expected Received Date of the order</td>\n<td>string</td>\n</tr>\n<tr>\n<td>expected_received_quantity</td>\n<td>Expected Received Quantity</td>\n<td>float</td>\n</tr>\n<tr>\n<td>received_date</td>\n<td>Received Date of the order</td>\n<td>string</td>\n</tr>\n<tr>\n<td>received_price</td>\n<td>Received Price of the order</td>\n<td>float</td>\n</tr>\n<tr>\n<td>received_batch_size</td>\n<td>Received batch size</td>\n<td>float</td>\n</tr>\n<tr>\n<td>batch_manufacturing_date</td>\n<td>Manufacturing date of the batch</td>\n<td>string</td>\n</tr>\n<tr>\n<td>batch_expiry_date</td>\n<td>Expiry date of the batch</td>\n<td>string</td>\n</tr>\n<tr>\n<td>last_modified</td>\n<td>Last modified time of the row</td>\n<td>string</td>\n</tr>\n</tbody>\n</table>\n</div>","urlObject":{"protocol":"https","path":["atlas","order_management","api","orders_received"],"host":["acme","kronoscope","fountain9","com"],"query":[{"description":{"content":"<p>Integer</p>\n","type":"text/plain"},"key":"dataset_id","value":"<dataset_id>"}],"variable":[]}},"response":[{"id":"10d2b44b-b768-4fca-96f7-552be6c53486","name":"Get Order Receives Example","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n    \"data\": {\r\n        \"order_id\": [\"4200001006160\"],\r\n        \"order_status\": [\"Released\"],\r\n        \"created_date\": [\"2023-06-19\"],\r\n        \"dest_id\": [\"W1112\"]\r\n        }\r\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"https://acme.kronoscope.fountain9.com/atlas/order_management/api/orders_received?dataset_id=1","protocol":"https","host":["acme","kronoscope","fountain9","com"],"path":["atlas","order_management","api","orders_received"],"query":[{"key":"dataset_id","value":"1"}]}},"status":"OK","code":200,"_postman_previewlanguage":"plain","header":[{"key":"Date","value":"Thu, 07 Apr 2022 17:42:03 GMT"},{"key":"Content-Type","value":"text/csv"},{"key":"Content-Length","value":"11960"},{"key":"Connection","value":"keep-alive"},{"key":"Server","value":"nginx"},{"key":"Content-Disposition","value":"attachment; filename=\"All_Fixed_Duration_Purchase_Plan_2022_04_07_10_41_08.csv\""},{"key":"Vary","value":"Accept, Origin, Accept-Encoding"},{"key":"Allow","value":"GET, HEAD, OPTIONS"},{"key":"X-Frame-Options","value":"SAMEORIGIN"},{"key":"Content-Encoding","value":"gzip"}],"cookie":[],"responseTime":null,"body":"{\"status\":\"success\",\"data\":[{\"order_id\":\"4200001006160\",\"source_id\":\"8100036\",\"source_name\":\"Generic Supplier Co\",\"dest_id\":\"W1112\",\"sku_id\":\"100015218\",\"sku_name\":\"Earpods Fiery Black\",\"line_item_id\":\"bd05eb22-cc2e-3dd3-9b43-b49311dc9ec0\",\"ordered_quantity\":960.0,\"ordered_quantity_batch\":960.0,\"ordered_price\":477.42,\"ordered_batch_size\":1,\"sales_price\":null,\"sales_price_updated\":null,\"external_order_id\":\"4200001006\",\"received_id\":\"e1508a2d-7f02-3671-85ca-d12c478a80ca\",\"batch_id\":\"5000018760\",\"expected_received_date\":null,\"expected_received_quantity\":null,\"received_date\":\"2023-06-16\",\"received_quantity\":960.0,\"received_price\":477.42,\"received_batch_size\":null,\"batch_manufacturing_date\":null,\"batch_expiry_date\":null,\"last_modified\":null},{\"order_id\":\"4200001006150\",\"source_id\":\"8100036\",\"source_name\":\"Generic Supplier Co\",\"dest_id\":\"W1112\",\"sku_id\":\"100031942\",\"sku_name\":\"Earpods Cool Emerald\",\"line_item_id\":\"c047f6d4-f208-3a6b-9635-1e39fef6a95a\",\"ordered_quantity\":4560.0,\"ordered_quantity_batch\":4560.0,\"ordered_price\":477.42,\"ordered_batch_size\":1,\"sales_price\":null,\"sales_price_updated\":null,\"external_order_id\":\"4200001006\",\"received_id\":\"90d38f21-d34e-3fce-9ea0-9b6c445b9f98\",\"batch_id\":\"5000018760\",\"expected_received_date\":null,\"expected_received_quantity\":null,\"received_date\":\"2023-06-16\",\"received_quantity\":3240.0,\"received_price\":477.42,\"received_batch_size\":null,\"batch_manufacturing_date\":null,\"batch_expiry_date\":null,\"last_modified\":null},{\"order_id\":\"4200001006140\",\"source_id\":\"8100036\",\"source_name\":\"Generic Supplier Co\",\"dest_id\":\"HR03\",\"sku_id\":\"100015218\",\"sku_name\":\"Earpods Fiery Black\",\"line_item_id\":\"dc5cd779-ad50-3723-97cd-0493cbc8af20\",\"ordered_quantity\":3000.0,\"ordered_quantity_batch\":3000.0,\"ordered_price\":477.42,\"ordered_batch_size\":1,\"sales_price\":null,\"sales_price_updated\":null,\"external_order_id\":\"4200001006\",\"received_id\":\"b6a3d751-65f1-3c9e-9d85-ac86e582a241\",\"batch_id\":\"5000015544\",\"expected_received_date\":null,\"expected_received_quantity\":null,\"received_date\":\"2023-04-29\",\"received_quantity\":3000.0,\"received_price\":477.42,\"received_batch_size\":null,\"batch_manufacturing_date\":null,\"batch_expiry_date\":null,\"last_modified\":null},{\"order_id\":\"4200001006130\",\"source_id\":\"8100036\",\"source_name\":\"Generic Supplier Co\",\"dest_id\":\"HR03\",\"sku_id\":\"100031942\",\"sku_name\":\"Earpods Cool Emerald\",\"line_item_id\":\"00f8eca1-1112-34fc-adb2-773fac4bb158\",\"ordered_quantity\":3240.0,\"ordered_quantity_batch\":3240.0,\"ordered_price\":477.42,\"ordered_batch_size\":1,\"sales_price\":null,\"sales_price_updated\":null,\"external_order_id\":\"4200001006\",\"received_id\":\"42774013-38dc-36b0-b3eb-7af6f7e3823e\",\"batch_id\":\"5000015889\",\"expected_received_date\":null,\"expected_received_quantity\":null,\"received_date\":\"2023-05-06\",\"received_quantity\":3240.0,\"received_price\":477.42,\"received_batch_size\":null,\"batch_manufacturing_date\":null,\"batch_expiry_date\":null,\"last_modified\":null},{\"order_id\":\"4200001006120\",\"source_id\":\"8100036\",\"source_name\":\"Generic Supplier Co\",\"dest_id\":\"HR03\",\"sku_id\":\"100031942\",\"sku_name\":\"Earpods Cool Emerald\",\"line_item_id\":\"c46bcae1-8faf-3515-b7a8-042cb9e98652\",\"ordered_quantity\":4200.0,\"ordered_quantity_batch\":4200.0,\"ordered_price\":477.42,\"ordered_batch_size\":1,\"sales_price\":null,\"sales_price_updated\":null,\"external_order_id\":\"4200001006\",\"received_id\":\"7010f117-ffe6-30c5-b3c6-7211fa639099\",\"batch_id\":\"5000014214\",\"expected_received_date\":null,\"expected_received_quantity\":null,\"received_date\":\"2023-04-03\",\"received_quantity\":4200.0,\"received_price\":477.42,\"received_batch_size\":null,\"batch_manufacturing_date\":null,\"batch_expiry_date\":null,\"last_modified\":null},{\"order_id\":\"4200001006110\",\"source_id\":\"8100036\",\"source_name\":\"Generic Supplier Co\",\"dest_id\":\"HR03\",\"sku_id\":\"100015218\",\"sku_name\":\"Earpods Fiery Black\",\"line_item_id\":\"73b51b51-a471-3b5a-a8e5-1262ddc898a8\",\"ordered_quantity\":4040.0,\"ordered_quantity_batch\":4040.0,\"ordered_price\":477.42,\"ordered_batch_size\":1,\"sales_price\":null,\"sales_price_updated\":null,\"external_order_id\":\"4200001006\",\"received_id\":\"d1936cd0-098e-3f2c-ba8c-c1ef8575cbbf\",\"batch_id\":\"5000015729\",\"expected_received_date\":null,\"expected_received_quantity\":null,\"received_date\":\"2023-05-04\",\"received_quantity\":2400.0,\"received_price\":477.42,\"received_batch_size\":null,\"batch_manufacturing_date\":null,\"batch_expiry_date\":null,\"last_modified\":null},{\"order_id\":\"4200001006110\",\"source_id\":\"8100036\",\"source_name\":\"Generic Supplier Co\",\"dest_id\":\"HR03\",\"sku_id\":\"100015218\",\"sku_name\":\"Earpods Fiery Black\",\"line_item_id\":\"73b51b51-a471-3b5a-a8e5-1262ddc898a8\",\"ordered_quantity\":4040.0,\"ordered_quantity_batch\":4040.0,\"ordered_price\":477.42,\"ordered_batch_size\":1,\"sales_price\":null,\"sales_price_updated\":null,\"external_order_id\":\"4200001006\",\"received_id\":\"ccd10aa7-a1bb-381a-ac71-e2bca67685ea\",\"batch_id\":\"5000015889\",\"expected_received_date\":null,\"expected_received_quantity\":null,\"received_date\":\"2023-05-06\",\"received_quantity\":530.0,\"received_price\":477.42,\"received_batch_size\":null,\"batch_manufacturing_date\":null,\"batch_expiry_date\":null,\"last_modified\":null},{\"order_id\":\"420000100610\",\"source_id\":\"8100036\",\"source_name\":\"Generic Supplier Co\",\"dest_id\":\"W1112\",\"sku_id\":\"100015218\",\"sku_name\":\"Earpods Fiery Black\",\"line_item_id\":\"81824136-0e1d-3c29-9237-8d74b3d819ae\",\"ordered_quantity\":20000.0,\"ordered_quantity_batch\":20000.0,\"ordered_price\":477.42,\"ordered_batch_size\":1,\"sales_price\":null,\"sales_price_updated\":null,\"external_order_id\":\"4200001006\",\"received_id\":null,\"batch_id\":null,\"expected_received_date\":null,\"expected_received_quantity\":null,\"received_date\":null,\"received_quantity\":null,\"received_price\":null,\"received_batch_size\":null,\"batch_manufacturing_date\":null,\"batch_expiry_date\":null,\"synced_with_external\":null,\"fields_synced\":null,\"last_modified\":null}],\"count\":8}"}],"_postman_id":"5c9c5eab-41c6-45ac-a6de-b176223c6039"}],"id":"5d2fa6fd-6939-4e7c-84f6-58c0ca49aed8","_postman_id":"5d2fa6fd-6939-4e7c-84f6-58c0ca49aed8","description":""},{"name":"Promotions","item":[{"name":"Promotion Approval Status","id":"9d015a81-d256-41ba-af27-46ef1f2afd72","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"<token>"}]},"isInherited":false},"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n    \"data\": [\r\n        {\r\n            \"start_date\": \"2025-04-20\",\r\n            \"end_date\": \"2025-04-20\",\r\n            \"sku_id\": \"20061\",\r\n            \"warehouse_id\": \"121\",\r\n            \"discount\": 10,\r\n            \"promo_id\": \"PromoA\"\r\n        },\r\n        {\r\n            \"start_date\": \"2025-04-20\",\r\n            \"end_date\": \"2025-04-25\",\r\n            \"sku_id\": \"20061\",\r\n            \"warehouse_id\": \"121\",\r\n            \"discount\": 10,\r\n            \"promo_id\": \"PromoB\"\r\n        },\r\n        {\r\n            \"warehouse_id\": \"11\",\r\n            \"sku_id\": \"13923\",\r\n            \"start_date\": \"2025-04-20\",\r\n            \"end_date\": \"2025-04-25\",\r\n            \"discount\": 10,\r\n            \"promo_id\": \"PromoC\"\r\n        }\r\n    ]\r\n}","options":{"raw":{"language":"json"}}},"url":"https://acme.kronoscope.fountain9.com/atlas/timeseries/api/snop_promotions?dataset_id=<dataset_id>","description":"<h4 id=\"api-endpoint-to-get-the-approval-status-of-promotions\">API endpoint to get the approval status of promotions</h4>\n<p><code>dataset_id</code> value is needed to use this API. Ask the customer success team if you don't already have it.</p>\n<p><strong>Request field descriptions:</strong></p>\n<div class=\"click-to-expand-wrapper is-table-wrapper\"><table>\n<thead>\n<tr>\n<th><strong>Field</strong></th>\n<th><strong>Description</strong></th>\n<th><strong>Example</strong></th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>warehouse_id</td>\n<td>Warehouse ID</td>\n<td>11</td>\n</tr>\n<tr>\n<td>sku_id</td>\n<td>SKU ID</td>\n<td>13923</td>\n</tr>\n<tr>\n<td>start_date</td>\n<td>Start Date of Promotion</td>\n<td>2025-01-01</td>\n</tr>\n<tr>\n<td>end_date</td>\n<td>End Date of Promotion</td>\n<td>2025-01-05</td>\n</tr>\n<tr>\n<td>discount</td>\n<td>Discount applied for the Promotion</td>\n<td>10</td>\n</tr>\n<tr>\n<td>promo_id</td>\n<td>Promotion ID</td>\n<td>PromoA</td>\n</tr>\n</tbody>\n</table>\n</div><h5 id=\"response-field-descriptions\">Response field descriptions:</h5>\n<div class=\"click-to-expand-wrapper is-table-wrapper\"><table>\n<thead>\n<tr>\n<th><strong>Field</strong></th>\n<th><strong>Description</strong></th>\n<th><strong>Datatype</strong></th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>level_id</td>\n<td>Warehouse ID</td>\n<td>string</td>\n</tr>\n<tr>\n<td>sku_id</td>\n<td>SKU ID</td>\n<td>string</td>\n</tr>\n<tr>\n<td>date</td>\n<td>Date</td>\n<td>string</td>\n</tr>\n<tr>\n<td>discount</td>\n<td>Discount applied for the Promotion</td>\n<td>string</td>\n</tr>\n<tr>\n<td>next_order_receive_date</td>\n<td>Next receive date of the level_id, sku_id combination</td>\n<td>string</td>\n</tr>\n<tr>\n<td>simulated_opening_inventory</td>\n<td>Estimated opening Inventory on that date</td>\n<td>float</td>\n</tr>\n<tr>\n<td>y_hat</td>\n<td>Demand forecast</td>\n<td>float</td>\n</tr>\n<tr>\n<td>y_hat_final</td>\n<td>Demand forecast after applying the discount</td>\n<td>float</td>\n</tr>\n<tr>\n<td>avg_duration_forecast</td>\n<td>Average demand forecast</td>\n<td>float</td>\n</tr>\n<tr>\n<td>estimated_doh</td>\n<td>Estimated inventory runway</td>\n<td>float</td>\n</tr>\n<tr>\n<td>promo_approval_flag</td>\n<td>Promotion approval flag:  <br />  <br />blue: promotion date is after next_order_receive_date  <br />  <br />green: estimated_doh is greater than days till next_order_receive_date plus safety.  <br />  <br />yellow: estimated_doh is greater than days till next_order_receive_date.  <br />  <br />amber: estimated_doh is less than next_order_receive_date but greater than safety.  <br />  <br />red: estimated_doh is less than next_order_receive_date and lesser than safety.</td>\n<td>string</td>\n</tr>\n</tbody>\n</table>\n</div>","urlObject":{"protocol":"https","path":["atlas","timeseries","api","snop_promotions"],"host":["acme","kronoscope","fountain9","com"],"query":[{"description":{"content":"<p>Integer</p>\n","type":"text/plain"},"key":"dataset_id","value":"<dataset_id>"}],"variable":[]}},"response":[{"id":"df611958-8e4a-466a-9e88-ef35e7cd7c31","name":"Promotion Approval Status","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n    \"data\": [\r\n        {\r\n            \"start_date\": \"2025-04-20\",\r\n            \"end_date\": \"2025-04-20\",\r\n            \"sku_id\": \"20061\",\r\n            \"warehouse_id\": \"121\",\r\n            \"discount\": 10,\r\n            \"promo_id\": \"PromoA\"\r\n        },\r\n        {\r\n            \"start_date\": \"2025-04-20\",\r\n            \"end_date\": \"2025-04-25\",\r\n            \"sku_id\": \"20061\",\r\n            \"warehouse_id\": \"121\",\r\n            \"discount\": 10,\r\n            \"promo_id\": \"PromoB\"\r\n        },\r\n        {\r\n            \"warehouse_id\": \"11\",\r\n            \"sku_id\": \"13923\",\r\n            \"start_date\": \"2025-04-20\",\r\n            \"end_date\": \"2025-04-25\",\r\n            \"discount\": 10,\r\n            \"promo_id\": \"PromoC\"\r\n        }\r\n    ]\r\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"https://acme.kronoscope.fountain9.com/atlas/timeseries/api/snop_promotions?dataset_id=<dataset_id>","protocol":"https","host":["acme","kronoscope","fountain9","com"],"path":["atlas","timeseries","api","snop_promotions"],"query":[{"key":"dataset_id","value":"<dataset_id>","description":"Integer"}]}},"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json","description":"","type":"text"}],"cookie":[],"responseTime":null,"body":"{\n    \"data\": \"[{\\\"level_id\\\":\\\"11\\\",\\\"sku_id\\\":\\\"13923\\\",\\\"date\\\":\\\"2025-04-20\\\",\\\"discount\\\":10,\\\"promo_id\\\":\\\"PromoC\\\",\\\"next_order_receive_date\\\":\\\"2025-04-29\\\",\\\"simulated_opening_inventory\\\":0.0,\\\"y_hat\\\":159.45,\\\"y_hat_final\\\":159.45,\\\"avg_duration_forecast\\\":142.82,\\\"estimated_doh\\\":0.0,\\\"promo_approval_flag\\\":\\\"red\\\"},{\\\"level_id\\\":\\\"121\\\",\\\"sku_id\\\":\\\"20061\\\",\\\"date\\\":\\\"2025-04-20\\\",\\\"discount\\\":20,\\\"promo_id\\\":\\\"PromoA, PromoB\\\",\\\"next_order_receive_date\\\":\\\"2025-04-18\\\",\\\"simulated_opening_inventory\\\":null,\\\"y_hat\\\":7.39,\\\"y_hat_final\\\":7.39,\\\"avg_duration_forecast\\\":7.39,\\\"estimated_doh\\\":null,\\\"promo_approval_flag\\\":\\\"blue\\\"},{\\\"level_id\\\":\\\"11\\\",\\\"sku_id\\\":\\\"13923\\\",\\\"date\\\":\\\"2025-04-21\\\",\\\"discount\\\":10,\\\"promo_id\\\":\\\"PromoC\\\",\\\"next_order_receive_date\\\":\\\"2025-04-29\\\",\\\"simulated_opening_inventory\\\":0.0,\\\"y_hat\\\":135.78,\\\"y_hat_final\\\":135.78,\\\"avg_duration_forecast\\\":142.82,\\\"estimated_doh\\\":0.0,\\\"promo_approval_flag\\\":\\\"red\\\"},{\\\"level_id\\\":\\\"11\\\",\\\"sku_id\\\":\\\"13923\\\",\\\"date\\\":\\\"2025-04-22\\\",\\\"discount\\\":10,\\\"promo_id\\\":\\\"PromoC\\\",\\\"next_order_receive_date\\\":\\\"2025-04-29\\\",\\\"simulated_opening_inventory\\\":0.0,\\\"y_hat\\\":140.41,\\\"y_hat_final\\\":140.41,\\\"avg_duration_forecast\\\":142.82,\\\"estimated_doh\\\":0.0,\\\"promo_approval_flag\\\":\\\"red\\\"},{\\\"level_id\\\":\\\"11\\\",\\\"sku_id\\\":\\\"13923\\\",\\\"date\\\":\\\"2025-04-23\\\",\\\"discount\\\":10,\\\"promo_id\\\":\\\"PromoC\\\",\\\"next_order_receive_date\\\":\\\"2025-04-29\\\",\\\"simulated_opening_inventory\\\":0.0,\\\"y_hat\\\":136.29,\\\"y_hat_final\\\":136.29,\\\"avg_duration_forecast\\\":142.82,\\\"estimated_doh\\\":0.0,\\\"promo_approval_flag\\\":\\\"red\\\"},{\\\"level_id\\\":\\\"11\\\",\\\"sku_id\\\":\\\"13923\\\",\\\"date\\\":\\\"2025-04-24\\\",\\\"discount\\\":10,\\\"promo_id\\\":\\\"PromoC\\\",\\\"next_order_receive_date\\\":\\\"2025-04-29\\\",\\\"simulated_opening_inventory\\\":0.0,\\\"y_hat\\\":133.26,\\\"y_hat_final\\\":133.26,\\\"avg_duration_forecast\\\":142.82,\\\"estimated_doh\\\":0.0,\\\"promo_approval_flag\\\":\\\"red\\\"},{\\\"level_id\\\":\\\"11\\\",\\\"sku_id\\\":\\\"13923\\\",\\\"date\\\":\\\"2025-04-25\\\",\\\"discount\\\":10,\\\"promo_id\\\":\\\"PromoC\\\",\\\"next_order_receive_date\\\":\\\"2025-04-29\\\",\\\"simulated_opening_inventory\\\":0.0,\\\"y_hat\\\":151.74,\\\"y_hat_final\\\":151.74,\\\"avg_duration_forecast\\\":142.82,\\\"estimated_doh\\\":0.0,\\\"promo_approval_flag\\\":\\\"red\\\"}]\"\n}"}],"_postman_id":"9d015a81-d256-41ba-af27-46ef1f2afd72"}],"id":"675a1e7d-ee95-4e8e-8e86-21454f6fdb1a","_postman_id":"675a1e7d-ee95-4e8e-8e86-21454f6fdb1a","description":""}]}