{"id":21122,"date":"2025-10-17T12:20:35","date_gmt":"2025-10-17T10:20:35","guid":{"rendered":"https:\/\/www.dase-analytics.com\/blog\/?p=21122\/"},"modified":"2025-10-17T12:20:35","modified_gmt":"2025-10-17T10:20:35","slug":"z-google-sheets-do-bigquery-a-spat","status":"publish","type":"post","link":"https:\/\/www.dase-analytics.com\/blog\/sk\/z-google-sheets-do-bigquery-a-spat\/","title":{"rendered":"Z Google Sheets do BigQuery a sp\u00e4\u0165"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">V\u0161etci sa dnes stret\u00e1vame s obrovsk\u00fdm mno\u017estvom d\u00e1t. Mnoh\u00ed pr\u00e1ve v Google Sheets, ktor\u00fd je skvel\u00fdm pomocn\u00edkom pri ka\u017edodennej pr\u00e1ci. V podstate je to jednoduch\u00fd n\u00e1stroj, no pod kapotou skr\u00fdva obrovsk\u00e9 mo\u017enosti. Jednou z nich je aj prepojenie <strong>Google Sheets a BigQuery.\u00a0<\/strong><\/span><\/p>\n<p><span style=\"font-weight: 400;\">Spojenie d\u00e1t z <strong>Google Sheets<\/strong> napr\u00edklad s d\u00e1tami z <strong>Google Analytics<\/strong> alebo <strong>Search Console<\/strong> v BigQuery v\u00e1m otvor\u00ed dvere k ove\u013ea <strong>hlb\u0161\u00edm anal\u00fdzam<\/strong> a <strong>lep\u0161\u00edm preh\u013eadom<\/strong>.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">A funguje to aj naopak \u2013 d\u00e1ta z BigQuery si viete jednoducho stiahnu\u0165 a \u010falej s nimi pracova\u0165 v prostred\u00ed tabuliek.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V tomto \u010dl\u00e1nku si uk\u00e1\u017eeme, ako na to. Zameriame sa na prepojenie pomocou AppScriptu, ale aj na nat\u00edvnu integr\u00e1ciu, ktor\u00fa pon\u00faka priamo Google Sheets. &#x1f680;<\/span><\/p>\n<h2><b>\u010co je Google Apps Script?<\/b><\/h2>\n<p><span style=\"font-weight: 400;\"><strong>Google Apps Script<\/strong> je skriptovac\u00ed jazyk zalo\u017een\u00fd na <strong>Javascripte<\/strong>, ktor\u00fd je ur\u010den\u00fd na automatiz\u00e1ciu, integr\u00e1ciu a roz\u0161\u00edrenie funkcionality aplik\u00e1ci\u00ed v r\u00e1mci bal\u00edka Google Workspace (vr\u00e1tane Google Sheets, Docs, Gmail a in\u00fdch).\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Pre market\u00e9rov to znamen\u00e1 mo\u017enos\u0165 automatizova\u0165 procesy, ktor\u00e9 by inak museli by\u0165 vykon\u00e1van\u00e9 manu\u00e1lne \u2013 napr\u00edklad pravideln\u00fd export reportov alebo aktualiz\u00e1ciu d\u00e1t v dashboardoch.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Sta\u010d\u00ed len raz nap\u00edsa\u0165 (alebo skop\u00edrova\u0165 \ud83d\ude42 skript a n\u00e1sledne ho sp\u00fa\u0161\u0165a\u0165 jedn\u00fdm kliknut\u00edm. U\u0161etr\u00edte si t\u00fdm mno\u017estvo \u010dasu.<\/span><\/p>\n<h3><b>Predt\u00fdm ne\u017e za\u010dnete<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Pre nastavenie prepojenia budete potrebova\u0165:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Google Sheets dokument<\/b><span style=\"font-weight: 400;\"> (ako cie\u013eov\u00fd alebo zdrojov\u00fd bod d\u00e1t).<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Pr\u00edstupov\u00e9 opr\u00e1vnenie<\/b><span style=\"font-weight: 400;\"> (autoriz\u00e1cia) do slu\u017eby <\/span><b>Google BigQuery<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Aktivovan\u00e9 BigQuery API<\/b><span style=\"font-weight: 400;\"> v pr\u00edslu\u0161nom projekte slu\u017eby Google Cloud Platform.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Minim\u00e1lne budete potrebova\u0165 rolu <\/span><b>BigQuery Data Viewer<\/b><span style=\"font-weight: 400;\"> (pre \u010d\u00edtanie d\u00e1t) alebo <\/span><b>BigQuery Data Editor<\/b><span style=\"font-weight: 400;\"> (pre z\u00e1pis). Nedostato\u010dn\u00e9 opr\u00e1vnenia s\u00fa naj\u010dastej\u0161ou pr\u00ed\u010dinou zlyhania prepojenia.<\/span><\/p>\n<h3><b>\u00a0Z Google Sheets do BigQuery<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Chcete d\u00e1ta z va\u0161ej tabu\u013eky dosta\u0165 do BigQuery? Pomocou nasleduj\u00faceho skriptu to zvl\u00e1dnete v nieko\u013ek\u00fdch krokoch.<\/span><\/p>\n<ol>\n<li>\n<h4><strong> Pripravte si dokument<\/strong><\/h4>\n<\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">Za\u010dnite otvoren\u00edm Google Sheets so zdrojov\u00fdmi d\u00e1tami. D\u00f4le\u017eit\u00e9 je, aby prv\u00fd riadok tabu\u013eky obsahoval n\u00e1zvy st\u013apcov (headers) \u2013 tie sa toti\u017e automaticky pou\u017eij\u00fa ako n\u00e1zvy pol\u00ed v BigQuery tabu\u013eke.<\/span><\/p>\n<ol start=\"2\">\n<li>\n<h4><strong> Otvorte Apps Script a vlo\u017ete k\u00f3d<\/strong><\/h4>\n<\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">V menu kliknite na Roz\u0161\u00edrenia \u2192 Apps Script.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Zma\u017ete v\u0161etok predpripraven\u00fd k\u00f3d a vlo\u017ete k\u00f3d, ktor\u00fd n\u00e1jdete zadarmo v na\u0161om <a href=\"https:\/\/gist.github.com\/dase-analytics\/d26381b1a3b02e23070ae0e7e692b4b8\" target=\"_blank\" rel=\"noopener\">Gist.<\/a><\/span><\/p>\n<p><a href=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/3-51.png\" data-rel=\"lightbox-image-0\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-21125 size-full\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/3-51.png\" alt=\"3Z Google Sheets do BigQuery a sp\u00e4\u0165\" width=\"1127\" height=\"483\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/3-51.png 1127w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/3-51-300x129.png 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/3-51-1024x439.png 1024w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/3-51-600x257.png 600w\" sizes=\"(max-width: 1127px) 100vw, 1127px\" \/><\/a><\/p>\n<ol start=\"3\">\n<li>\n<h4><strong> Nastavte konfigur\u00e1ciu<\/strong><\/h4>\n<\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">V skripte je potrebn\u00e9 upravi\u0165 z\u00e1kladn\u00e9 identifik\u00e1tory projektu, datasetu a tabu\u013eky. <\/span><span style=\"font-weight: 400;\">Na za\u010diatku skriptu teda dopl\u0148te hodnoty pre<\/span><strong> PROJECT_ID, DATASET_ID, TABLE_ID a SHEET_NAME<\/strong><span style=\"font-weight: 400;\"><strong>.<\/strong> T\u00fdm ur\u010d\u00edte, kam sa maj\u00fa d\u00e1ta odosla\u0165.<\/span><\/p>\n<p><strong>!!! Hodnota premennej SHEET_NAME sa mus\u00ed zhodova\u0165 s n\u00e1zvom h\u00e1rku, v ktorom m\u00e1te ulo\u017een\u00fa tabu\u013eku na export.\u00a0<\/strong><\/p>\n<ol start=\"4\">\n<li>\n<h4><strong> Povo\u013ete BigQuery slu\u017ebu<\/strong><\/h4>\n<\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">Aby skript mohol s BigQuery komunikova\u0165, je potrebn\u00e9 povoli\u0165 aj tzv. <\/span><b>BigQuery Service<\/b><span style=\"font-weight: 400;\">. Urob\u00edte to priamo v editore AppScriptu kliknut\u00edm na \u201e+\u201c ved\u013ea polo\u017eky <\/span><i><span style=\"font-weight: 400;\">Services<\/span><\/i><span style=\"font-weight: 400;\"> a pridan\u00edm <\/span><i><span style=\"font-weight: 400;\">BigQuery API<\/span><\/i><span style=\"font-weight: 400;\">.\u00a0<\/span><\/p>\n<p><a href=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/11-10.png\" data-rel=\"lightbox-image-1\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-21126 size-full\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/11-10.png\" alt=\"11Z Google Sheets do BigQuery a sp\u00e4\u0165\" width=\"1106\" height=\"983\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/11-10.png 1106w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/11-10-300x267.png 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/11-10-1024x910.png 1024w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/11-10-600x533.png 600w\" sizes=\"(max-width: 1106px) 100vw, 1106px\" \/><\/a><\/p>\n<ol start=\"5\">\n<li>\n<h4><strong> Autorizujte skript<\/strong><\/h4>\n<\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">Ulo\u017ee zmeny v skripte. V hornom menu vyberte funkciu <strong>exportSheetToBigQuery<\/strong> a kliknite na tla\u010didlo <strong>Spusti\u0165 (&#x25b6;).<\/strong> Prejdite jednorazov\u00fdm autoriza\u010dn\u00fdm procesom, aby ste skriptu povolili pr\u00edstup k v\u00e1\u0161mu BigQuery.\u00a0<\/span><\/p>\n<p><a href=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/1-63.png\" data-rel=\"lightbox-image-2\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-21123 size-full\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/1-63.png\" alt=\"1Z Google Sheets do BigQuery a sp\u00e4\u0165\" width=\"1124\" height=\"574\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/1-63.png 1124w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/1-63-300x153.png 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/1-63-1024x523.png 1024w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/1-63-600x306.png 600w\" sizes=\"(max-width: 1124px) 100vw, 1124px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\"><strong>V\u00fdsledkom je, \u017ee v\u0161etky d\u00e1ta z v\u00e1\u0161ho h\u00e1rku sa prenes\u00fa do vybranej tabu\u013eky v BigQuery.<\/strong> Tento postup sa d\u00e1 \u010falej automatizova\u0165 \u2013 napr\u00edklad sp\u00fa\u0161\u0165a\u0165 skript ka\u017ed\u00fd de\u0148 o 03:45 hod.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Skript si, m\u00f4\u017eete prisp\u00f4sobi\u0165 presne pod\u013ea va\u0161ich po\u017eiadaviek. Sta\u010d\u00ed trochu <\/span><strong><i>vibe codingu<\/i><\/strong><span style=\"font-weight: 400;\"><strong>.<\/strong> M\u00f4\u017eete prida\u0165 valida\u010dn\u00e9 pravidl\u00e1 pre kontrolu integrity konkr\u00e9tnych st\u013apcov, filtrovanie riadkov, transform\u00e1ciu form\u00e1tov, \u010di dokonca logovanie (zaznamen\u00e1vanie) priebehu cel\u00e9ho exportu.<\/span><\/p>\n<h3><b>Z BigQuery do Google Sheets<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Ak potrebujete prenies\u0165 d\u00e1ta<strong> z BigQuery priamo do Google Sheets tabu\u013eky<\/strong>, m\u00e1te k dispoz\u00edcii nieko\u013eko sp\u00f4sobov. Najjednoduch\u0161\u00ed je vyu\u017eitie <strong>nat\u00edvnej integr\u00e1cie.<\/strong><\/span><\/p>\n<p><span style=\"font-weight: 400;\">Nat\u00edvny d\u00e1tov\u00fd konektor v\u00e1m umo\u017en\u00ed pripoji\u0165 cel\u00fa tabu\u013eku alebo pou\u017ei\u0165<strong><a href=\"https:\/\/www.dase-analytics.com\/blog\/sk\/bigquery-ga4-sql-minimum-pre-marketerov\/\" target=\"_blank\" rel=\"noopener\"> vlastn\u00fd SQL dopyt<\/a> (query)<\/strong> na extrakciu len t\u00fdch d\u00e1t, ktor\u00e9 naozaj potrebujete.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Postup je skuto\u010dne jednoduch\u00fd:<\/span><\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Prejdite do menu: <\/span><b>D\u00e1ta<\/b><span style=\"font-weight: 400;\"> \u2192 <\/span><b>D\u00e1tov\u00e9 konektory<\/b><span style=\"font-weight: 400;\"> \u2192 <\/span><b>Pripoji\u0165 k BigQuery<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Vyberte po\u017eadovan\u00fd <\/span><b>projekt<\/b><span style=\"font-weight: 400;\">, <\/span><b>dataset<\/b><span style=\"font-weight: 400;\"> a <\/span><b>konkr\u00e9tnu tabu\u013eku<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p><a href=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/2-61.png\" data-rel=\"lightbox-image-3\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-21124 size-full\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/2-61.png\" alt=\"2Z Google Sheets do BigQuery a sp\u00e4\u0165\" width=\"932\" height=\"730\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/2-61.png 932w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/2-61-300x235.png 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/2-61-600x470.png 600w\" sizes=\"(max-width: 932px) 100vw, 932px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Ak by ste mali probl\u00e9m s pr\u00edstupov\u00fdmi pr\u00e1vami alebo potrebovali zlo\u017eitej\u0161ie rie\u0161enie na mieru, op\u00e4\u0165 prich\u00e1dza na rad Apps Script. <strong>Postup je podobn\u00fd ako pri exporte d\u00e1t do BigQuery.\u00a0<\/strong><\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">V editore Apps Script vytvor\u00edte nov\u00fd skript.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Vlo\u017e\u00edte do\u0148 funkciu ur\u010den\u00fa pre <\/span><b>import d\u00e1t<\/b><span style=\"font-weight: 400;\">. Pr\u00edklad takejto funkcie je dostupn\u00fd v na\u0161om <a href=\"https:\/\/gist.github.com\/dase-analytics\/d26381b1a3b02e23070ae0e7e692b4b8\" target=\"_blank\" rel=\"noopener\">Gist.<\/a><\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Dopln\u00edte potrebn\u00e9 parametre, ako s\u00fa query, project id a n\u00e1zov cie\u013eov\u00e9ho h\u00e1rku.<\/span><\/li>\n<\/ul>\n<p><strong>!!! Sheet ID je unik\u00e1tny \u010d\u00edseln\u00fd identifik\u00e1tor, ktor\u00fd n\u00e1jdete v URL adrese prehliada\u010da, ke\u010f m\u00e1te dan\u00fd h\u00e1rok otvoren\u00fd. !!!<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"> <a href=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/4-47.png\" data-rel=\"lightbox-image-4\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-21127 size-full\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/4-47.png\" alt=\"4Z Google Sheets do BigQuery a sp\u00e4\" width=\"1127\" height=\"483\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/4-47.png 1127w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/4-47-300x129.png 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/4-47-1024x439.png 1024w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/4-47-600x257.png 600w\" sizes=\"(max-width: 1127px) 100vw, 1127px\" \/><\/a><\/span><\/p>\n<h2><b>Bonus: Pridajte si vlastn\u00e9 menu<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Ak chcete ma\u0165 prepojenie BigQuery a Sheets v\u017edy po ruke, m\u00f4\u017eete si v h\u00e1rku vytvori\u0165 vlastn\u00e9 menu. <strong>Do AppScriptu sta\u010d\u00ed prida\u0165 kr\u00e1tky k\u00f3d<\/strong>, ktor\u00fd po na\u010d\u00edtan\u00ed dokumentu vytvor\u00ed nov\u00fa polo\u017eku \u201eBigQuery\u201c v hlavnej li\u0161te. V nej si potom m\u00f4\u017eete priamo vybra\u0165, \u010di chcete d\u00e1ta exportova\u0165 alebo importova\u0165. Bez nutnosti otv\u00e1ra\u0165 editor skriptov.<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><strong>Ako na to?<\/strong> V Apps Scripte vytvorte nov\u00fd s\u00fabor, vyma\u017ete predpripraven\u00fd k\u00f3d a vlo\u017ete t\u00fato funkciu:<\/span><\/p>\n<pre style=\"background-color: #f2f2f2; padding: 1em; border-radius: 8px; overflow-x: auto; font-family: monospace; margin: 1.5em 0;\"><code>\r\nfunction onOpen() {\r\n  const ui = SpreadsheetApp.getUi();\r\n  ui.createMenu('BigQuery')\r\n    .addItem('Exportova\u0165 do BigQuery', 'exportSheetToBigQuery')\r\n    .addItem('Importova\u0165 z BigQuery', 'importBigQueryToSheet')\r\n    .addToUi();\r\n}\r\n<\/code><\/pre>\n<p><span style=\"font-weight: 400;\"><strong>Ulo\u017ete skript a znovu na\u010d\u00edtajte v\u00e1\u0161 Google Sheet.<\/strong> V hlavnom menu by ste teraz mali vidie\u0165 nov\u00fa polo\u017eku <\/span><b>&#8222;BigQuery&#8220;<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<h3><b>Z\u00e1ver<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Prepojenie Google Sheets a BigQuery pon\u00faka efekt\u00edvny sp\u00f4sob, ako prepoji\u0165 flexibilitu tabuliek s v\u00fdkonom datab\u00e1zov\u00e9ho rie\u0161enia. V\u010faka tomu m\u00f4\u017eete analyzova\u0165 <strong>v\u00e4\u010d\u0161ie objemy d\u00e1t<\/strong>, testova\u0165 hypot\u00e9zy alebo vytv\u00e1ra\u0165 <strong>vlastn\u00e9 reportingov\u00e9 rie\u0161enia.<\/strong><\/span><\/p>\n<p><span style=\"font-weight: 400;\"><strong>Apps Script pritom umo\u017e\u0148uje cel\u00fd proces automatizova\u0165<\/strong> \u2013 \u010di u\u017e ide o denn\u00e9 exporty v\u00fdsledkov kampan\u00ed, prepojenie viacer\u00fdch zdrojov d\u00e1t alebo generovanie reportov pre klientov. V\u00fdsledkom je plynulej\u0161\u00ed tok d\u00e1t a menej manu\u00e1lnej pr\u00e1ce. <strong>A to chceme, nie? &#x1f914;&#x1f9e0;<\/strong><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>V\u0161etci sa dnes stret\u00e1vame s obrovsk\u00fdm mno\u017estvom d\u00e1t. Mnoh\u00ed pr\u00e1ve v Google Sheets, ktor\u00fd je skvel\u00fdm pomocn\u00edkom pri&#8230;<\/p>\n","protected":false},"author":78,"featured_media":21131,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[637],"tags":[804,673,1060],"_links":{"self":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts\/21122"}],"collection":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/users\/78"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/comments?post=21122"}],"version-history":[{"count":6,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts\/21122\/revisions"}],"predecessor-version":[{"id":21133,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts\/21122\/revisions\/21133"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/media\/21131"}],"wp:attachment":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/media?parent=21122"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/categories?post=21122"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/tags?post=21122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}