{"id":127,"date":"2018-07-21T13:21:54","date_gmt":"2018-07-21T13:21:54","guid":{"rendered":"https:\/\/truevis.com\/nodes\/2018\/07\/21\/bumblebee-search-value-get-row\/"},"modified":"2018-08-06T09:25:09","modified_gmt":"2018-08-06T09:25:09","slug":"bumblebee-search-value-get-row","status":"publish","type":"post","link":"https:\/\/truevis.com\/nodes\/bumblebee-search-value-get-row\/","title":{"rendered":"BumbleBee &#8211; Search Value Get Row"},"content":{"rendered":"<p><b>Search Value Get Row<\/b><br \/>This node will search the Excel Spreadsheet for a single string value and return an entire row of data that this value was found in. For example if key was found at A15 then entire row 15 will be returned.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Search Value Get RowThis node will search the Excel Spreadsheet for a single string value and return an entire row of data that this value was found in. For example if key was found at [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-127","post","type-post","status-publish","format-standard","hentry","category-dynamo"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>BumbleBee - Search Value Get Row<\/title>\n<meta name=\"description\" content=\"Search many Dynamo nodes from this site\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/truevis.com\/nodes\/bumblebee-search-value-get-row\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"BumbleBee - Search Value Get Row\" \/>\n<meta property=\"og:description\" content=\"Search many Dynamo nodes from this site\" \/>\n<meta property=\"og:url\" content=\"https:\/\/truevis.com\/nodes\/bumblebee-search-value-get-row\/\" \/>\n<meta property=\"og:site_name\" content=\"Dynamo Nodes, Searchable\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-21T13:21:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-08-06T09:25:09+00:00\" \/>\n<meta name=\"author\" content=\"Eric Boehlke\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@truevis\" \/>\n<meta name=\"twitter:site\" content=\"@truevis\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Eric Boehlke\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/truevis.com\\\/nodes\\\/bumblebee-search-value-get-row\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/truevis.com\\\/nodes\\\/bumblebee-search-value-get-row\\\/\"},\"author\":{\"name\":\"Eric Boehlke\",\"@id\":\"https:\\\/\\\/truevis.com\\\/nodes\\\/#\\\/schema\\\/person\\\/702a7d9d83f94d9154f198d793f41164\"},\"headline\":\"BumbleBee &#8211; Search Value Get Row\",\"datePublished\":\"2018-07-21T13:21:54+00:00\",\"dateModified\":\"2018-08-06T09:25:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/truevis.com\\\/nodes\\\/bumblebee-search-value-get-row\\\/\"},\"wordCount\":49,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/truevis.com\\\/nodes\\\/#organization\"},\"articleSection\":[\"Dynamo\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/truevis.com\\\/nodes\\\/bumblebee-search-value-get-row\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/truevis.com\\\/nodes\\\/bumblebee-search-value-get-row\\\/\",\"url\":\"https:\\\/\\\/truevis.com\\\/nodes\\\/bumblebee-search-value-get-row\\\/\",\"name\":\"BumbleBee - Search Value Get Row\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/truevis.com\\\/nodes\\\/#website\"},\"datePublished\":\"2018-07-21T13:21:54+00:00\",\"dateModified\":\"2018-08-06T09:25:09+00:00\",\"description\":\"Search many Dynamo nodes from this site\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/truevis.com\\\/nodes\\\/bumblebee-search-value-get-row\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/truevis.com\\\/nodes\\\/bumblebee-search-value-get-row\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/truevis.com\\\/nodes\\\/bumblebee-search-value-get-row\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/truevis.com\\\/nodes\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"BumbleBee &#8211; Search Value Get Row\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/truevis.com\\\/nodes\\\/#website\",\"url\":\"https:\\\/\\\/truevis.com\\\/nodes\\\/\",\"name\":\"Dynamo Nodes, Searchable\",\"description\":\"Search for Dynamo BIM nodes and the packages from which they came\",\"publisher\":{\"@id\":\"https:\\\/\\\/truevis.com\\\/nodes\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/truevis.com\\\/nodes\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/truevis.com\\\/nodes\\\/#organization\",\"name\":\"truevis.com\",\"url\":\"https:\\\/\\\/truevis.com\\\/nodes\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/truevis.com\\\/nodes\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/truevis.com\\\/nodes\\\/wp-content\\\/uploads\\\/sites\\\/12\\\/2018\\\/07\\\/truevislogo2.png\",\"contentUrl\":\"https:\\\/\\\/truevis.com\\\/nodes\\\/wp-content\\\/uploads\\\/sites\\\/12\\\/2018\\\/07\\\/truevislogo2.png\",\"width\":457,\"height\":215,\"caption\":\"truevis.com\"},\"image\":{\"@id\":\"https:\\\/\\\/truevis.com\\\/nodes\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/truevis\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/truevis\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/truevis.com\\\/nodes\\\/#\\\/schema\\\/person\\\/702a7d9d83f94d9154f198d793f41164\",\"name\":\"Eric Boehlke\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/65ddefc92a074871188979e1c23a61569c640bfd9ca5fa2062c006c3fa3f4326?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/65ddefc92a074871188979e1c23a61569c640bfd9ca5fa2062c006c3fa3f4326?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/65ddefc92a074871188979e1c23a61569c640bfd9ca5fa2062c006c3fa3f4326?s=96&d=mm&r=g\",\"caption\":\"Eric Boehlke\"},\"sameAs\":[\"https:\\\/\\\/truevis.com\"],\"url\":\"https:\\\/\\\/truevis.com\\\/nodes\\\/author\\\/designtruevis-com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"BumbleBee - Search Value Get Row","description":"Search many Dynamo nodes from this site","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/truevis.com\/nodes\/bumblebee-search-value-get-row\/","og_locale":"en_US","og_type":"article","og_title":"BumbleBee - Search Value Get Row","og_description":"Search many Dynamo nodes from this site","og_url":"https:\/\/truevis.com\/nodes\/bumblebee-search-value-get-row\/","og_site_name":"Dynamo Nodes, Searchable","article_published_time":"2018-07-21T13:21:54+00:00","article_modified_time":"2018-08-06T09:25:09+00:00","author":"Eric Boehlke","twitter_card":"summary_large_image","twitter_creator":"@truevis","twitter_site":"@truevis","twitter_misc":{"Written by":"Eric Boehlke"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/truevis.com\/nodes\/bumblebee-search-value-get-row\/#article","isPartOf":{"@id":"https:\/\/truevis.com\/nodes\/bumblebee-search-value-get-row\/"},"author":{"name":"Eric Boehlke","@id":"https:\/\/truevis.com\/nodes\/#\/schema\/person\/702a7d9d83f94d9154f198d793f41164"},"headline":"BumbleBee &#8211; Search Value Get Row","datePublished":"2018-07-21T13:21:54+00:00","dateModified":"2018-08-06T09:25:09+00:00","mainEntityOfPage":{"@id":"https:\/\/truevis.com\/nodes\/bumblebee-search-value-get-row\/"},"wordCount":49,"commentCount":0,"publisher":{"@id":"https:\/\/truevis.com\/nodes\/#organization"},"articleSection":["Dynamo"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/truevis.com\/nodes\/bumblebee-search-value-get-row\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/truevis.com\/nodes\/bumblebee-search-value-get-row\/","url":"https:\/\/truevis.com\/nodes\/bumblebee-search-value-get-row\/","name":"BumbleBee - Search Value Get Row","isPartOf":{"@id":"https:\/\/truevis.com\/nodes\/#website"},"datePublished":"2018-07-21T13:21:54+00:00","dateModified":"2018-08-06T09:25:09+00:00","description":"Search many Dynamo nodes from this site","breadcrumb":{"@id":"https:\/\/truevis.com\/nodes\/bumblebee-search-value-get-row\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/truevis.com\/nodes\/bumblebee-search-value-get-row\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/truevis.com\/nodes\/bumblebee-search-value-get-row\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/truevis.com\/nodes\/"},{"@type":"ListItem","position":2,"name":"BumbleBee &#8211; Search Value Get Row"}]},{"@type":"WebSite","@id":"https:\/\/truevis.com\/nodes\/#website","url":"https:\/\/truevis.com\/nodes\/","name":"Dynamo Nodes, Searchable","description":"Search for Dynamo BIM nodes and the packages from which they came","publisher":{"@id":"https:\/\/truevis.com\/nodes\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/truevis.com\/nodes\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/truevis.com\/nodes\/#organization","name":"truevis.com","url":"https:\/\/truevis.com\/nodes\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/truevis.com\/nodes\/#\/schema\/logo\/image\/","url":"https:\/\/truevis.com\/nodes\/wp-content\/uploads\/sites\/12\/2018\/07\/truevislogo2.png","contentUrl":"https:\/\/truevis.com\/nodes\/wp-content\/uploads\/sites\/12\/2018\/07\/truevislogo2.png","width":457,"height":215,"caption":"truevis.com"},"image":{"@id":"https:\/\/truevis.com\/nodes\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/truevis","https:\/\/www.linkedin.com\/in\/truevis\/"]},{"@type":"Person","@id":"https:\/\/truevis.com\/nodes\/#\/schema\/person\/702a7d9d83f94d9154f198d793f41164","name":"Eric Boehlke","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/65ddefc92a074871188979e1c23a61569c640bfd9ca5fa2062c006c3fa3f4326?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/65ddefc92a074871188979e1c23a61569c640bfd9ca5fa2062c006c3fa3f4326?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/65ddefc92a074871188979e1c23a61569c640bfd9ca5fa2062c006c3fa3f4326?s=96&d=mm&r=g","caption":"Eric Boehlke"},"sameAs":["https:\/\/truevis.com"],"url":"https:\/\/truevis.com\/nodes\/author\/designtruevis-com\/"}]}},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/truevis.com\/nodes\/wp-json\/wp\/v2\/posts\/127","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/truevis.com\/nodes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/truevis.com\/nodes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/truevis.com\/nodes\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/truevis.com\/nodes\/wp-json\/wp\/v2\/comments?post=127"}],"version-history":[{"count":0,"href":"https:\/\/truevis.com\/nodes\/wp-json\/wp\/v2\/posts\/127\/revisions"}],"wp:attachment":[{"href":"https:\/\/truevis.com\/nodes\/wp-json\/wp\/v2\/media?parent=127"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/truevis.com\/nodes\/wp-json\/wp\/v2\/categories?post=127"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/truevis.com\/nodes\/wp-json\/wp\/v2\/tags?post=127"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}