{"id":110797,"date":"2017-02-17T03:55:56","date_gmt":"2017-02-17T11:55:56","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/five-services-json-http\/"},"modified":"2017-02-17T03:55:56","modified_gmt":"2017-02-17T11:55:56","slug":"five-services-json-http","status":"publish","type":"power-automate","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/five-services-json-http\/","title":{"rendered":"Five new services and improved advanced capabilities for JSON and HTTP"},"content":{"rendered":"<h2>Five new services added<\/h2>\n<p>This past week we added five new services: Azure Data Lake, Bitbucket, Eventbrite, Infusionsoft and Pipedrive. <a href=\"https:\/\/flow.microsoft.com\/services\/shared_azuredatalake\/\">Azure Data Lake<\/a> allows you to read and add data to an Azure Data Lake account.<\/p>\n<p><a href=\"https:\/\/flow.microsoft.com\/services\/shared_bitbucket\">Bitbucket<\/a> is a web based hosting service for projects that use GIT revision control.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/http-auth-bitbucket.png\" style=\"width: 400px; height: 198px;\"\/><\/p>\n<p>With Bitbucket in Microsoft Flow you can now automate many different aspects of your project&#8217;s life cycle. From simple tasks like syncing issues into another system, to even automatically approving, declining or merging pull requests.\u00a0<\/p>\n<p><a href=\"https:\/\/flow.microsoft.com\/services\/shared_eventbrite\/\">Eventbrite<\/a> is a self-service ticketing platform used to create and discover local events. Eventbrite has triggers on when events or created or when someone orders a ticket for an event. This means you can copy events to other systems or keep a separate log of all the event attendees. <a href=\"https:\/\/flow.microsoft.com\/services\/shared_infusionsoft\/\">Infusionsoft <\/a>is sales and marketing automation software built exclusively for small business success.<\/p>\n<p>Finally,\u00a0<a href=\"https:\/\/flow.microsoft.com\/services\/shared_pipedrive\/\">Pipedrive<\/a> is a CRM &amp; pipeline management tool that helps you focus on actions that matter. There are actions for adding deals or updating the stage of a deal.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/http-auth-pipedrive.png\" style=\"width: 300px; height: 324px;\"\/><\/p>\n<h2>Define HTTP Authentication<\/h2>\n<p>Although we now connect natively to 95+ different services, you may also have HTTP endpoints that you want to work with that aren&#8217;t natively supported with Microsoft Flow. Microsoft Flow has long supported interacting with custom, unauthenticated HTTP endpoints, and today it&#8217;s now possible to set up calls to authenticated HTTP endpoints as well.\u00a0To connect to a custom HTTP endpoint, first select the\u00a0<strong style=\"font-size: 13.008px;\">HTTP<\/strong>\u00a0service when you add an action:<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/http-auth-actions.png\" style=\"height: 228px; width: 251px;\"\/><\/p>\n<p>There are three possible actions:<\/p>\n<ul>\n<li><strong>HTTP <\/strong>&#8211; a basic call to any endpoint<\/li>\n<li><strong>HTTP + Swagger<\/strong> &#8211; if you have a swagger endpoint for your API, you can include that here and it will generate an experience where you can easily fill out the inputs for the action<\/li>\n<li><strong>HTTP Webhook<\/strong> &#8211; call out to another endpoint and wait for a response to come back (aka. a callback)<\/li>\n<\/ul>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/http-auth-options.png\" style=\"width: 253px; height: 214px;\"\/><\/p>\n<p>After you have selected the action, select <strong>Show advanced options<\/strong>\u00a0and then select <strong>Authentication.<\/strong>\u00a0The default is <strong>None<\/strong>, but you can choose one of four other types of authentication. After you select the endpoint&#8217;s authentication type you will be able to configure any specific data you need to send.\u00a0<\/p>\n<h2>Parse JSON messages<\/h2>\n<p>When working with the Request trigger or the HTTP actions, you may need to parse out JSON data. This week we added a new data operation called\u00a0<strong>Parse JSON<\/strong>. This action takes:<\/p>\n<ol>\n<li>The content you want to parse<\/li>\n<li>A JSON schema to parse the content against<\/li>\n<\/ol>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\https://www.microsoft.com/json-http-parse-action.png\" style=\"width: 250px; height: 216px;\"\/><\/p>\n<p>When the flow runs, it will evaluate the content against the schema. This means you can use the different fields you defined in the schema throughout the rest of your workflow as dynamic content.<\/p>\n<p>To make it easier to generate a JSON schema, we have also added a\u00a0<strong>Use sample payload<\/strong>\u00a0button. When you select this button, you can paste in your JSON content and it will attempt to generate a JSON schema that matches that payload. We have also added this new button directly on the HTTP Request card.<\/p>\n<h2>Better filtering for flow runs<\/h2>\n<p>Finally, we have added additional options for filtering the runs of your flow. Previously, you could only see succeeded or failed runs when you selected a flow and looked at its history.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\https://www.microsoft.com/json-http-runs.png\" style=\"width: 307px; height: 264px;\"\/><\/p>\n<p>Now, you can also filter to see just the instances that are currently running, or those runs that are cancelled. It is now possible to filter specifically to see failed checks (meaning the trigger did not fire because of an error), or, to see failed runs (meaning one or more of the actions did not execute successfully).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We five new services in the last week: <a href=\"https:\/\/flow.microsoft.com\/services\/shared_azuredatalake\/\">Azure Data Lake<\/a>, <a href=\"https:\/\/flow.microsoft.com\/services\/shared_bitbucket\">Bitbucket<\/a>, <a href=\"https:\/\/flow.microsoft.com\/services\/shared_eventbrite\/\">Eventbrite<\/a>, <a href=\"https:\/\/flow.microsoft.com\/services\/shared_infusionsoft\/\">Infusionsoft<\/a> and <a href=\"https:\/\/flow.microsoft.com\/services\/shared_pipedrive\/\">Pipedrive<\/a>. In the flow designer it&#8217;s now possible to use authentication with custom HTTP endpoints, and to parse JSON objects returned from APIs. Finally, we added more options for filtering flow runs.<\/p>\n","protected":false},"author":347,"featured_media":0,"comment_status":"open","ping_status":"open","template":"","power-automate-category":[2752],"power-automate-tag":[],"coauthors":[2913],"class_list":["post-110797","power-automate","type-power-automate","status-publish","hentry","power-automate-category-product-updates"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Five new services and improved advanced capabilities for JSON and HTTP - Microsoft Power Platform Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/five-services-json-http\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Five new services and improved advanced capabilities for JSON and HTTP - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"We five new services in the last week: Azure Data Lake, Bitbucket, Eventbrite, Infusionsoft and Pipedrive. In the flow designer it&#039;s now possible to use authentication with custom HTTP endpoints, and to parse JSON objects returned from APIs. Finally, we added more options for filtering flow runs.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/five-services-json-http\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/http-auth-bitbucket.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 min read\" \/>\n\t<meta name=\"twitter:label2\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data2\" content=\"Stephen Siciliano\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/five-services-json-http\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/five-services-json-http\/\",\"name\":\"Five new services and improved advanced capabilities for JSON and HTTP - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/five-services-json-http\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/five-services-json-http\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/http-auth-bitbucket.png\",\"datePublished\":\"2017-02-17T11:55:56+00:00\",\"dateModified\":\"2017-02-17T11:55:56+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/five-services-json-http\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/five-services-json-http\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/five-services-json-http\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/http-auth-bitbucket.webp\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/http-auth-bitbucket.webp\",\"width\":589,\"height\":292,\"caption\":\"graphical user interface, application\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/five-services-json-http\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power Automate\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Five new services and improved advanced capabilities for JSON and HTTP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"width\":194,\"height\":145,\"caption\":\"Microsoft Power Platform Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Five new services and improved advanced capabilities for JSON and HTTP - Microsoft Power Platform Blog","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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/five-services-json-http\/","og_locale":"en_US","og_type":"article","og_title":"Five new services and improved advanced capabilities for JSON and HTTP - Microsoft Power Platform Blog","og_description":"We five new services in the last week: Azure Data Lake, Bitbucket, Eventbrite, Infusionsoft and Pipedrive. In the flow designer it's now possible to use authentication with custom HTTP endpoints, and to parse JSON objects returned from APIs. Finally, we added more options for filtering flow runs.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/five-services-json-http\/","og_site_name":"Microsoft Power Platform Blog","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/http-auth-bitbucket.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 min read","Written by":"Stephen Siciliano"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/five-services-json-http\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/five-services-json-http\/","name":"Five new services and improved advanced capabilities for JSON and HTTP - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/five-services-json-http\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/five-services-json-http\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/http-auth-bitbucket.png","datePublished":"2017-02-17T11:55:56+00:00","dateModified":"2017-02-17T11:55:56+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/five-services-json-http\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/five-services-json-http\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/five-services-json-http\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/http-auth-bitbucket.webp","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/http-auth-bitbucket.webp","width":589,"height":292,"caption":"graphical user interface, application"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/five-services-json-http\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Power Automate","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/"},{"@type":"ListItem","position":3,"name":"Five new services and improved advanced capabilities for JSON and HTTP"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","width":194,"height":145,"caption":"Microsoft Power Platform Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate\/110797"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/power-automate"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/347"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=110797"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate\/110797\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=110797"}],"wp:term":[{"taxonomy":"power-automate-category","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate-category?post=110797"},{"taxonomy":"power-automate-tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate-tag?post=110797"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=110797"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}