{"id":218,"date":"2018-05-23T17:49:21","date_gmt":"2018-05-23T15:49:21","guid":{"rendered":"http:\/\/pro.timphaus.de\/?p=218"},"modified":"2020-12-18T10:36:39","modified_gmt":"2020-12-18T09:36:39","slug":"218","status":"publish","type":"post","link":"https:\/\/dynamiacs.com\/?p=218","title":{"rendered":"Collect twitter tweets"},"content":{"rendered":"\n<p>To collect data from twitter you can use Microsoft Flow in\ncombination with excel.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"908\" height=\"300\" src=\"http:\/\/pro.timphaus.de\/wp-content\/uploads\/2019\/03\/twittertoexcel.png\" alt=\"\" class=\"wp-image-219\" srcset=\"https:\/\/dynamiacs.com\/wp-content\/uploads\/2019\/03\/twittertoexcel.png 908w, https:\/\/dynamiacs.com\/wp-content\/uploads\/2019\/03\/twittertoexcel-300x99.png 300w, https:\/\/dynamiacs.com\/wp-content\/uploads\/2019\/03\/twittertoexcel-768x254.png 768w\" sizes=\"auto, (max-width: 908px) 100vw, 908px\" \/><\/figure>\n\n\n\n<p>First you have to select the Microsoft Flow trigger for\n&#8220;Twitter &#8211; when a new tweet is posted&#8221; and to select the hashtags you\nwant to collect. in this example we collect all posted tweets for Dynamics 365.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"758\" height=\"131\" src=\"http:\/\/pro.timphaus.de\/wp-content\/uploads\/2019\/03\/twittertoexcel_01.jpg\" alt=\"\" class=\"wp-image-220\" srcset=\"https:\/\/dynamiacs.com\/wp-content\/uploads\/2019\/03\/twittertoexcel_01.jpg 758w, https:\/\/dynamiacs.com\/wp-content\/uploads\/2019\/03\/twittertoexcel_01-300x52.jpg 300w\" sizes=\"auto, (max-width: 758px) 100vw, 758px\" \/><\/figure>\n\n\n\n<p>The next step is done within the action &#8220;Excel &#8211;\ninsert a new row&#8221;. In this action we do the mapping from twitter to the\nexcel table.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"747\" height=\"540\" src=\"http:\/\/pro.timphaus.de\/wp-content\/uploads\/2019\/03\/twittertoexcel_02.png\" alt=\"\" class=\"wp-image-221\" srcset=\"https:\/\/dynamiacs.com\/wp-content\/uploads\/2019\/03\/twittertoexcel_02.png 747w, https:\/\/dynamiacs.com\/wp-content\/uploads\/2019\/03\/twittertoexcel_02-300x217.png 300w\" sizes=\"auto, (max-width: 747px) 100vw, 747px\" \/><\/figure>\n\n\n\n<p>and I have you want to something advanced you can\nconnect your Excel file with powerbi to visualize the data.<\/p>\n\n\n\n<p>The description will be done in another post<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"532\" src=\"http:\/\/pro.timphaus.de\/wp-content\/uploads\/2019\/03\/twittertoexcel_03-1024x532.jpg\" alt=\"\" class=\"wp-image-222\" srcset=\"https:\/\/dynamiacs.com\/wp-content\/uploads\/2019\/03\/twittertoexcel_03-1024x532.jpg 1024w, https:\/\/dynamiacs.com\/wp-content\/uploads\/2019\/03\/twittertoexcel_03-300x156.jpg 300w, https:\/\/dynamiacs.com\/wp-content\/uploads\/2019\/03\/twittertoexcel_03-768x399.jpg 768w, https:\/\/dynamiacs.com\/wp-content\/uploads\/2019\/03\/twittertoexcel_03.jpg 1546w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>To collect data from twitter you can use Microsoft Flow in combination with excel. First you have to select the Microsoft Flow trigger for &#8220;Twitter &#8211; when a new tweet is posted&#8221; and to select the hashtags you want to collect. in this example we collect all posted tweets for Dynamics 365. The next step&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[8],"tags":[6],"class_list":["post-218","post","type-post","status-publish","format-standard","hentry","category-blog","tag-twitter"],"taxonomy_info":{"category":[{"value":8,"label":"Blog"}],"post_tag":[{"value":6,"label":"Twitter"}]},"featured_image_src_large":false,"author_info":{"display_name":"Jan","author_link":"https:\/\/dynamiacs.com\/?author=2"},"comment_info":0,"category_info":[{"term_id":8,"name":"Blog","slug":"blog","term_group":0,"term_taxonomy_id":8,"taxonomy":"category","description":"","parent":0,"count":38,"filter":"raw","cat_ID":8,"category_count":38,"category_description":"","cat_name":"Blog","category_nicename":"blog","category_parent":0}],"tag_info":[{"term_id":6,"name":"Twitter","slug":"twitter","term_group":0,"term_taxonomy_id":6,"taxonomy":"post_tag","description":"","parent":0,"count":3,"filter":"raw"}],"_links":{"self":[{"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/posts\/218","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=218"}],"version-history":[{"count":2,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/posts\/218\/revisions"}],"predecessor-version":[{"id":231,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/posts\/218\/revisions\/231"}],"wp:attachment":[{"href":"https:\/\/dynamiacs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}