{"type":"doc","content":[{"type":"paragraph","content":[{"text":"There are a few options available in order","type":"text"},{"text":" to design automated checks","type":"text","marks":[{"type":"strong"}]},{"text":" for the account`s data integration status.","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"By the SYNC REQUEST response","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"By an endpoint check","type":"text"}]}]}]},{"type":"paragraph"},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{"style":{"value":"none"}},"macroMetadata":{"macroId":{"value":"dd366bdd-233b-45e7-9b01-a33fa40771e7"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"a71e8cf4-b8f1-49e0-ae33-b6fdd06261b4"}},{"type":"heading","attrs":{"level":2},"content":[{"text":"SYNC REQUEST Response","type":"text"}]},{"type":"paragraph","content":[{"text":"If desired, your data integration flow/process can read the response from the ","type":"text"},{"text":"SYNC REQUEST","type":"text","marks":[{"type":"strong"},{"type":"link","attrs":{"href":"https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/394559761"}}]},{"text":". ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"The response will be of type JSON:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"in case of error","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":": ","type":"text","marks":[{"type":"strong"}]},{"text":"400 ","type":"text"},{"text":"BAD REQUEST","type":"text","marks":[{"type":"code"}]},{"text":" HTTP code + a JSON payload like ","type":"text"},{"text":"{\"status\":\"SYNC FAIL\", \"code\":400, \"tm\": YmdHis, \"payload\":[], \"scope\":\"\", \"errors\":[\"error messages\"]}","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"in case of success: ","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":" ","type":"text","marks":[{"type":"em"}]},{"text":"200 ","type":"text"},{"text":"OK","type":"text","marks":[{"type":"code"}]},{"text":" HTTP code + a JSON payload like ","type":"text"},{"text":"{\"status\":\"SYNC OK\", \"code\":200, \"tm\": YmdHis, \"payload\":[], \"errors\":[], \"taskId\":\"solr-load-task-id\"}","type":"text","marks":[{"type":"code"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"use","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":"the to make request to ","type":"text"},{"text":"/task/status/","type":"text","marks":[{"type":"underline"},{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]},{"text":" in order to check the data synchronization status in account’s data index (for product & content).","type":"text"}]}]}]}]}]},{"type":"paragraph","content":[{"text":"The SYNC REQUEST has a series of ","type":"text"},{"text":"failure points & clauses","type":"text","marks":[{"type":"em"}]},{"text":". They are described in the ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/edit-v2/747208705#Data-Integration-Statuses"}},{"text":" section. ","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Account review (WEB)","type":"text"}]},{"type":"paragraph","content":[{"text":"You can review the status of the triggered events in the ","type":"text"},{"text":"Account","type":"text","marks":[{"type":"em"}]},{"text":" page: ","type":"text"},{"text":"/account ","type":"text","marks":[{"type":"underline"},{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]},{"text":"like :","type":"text"}]},{"type":"paragraph","content":[{"type":"inlineCard","attrs":{"url":"https://boxalino-di-process-krceabfwya-ew.a.run.app/account"}},{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Account Review (CLI)","type":"text"}]},{"type":"table","attrs":{"layout":"default","isNumberColumnEnabled":true,"width":760.0,"localId":"b305d553-16e0-4b3b-902c-4f8301fd4d0e"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[91.0]},"content":[{"type":"paragraph","content":[{"text":"Endpoint","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":2,"rowspan":1,"colwidth":[165.0,462.0]},"content":[{"type":"paragraph","content":[{"text":"https://boxalino-di-process-krceabfwya-ew.a.run.app/account/review","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[91.0]},"content":[{"type":"paragraph","content":[{"text":"Method","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":2,"rowspan":1,"colwidth":[165.0,462.0]},"content":[{"type":"paragraph","content":[{"text":"POST","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[91.0]},"content":[{"type":"paragraph","content":[{"text":"Headers","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[165.0]},"content":[{"type":"paragraph","content":[{"text":"Content-Type","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[462.0]},"content":[{"type":"paragraph","content":[{"text":"application/json","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[91.0]},"content":[{"type":"paragraph","content":[{"text":"Body ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[165.0]},"content":[{"type":"paragraph","content":[{"text":"key","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[462.0]},"content":[{"type":"paragraph","content":[{"text":"DATASYNC API key","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[91.0]},"content":[{"type":"paragraph","content":[{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[165.0]},"content":[{"type":"paragraph","content":[{"text":"client","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[462.0]},"content":[{"type":"paragraph","content":[{"text":"account name","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[91.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[165.0]},"content":[{"type":"paragraph","content":[{"text":"created","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[462.0]},"content":[{"type":"paragraph","content":[{"text":"max: ","type":"text"},{"text":"1 MONTH","type":"text","marks":[{"type":"code"}]},{"text":", default: ","type":"text"},{"text":"1 DAY","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":"a filter on the statuses` created timestamp (ordered by most recent)","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"the data is ","type":"text"},{"text":"available in BQ","type":"text","marks":[{"type":"strong"}]},{"text":" up to 15 days for full, 7 days for delta and 1 day for instant; ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"the data is ","type":"text"},{"text":"available in SOLR (data index)","type":"text","marks":[{"type":"strong"}]},{"text":" up to 3 months.","type":"text"}]}]}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[91.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[165.0]},"content":[{"type":"paragraph","content":[{"text":"limit","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[462.0]},"content":[{"type":"paragraph","content":[{"text":"number of logs (ordered by most recent)","type":"text"},{"type":"hardBreak"},{"text":"(default: none","type":"text","marks":[{"type":"em"}]},{"text":")","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[91.0]},"content":[{"type":"paragraph","content":[{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[165.0]},"content":[{"type":"paragraph","content":[{"text":"index","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[462.0]},"content":[{"type":"paragraph","content":[{"text":"account name (with _dev for dev: true)","type":"text"}]},{"type":"paragraph","content":[{"text":"(default: none)","type":"text","marks":[{"type":"em"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[91.0]},"content":[{"type":"paragraph","content":[{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[165.0]},"content":[{"type":"paragraph","content":[{"text":"mode","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[462.0]},"content":[{"type":"paragraph","content":[{"text":"D","type":"text","marks":[{"type":"strong"}]},{"text":" for delta , ","type":"text"},{"text":"I ","type":"text","marks":[{"type":"strong"}]},{"text":"for instant update, ","type":"text"},{"text":"F","type":"text","marks":[{"type":"strong"}]},{"text":" for full","type":"text"},{"type":"hardBreak"},{"type":"hardBreak"},{"text":"(default: none)","type":"text","marks":[{"type":"em"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[91.0]},"content":[{"type":"paragraph","content":[{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[165.0]},"content":[{"type":"paragraph","content":[{"text":"type","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[462.0]},"content":[{"type":"paragraph","content":[{"text":"product, user, content, user_content, order","type":"text"}]},{"type":"paragraph","content":[{"text":"(default: none)","type":"text","marks":[{"type":"em"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[91.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[165.0]},"content":[{"type":"paragraph","content":[{"text":"status","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[462.0]},"content":[{"type":"paragraph","content":[{"text":"SYNC - sync requests and the status","type":"text"},{"type":"hardBreak"},{"text":"LOAD - load requests and status","type":"text"},{"type":"hardBreak"},{"text":"OK - ok processes","type":"text"},{"type":"hardBreak"},{"text":"FAIL - fail statuses","type":"text"},{"type":"hardBreak"},{"text":"none - all logs ","type":"text"},{"type":"hardBreak"},{"type":"hardBreak"},{"text":"(default: none)","type":"text","marks":[{"type":"em"}]}]}]}]}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"For example, this request will return the last SYNC OK (succesfull sync request):","type":"text"}]},{"type":"codeBlock","content":[{"text":"curl https://boxalino-di-process-krceabfwya-ew.a.run.app/account/review \\\n -X POST \\\n -d \"{\\n \\\"client\\\": \\\"BOXALINO_ACCOUNT\\\",\\n \\\"key\\\": \\\"BOXALINO_ACCOUNT_ADMIN_KEY\\\",\\n \\\"index\\\": \\\"prod\\\",\\n \\\"mode\\\": \\\"F\\\",\\n \\\"type\\\": \\\"product\\\",\\n \\\"status\\\": \\\"SYNC OK\\\",\\n \\\"created\\\": \\\"1 DAY\\\"\\n}\" \\\n -H \"Content-Type: application/json\" ","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"The API response for a request for status: “SYNC OK”, limit:1 - would be a JSON list, like:","type":"text"}]},{"type":"codeBlock","content":[{"text":"[\n {\n \"ID\": \"UUID-FOR-THE-SYNC-REQUEST\",\n \"RequestReceivedAt\": \"Y-m-d H:i:s\",\n \"Status\": \"SYNC OK\",\n \"Message\": null,\n \"Timestamp\": \"YmdHis,\n \"VersionTs\": \"TIME-IN-UNIX-MS\",\n \"Project\": null,\n \"Dataset\": null,\n \"Document\": null,\n \"Default\": \"[]\"\n }\n]","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Data Integration Statuses","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":760.0,"localId":"6d816137-31d1-4c7e-9308-034cba2c3f73"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[300.0]},"content":[{"type":"paragraph","content":[{"text":"Status Code","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"Meaning","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":2,"background":"#4c9aff","rowspan":1,"colwidth":[300.0,455.0]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"STATUS CODES DURING SYNC REQUESTS","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ffffff"}},{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[300.0]},"content":[{"type":"paragraph","content":[{"text":"SYNC REQUEST","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"SYNCR REQUEST","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"a ","type":"text"},{"text":"SYNC REQUEST","type":"text","marks":[{"type":"strong"},{"type":"link","attrs":{"href":"https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/394559761"}}]},{"text":" was done (/sync); once the SYNC REQUEST is received, the ","type":"text"},{"text":"compute","type":"text","marks":[{"type":"strong"}]},{"text":" process starts","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[300.0]},"content":[{"type":"paragraph","content":[{"text":"SYNC OK","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"the data content was exported to SOLR; ","type":"text"},{"type":"hardBreak"},{"text":"(for doc_product/ doc_content) ","type":"text","marks":[{"type":"em"}]},{"text":"the status of the process is available upon calling the ","type":"text"},{"text":"/task/status/","type":"text","marks":[{"type":"underline"},{"type":"textColor","attrs":{"color":"#36b37e"}},{"type":"strong"}]},{"text":" service","type":"text"},{"type":"hardBreak"},{"type":"hardBreak"},{"text":"API response: HTTP code ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"200","type":"text","marks":[{"type":"code"}]},{"text":", JSON body with ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"payload","type":"text","marks":[{"type":"code"}]},{"text":"(created BQ resources), ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"errors,tm, code, status","type":"text","marks":[{"type":"code"}]},{"text":" (SYNC OK)","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[300.0]},"content":[{"type":"paragraph","content":[{"text":"SYNC FAIL","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"the data update failed;","type":"text"}]},{"type":"paragraph","content":[{"text":"API response: HTTP code ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"400","type":"text","marks":[{"type":"code"}]},{"text":", JSON body with ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"scope","type":"text","marks":[{"type":"code"}]},{"text":" (the logged status - reason for failure), ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"payload","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"errors, tm, code, status","type":"text","marks":[{"type":"code"}]},{"text":" (SYNC FAIL)","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[300.0]},"content":[{"type":"paragraph","content":[{"text":"SYNC REQUEST FREQUENCY REACH","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"SYNC REQUEST was denied; too many requests in the last hour. The limits are:","type":"text"},{"type":"hardBreak"},{"text":"- ","type":"text"},{"text":"product","type":"text","marks":[{"type":"em"}]},{"text":" : max 2 F, max 20 D, max 30 I","type":"text"},{"type":"hardBreak"},{"text":"-","type":"text"},{"text":"others:","type":"text","marks":[{"type":"em"}]},{"text":" max 10 F, max 30 D/I.","type":"text"},{"type":"hardBreak"},{"type":"hardBreak"},{"text":"API response: HTTP code ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"429","type":"text","marks":[{"type":"code"}]},{"text":"JSON body with ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"scope","type":"text","marks":[{"type":"code"}]},{"text":" (this logged status), ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"payload","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"errors, tm, code, status","type":"text","marks":[{"type":"code"}]},{"text":" (SYNC FAIL)","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[300.0]},"content":[{"type":"paragraph","content":[{"text":"FAIL AUTH","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"authentication headers are invalid / not a match for the account","type":"text"}]},{"type":"paragraph","content":[{"text":"API response: HTTP code ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"401","type":"text","marks":[{"type":"code"}]},{"text":", JSON body with ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"scope","type":"text","marks":[{"type":"code"}]},{"text":" (this logged status), ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"payload","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"errors, tm, code, status","type":"text","marks":[{"type":"code"}]},{"text":" (SYNC FAIL)","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[300.0]},"content":[{"type":"paragraph","content":[{"text":"EMPTY CONTENT","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"there is no content to be synchronized.","type":"text"}]},{"type":"paragraph","content":[{"text":"API response: HTTP code ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"204","type":"text","marks":[{"type":"code"}]},{"text":", JSON body with ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"scope","type":"text","marks":[{"type":"code"}]},{"text":" (this logged status), ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"payload","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"errors, tm, code, status","type":"text","marks":[{"type":"code"}]},{"text":" (SYNC FAIL)","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[300.0]},"content":[{"type":"paragraph","content":[{"text":"STOP SYNC","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"the ","type":"text"},{"text":"SYNC REQUEST","type":"text","marks":[{"type":"link","attrs":{"href":"https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/394559761"}}]},{"text":" was stopped (for ex: the content quota was not reached: min X products to be synced, OR the doc_X table is empty)","type":"text"}]},{"type":"paragraph","content":[{"text":"API response: HTTP code ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"412","type":"text","marks":[{"type":"code"}]},{"text":", JSON body with ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"scope","type":"text","marks":[{"type":"code"}]},{"text":" (the logged status), ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"payload","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"errors, tm, code, status","type":"text","marks":[{"type":"code"}]},{"text":" (SYNC FAIL)","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[300.0]},"content":[{"type":"paragraph","content":[{"text":"DENIED SYNC","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"it appears in the case of ","type":"text"},{"text":"product delta sync requests","type":"text","marks":[{"type":"strong"}]},{"text":" when the doc_X content is too much (ex: over 1GB BQ table size). ","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"API response: HTTP code ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"400","type":"text","marks":[{"type":"code"}]},{"text":", JSON body with ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"scope","type":"text","marks":[{"type":"code"}]},{"text":" (this logged status), ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"payload","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"errors, tm, code, status","type":"text","marks":[{"type":"code"}]},{"text":" (SYNC FAIL)","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[300.0]},"content":[{"type":"paragraph","content":[{"text":"FAIL SOLR EXPORT","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"the export of the generated file failed (","type":"text"},{"text":"data index not updated","type":"text","marks":[{"type":"textColor","attrs":{"color":"#bf2600"}},{"type":"strong"}]},{"text":")","type":"text"},{"type":"hardBreak"}]},{"type":"paragraph","content":[{"text":"API response: HTTP code ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"400","type":"text","marks":[{"type":"code"}]},{"text":", JSON body with ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"scope","type":"text","marks":[{"type":"code"}]},{"text":" (this logged status), ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"payload","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"errors, tm, code, status","type":"text","marks":[{"type":"code"}]},{"text":" (SYNC FAIL)","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[300.0]},"content":[{"type":"paragraph","content":[{"text":"BIG SOLR CONTENT","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"SOLRCOMPUTE REQUEST","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"SOLRCOMPUTE OK","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"generating the SOLR file for SOLR export from the doc_X__ file","type":"text"},{"type":"hardBreak"},{"type":"hardBreak"},{"text":"(results in ","type":"text"},{"text":"SYNC OK ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#006644"}},{"type":"strong"}]},{"text":"response)","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[300.0]},"content":[{"type":"paragraph","content":[{"text":"SOLRSYNC REQUEST","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"exporting the solr-compute file (above) to SOLR for sync","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[300.0]},"content":[{"type":"paragraph","content":[{"text":"DISPATCHED SYNC REQUEST","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"SYNCCOMPUTE REQUEST","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"the BQ compute process log (for dispatched requests)","type":"text"},{"type":"hardBreak"},{"type":"hardBreak"},{"text":"(results in ","type":"text"},{"text":"SYNC OK ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#006644"}},{"type":"strong"}]},{"text":"response)","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[300.0]},"content":[{"type":"paragraph","content":[{"text":"RESYNCACCOUNT REQUEST","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"RESYNCACCOUNT OK","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"re-sync request (triggered on client request, in additional flows for internal service failure); ","type":"text"},{"type":"hardBreak"},{"text":"(triggers the /sync request for given tm/index/type/mode)","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[300.0]},"content":[{"type":"paragraph","content":[{"text":"SYNCCHECK OK","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"a ","type":"text"},{"text":"synccheck","type":"text","marks":[{"type":"em"}]},{"text":" request was done (/sync/check); this is done for ex for D/I to access the last ","type":"text"},{"text":"SYNC OK","type":"text","marks":[{"type":"strong"}]},{"text":" status for the account and type","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":2,"background":"#4c9aff","rowspan":1,"colwidth":[300.0,455.0]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"STATUS CODES DURING LOAD REQUESTS","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ffffff"}},{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[300.0]},"content":[{"type":"paragraph","content":[{"text":"LOAD REQUEST","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"a ","type":"text"},{"text":"LOAD REQUEST","type":"text","marks":[{"type":"link","attrs":{"href":"https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/415432770"}}]},{"text":" was received (/load); once the ","type":"text"},{"text":"LOAD REQUEST","type":"text","marks":[{"type":"link","attrs":{"href":"https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/415432770"}}]},{"text":" is received it:","type":"text"},{"type":"hardBreak"},{"text":"1. creates GCS bucket for account (if needed)","type":"text"},{"type":"hardBreak"},{"text":"2. creates the BQ dataset for account & mode (if needed)","type":"text"},{"type":"hardBreak"},{"text":"3. loads the content in GCS file (doc___.json file)","type":"text"},{"type":"hardBreak"},{"text":"4. loads the GCS file in BQ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[300.0]},"content":[{"type":"paragraph","content":[{"text":"LOAD OK","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"the doc_X data structure was loaded succesfully in BQ","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"API response: HTTP code ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"200","type":"text","marks":[{"type":"code"}]},{"text":", JSON body with ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"payload","type":"text","marks":[{"type":"code"}]},{"text":" (created resource), ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"status","type":"text","marks":[{"type":"code"}]},{"text":" (LOAD OK), ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"code","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text"},{"text":"tm","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[300.0]},"content":[{"type":"paragraph","content":[{"text":"FAIL BQ LOAD","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"BQ load step failed","type":"text"}]},{"type":"paragraph","content":[{"text":"API response: HTTP code ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"400","type":"text","marks":[{"type":"code"}]},{"text":", JSON body with ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"payload","type":"text","marks":[{"type":"code"}]},{"text":" (created resource), ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"status","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"code","type":"text","marks":[{"type":"code"}]},{"text":" , ","type":"text"},{"text":"errors","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text"},{"text":"tm","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[300.0]},"content":[{"type":"paragraph","content":[{"text":"LOADBYCHUNK REQUEST","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"a ","type":"text"},{"text":"LOAD BY CHUNK ","type":"text","marks":[{"type":"link","attrs":{"href":"https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/415432770/Load+Request#Load-By-Chunks"}}]},{"text":"request was received. when this happens - it loads the content in a GCS file (doc___-.json)","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"API response: HTTP code ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"200","type":"text","marks":[{"type":"code"}]},{"text":", STRING response with the GCS public URL","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[300.0]},"content":[{"type":"paragraph","content":[{"text":"LOADBYCHUNK OK","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"the GCS file (doc___-.json) was created","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[300.0]},"content":[{"type":"paragraph","content":[{"text":"LOADBYCHUNK FAIL","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"the GCS file was not properly loaded","type":"text"}]},{"type":"paragraph","content":[{"text":"API response: HTTP code ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"400","type":"text","marks":[{"type":"code"}]},{"text":", JSON body with ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"payload","type":"text","marks":[{"type":"code"}]},{"text":" (created resource), ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"status","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"code","type":"text","marks":[{"type":"code"}]},{"text":" , ","type":"text"},{"text":"errors","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text"},{"text":"tm","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[300.0]},"content":[{"type":"paragraph","content":[{"text":"FAIL GCS","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"the GCS bucket / content failed to generate","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"API response: HTTP code ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"400","type":"text","marks":[{"type":"code"}]},{"text":", JSON body with ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"payload","type":"text","marks":[{"type":"code"}]},{"text":" (created resource), ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"status","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"code","type":"text","marks":[{"type":"code"}]},{"text":" , ","type":"text"},{"text":"errors","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text"},{"text":"tm","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[300.0]},"content":[{"type":"paragraph","content":[{"text":"LOADBQ REQUEST","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"loads all the chunk files in BQ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[300.0]},"content":[{"type":"paragraph","content":[{"text":"LOADBQ OK","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"succesfully loaded the doc_ content in BQ; ","type":"text"},{"type":"hardBreak"},{"text":"the table _.doc___ is available","type":"text"}]},{"type":"paragraph","content":[{"text":"API response: HTTP code ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"200","type":"text","marks":[{"type":"code"}]},{"text":", JSON body with ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"payload","type":"text","marks":[{"type":"code"}]},{"text":" (created resource), ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"status","type":"text","marks":[{"type":"code"}]},{"text":" (LOAD OK), ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"code","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text"},{"text":"tm","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[300.0]},"content":[{"type":"paragraph","content":[{"text":"LOADBQ FAIL","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"the BQ table was unable to generate based on the available doc___-*.json content","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"API response: HTTP code ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"400","type":"text","marks":[{"type":"code"}]},{"text":", JSON body with ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"payload","type":"text","marks":[{"type":"code"}]},{"text":" (created resource), ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"status","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"code","type":"text","marks":[{"type":"code"}]},{"text":" , ","type":"text"},{"text":"errors","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text"},{"text":"tm","type":"text","marks":[{"type":"code"}]}]}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Data (Item) Review","type":"text"}]},{"type":"panel","attrs":{"panelType":"note"},"content":[{"type":"paragraph","content":[{"text":"The item review is available as a web service in ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://boxalino-di-process-krceabfwya-ew.a.run.app/"}},{"text":" ","type":"text"}]}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":313,"id":"80fbc3df-5207-44db-97b5-a78b09bc83b5","collection":"contentId-747208705","type":"file","height":61}}]},{"type":"paragraph","content":[{"text":"If desired to avoid the web form, you can access directly in the WEB/CLI the content exported for a given item SKU / ID or products group.","type":"text"}]},{"type":"paragraph","content":[{"text":"The requested link has the following structure:","type":"text"},{"type":"hardBreak"},{"text":"/","type":"text","marks":[{"type":"textColor","attrs":{"color":"#0747a6"}},{"type":"strong"}]},{"text":"item/","type":"text","marks":[{"type":"strong"}]},{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#008da6"}},{"type":"strong"}]},{"text":"/","type":"text","marks":[{"type":"strong"}]},{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#006644"}},{"type":"strong"}]},{"text":"/","type":"text","marks":[{"type":"strong"}]},{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":"/","type":"text","marks":[{"type":"strong"}]},{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ffc400"}},{"type":"strong"}]},{"text":"/","type":"text","marks":[{"type":"strong"}]},{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#6554c0"}},{"type":"strong"}]},{"text":"/","type":"text","marks":[{"type":"strong"}]},{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}},{"type":"strong"}]},{"type":"hardBreak"}]},{"type":"table","attrs":{"layout":"default","isNumberColumnEnabled":true,"width":760.0,"localId":"8874c957-3ee1-45ee-b6f2-d4dc078f6522"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[206.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#0747a6"}},{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[497.0]},"content":[{"type":"paragraph","content":[{"type":"inlineCard","attrs":{"url":"https://boxalino-di-process-krceabfwya-ew.a.run.app/"}},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[206.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#008da6"}},{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[497.0]},"content":[{"type":"paragraph","content":[{"text":"the API Key with the role ","type":"text"},{"text":"ADMIN","type":"text","marks":[{"type":"code"}]},{"text":" from Intelligence Admin ","type":"text"}]},{"type":"paragraph","content":[{"text":"(the API Key used for the DI SYNC REQUEST)","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[206.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#006644"}},{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[497.0]},"content":[{"type":"paragraph","content":[{"text":"dev | prod","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[206.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[497.0]},"content":[{"type":"paragraph","content":[{"text":"The value of the ","type":"text"},{"text":"type","type":"text","marks":[{"type":"code"}]},{"text":" parameter in the SYNC REQUEST","type":"text"}]},{"type":"paragraph","content":[{"text":"ex: product | user | order | content ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[206.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ffc400"}},{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[497.0]},"content":[{"type":"paragraph","content":[{"text":"F | f","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[206.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#6554c0"}},{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[497.0]},"content":[{"type":"paragraph","content":[{"text":"id | sku | products_group_id","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[206.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}},{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[497.0]},"content":[{"type":"paragraph","content":[{"text":"the value for the given field ","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":"In the WEB/CLI the content will be returned as a JSON. You can use any JSON formatter to structure it for an easier view.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Using BigQuery ","type":"text"}]},{"type":"paragraph","content":[{"text":"The client`s team has ","type":"text"},{"text":"read & view","type":"text","marks":[{"type":"strong"}]},{"text":" access to the ","type":"text"},{"text":"data integration BigQuery datasets","type":"text","marks":[{"type":"em"}]},{"text":" from the ","type":"text"},{"text":"rtux-data-integration","type":"text","marks":[{"type":"code"}]},{"text":" GCP project. ","type":"text"}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"In order to be able to execute BQ queries in BQ view ","type":"text"},{"text":"https://console.cloud.google.com/bigquery","type":"text","marks":[{"type":"link","attrs":{"href":"https://console.cloud.google.com/bigquery"}}]},{"text":" - the integrator/client:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" must be","type":"text"},{"text":" authenticated with a Google account. ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The scope of a project (other than ","type":"text"},{"text":"bx-bdp-53322","type":"text","marks":[{"type":"code"}]},{"text":" or ","type":"text"},{"text":"rtux-data-integration","type":"text","marks":[{"type":"code"}]},{"text":" ) must be used in order to ","type":"text"},{"text":"run BigQuery jobs","type":"text","marks":[{"type":"strong"}]},{"text":". ","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":668,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":458,"alt":"image-20240318-114519.png","id":"0a7b6388-5a76-4794-b3c5-6220757aadbf","collection":"contentId-747208705","type":"file","height":202}},{"type":"caption","content":[{"text":"Select a GCP project from which you have access to run BQ jobs","type":"text","marks":[{"type":"em"}]}]}]},{"type":"paragraph"}]},{"type":"paragraph","content":[{"text":"Before continuing, make sure to identify:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" ","type":"text"},{"text":"index","type":"text","marks":[{"type":"code"}]},{"text":" value: if dev=true → ","type":"text"},{"text":"_dev","type":"text","marks":[{"type":"code"}]},{"text":" ; if dev=false (or unset) → ","type":"text"},{"text":"``","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"tm","type":"text","marks":[{"type":"code"}]},{"text":" is the last SYNC OK tm (or LOADBQ OK) (check CLI command above to retrieve it)","type":"text"},{"type":"hardBreak"}]}]}]},{"type":"paragraph","content":[{"text":"The following SQLs can be used to check the exported data and, as well, the computed data","type":"text"}]},{"type":"expand","attrs":{"title":"Check the exported product data by SKU"},"content":[{"type":"codeBlock","content":[{"text":"SELECT pg.* FROM `rtux-data-integration._F.doc_product_F_`\nJOIN UNNEST(product_line.product_groups) pg\nJOIN UNNEST(pg.skus) sku\nWHERE sku.sku = \"\"","type":"text"}]},{"type":"paragraph","content":[{"text":"The SQL can be used to also check different properties at the level of sku (sku) or product_groups (pg).","type":"text"}]}]},{"type":"expand","attrs":{"title":"Check the exported product data by ID"},"content":[{"type":"codeBlock","content":[{"text":"SELECT pg.* FROM `rtux-data-integration._F.doc_product_F_`\nJOIN UNNEST(product_line.product_groups) pg\nJOIN UNNEST(pg.skus) sku\nWHERE sku.internal_id = \"\"","type":"text"}]}]},{"type":"expand","attrs":{"title":"Check final product attributes"},"content":[{"type":"codeBlock","content":[{"text":"SELECT DISTINCT(property_name) FROM `rtux-data-integration._F.doc_computed_F_`\n-- WHERE id=\"\" #optional add filter by product id","type":"text"}]}]},{"type":"expand","attrs":{"title":"Identify values for a specific property (and nr of matching products)"},"content":[{"type":"codeBlock","content":[{"text":"SELECT pv, COUNT(*) AS products_match FROM `rtux-data-integration._F.doc_computed_F_`\nJOIN UNNEST(property_values) pv\nWHERE property_name = \"\"\nGROUP BY pv","type":"text"}]}]},{"type":"paragraph"}],"version":1}

Browser not supported