{"id":18936,"date":"2023-12-07T05:34:18","date_gmt":"2023-12-07T05:34:18","guid":{"rendered":"https:\/\/viewmyprojects.com\/winwirewp\/?p=18936"},"modified":"2023-12-07T05:38:46","modified_gmt":"2023-12-07T05:38:46","slug":"power-automate-what-is-it-how-it-works-and-its-applications","status":"publish","type":"post","link":"https:\/\/viewmyprojects.com\/winwirewp\/blog\/power-automate-what-is-it-how-it-works-and-its-applications\/","title":{"rendered":"Power Automate: What Is It, How It Works and Its Applications"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\"><strong>What is Power Automate? <\/strong><\/h3>\n\n\n\n<p>Power&nbsp;Automate&nbsp;is&nbsp;a&nbsp;service&nbsp;that&nbsp;can&nbsp;be&nbsp;used&nbsp;to&nbsp;automate&nbsp;tasks&nbsp;and&nbsp;thus&nbsp;increase&nbsp;the&nbsp;efficiency&nbsp;of&nbsp;<br>any&nbsp;organization.&nbsp;You&nbsp;can&nbsp;create&nbsp;cloud&nbsp;flows,&nbsp;desktop&nbsp;flows,&nbsp;or&nbsp;business&nbsp;process flows.<\/p>\n\n\n\n<p>Microsoft&nbsp;Power&nbsp;Automate&nbsp;(formerly&nbsp;Microsoft&nbsp;Flow)&nbsp;is&nbsp;cloud-based&nbsp;software&nbsp;that&nbsp;allows&nbsp;employees&nbsp;to create&nbsp;and&nbsp;<br>run&nbsp;tasks&nbsp;and&nbsp;tasks&nbsp;across&nbsp;multiple&nbsp;applications&nbsp;and&nbsp;services&nbsp;without&nbsp;manual effort.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Extensive data cleanup for CSV using Power Automate:<\/strong><\/h3>\n\n\n\n<p><strong>Requirement: <\/strong><\/p>\n\n\n\n<p>An email with a CSVCSV attachment is received in the Inbox of the shared mailbox, whose attachment needs data clean up, and after the cleanup, the file has to be uploaded to SharePoint automatically.<\/p>\n\n\n\n<p><strong>Details for the dynamic CSV attachment file and required functionality:<\/strong><\/p>\n\n\n\n<ul class=\"blog-detail-list wp-block-list\">\n<li>Data is extensive, with 60K+ records.<\/li>\n\n\n\n<li>There are more than 15 columns in the CSV file.<\/li>\n\n\n\n<li>CSV file needs the following cleanup:<ul><li>Removal of line breaks for field values in every column.<\/li><\/ul><ul><li>Removal of rows with empty Revision numbers where the Revision number is the column.<\/li><\/ul>\n<ul class=\"wp-block-list\">\n<li>Removal of duplicate records (if the entire row is the the same as the existing one).<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Need to drop the CSV file to SharePoint.<\/li>\n\n\n\n<li>While dropping the file to SharePoint, we the . Ifit otherwise need to check if the file with the same name already exists in the location and if exists, we need to drag the file to another location appending date to the file name and then drop the new file to the SharePoint location.<\/li>\n<\/ul>\n\n\n\n<p><strong>Observations as a Developer:<\/strong><\/p>\n\n\n\n<ul class=\"blog-detail-list wp-block-list\">\n<li>Power automates free license when applied to each loop allowing only 5K records at a time to process, which is why huge data processes will take a lot of time for whole data processing.<\/li>\n\n\n\n<li>CSV files can be in UNIX and window formats.<\/li>\n\n\n\n<li>Windows format uses CRLF(\\r\\n) for row differentiation when a file read as a string.<\/li>\n\n\n\n<li>When the file is read as a string, LINUX uses LF(\\n) for row differentiation, which is the identical for a line break or following line(\\n) in between the column values if it exists.<\/li>\n\n\n\n<li>In power automate for large CSV files. When file content is read directly from an email attachment, it takes more time than temporarily storing it in OneDrive and deleting it once the process is completed.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Power Automate Solution Implementation:<\/strong><\/h2>\n\n\n\n<p>Power Automate Trigger: Whenever an email is sent from a specific account to the account used in power automate connections by filtering the email subject and a CSVCSV file as an attachment, the flow runs.<\/p>\n\n\n\n<p><strong>Step 1<\/strong><\/p>\n\n\n\n<p>Storing the attachment temporarily in OneDrive by creating a new file and adding file content by taking the attachment content<\/p>\n\n\n\n<p>NOTE: The time taken directly to read large significant CSV file content from an email attachment is greater than the time to save the same content in OneDrive and read from there.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"788\" height=\"283\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image.png\" alt=\"PowerApps\" class=\"wp-image-18937\" style=\"width:670px;height:auto\" srcset=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image.png 788w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-300x108.png 300w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-768x276.png 768w\" sizes=\"auto, (max-width: 788px) 100vw, 788px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 2:<\/strong><br>Get file content from the OneDrive file created in the previous step. The file content can be base64 or string. If base64, We need to convert the base64 to string.<\/p>\n\n\n\n<p><strong>Step 3:<\/strong><br>Converting base64 to a string and storing it as file content using a variable.<\/p>\n\n\n\n<p><em>Compose formula:<\/em><\/p>\n\n\n\n<p>base64ToString(body(&#8216;Get_file_content&#8217;))<\/p>\n\n\n\n<p><em>if compose success:<\/em><\/p>\n\n\n\n<p>replace(outputs(&#8216;Compose&#8217;),&nbsp;uriComponentToString(&#8216;%EF%BB%BF&#8217;),&nbsp;&#8221;)<\/p>\n\n\n\n<p>replacing the compose output for BOM character <em><\/em><\/p>\n\n\n\n<p><em>compose fails:<\/em><\/p>\n\n\n\n<p>@{body(&#8216;Get_file_content&#8217;)}<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"790\" height=\"337\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-1.png\" alt=\"Microsoft Power Platform\" class=\"wp-image-18938\" style=\"width:715px;height:auto\" srcset=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-1.png 790w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-1-300x128.png 300w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-1-768x328.png 768w\" sizes=\"auto, (max-width: 790px) 100vw, 790px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 4:<\/strong><br>In the flow, there is no possibility to use Regular expressions to remove line breaks inside every field value in the CSV file<br>To achieve the above functionality, we use power automate connector Excel run script, pass the file content, remove the line breaks from the field values, and return the row result as JSON.<\/p>\n\n\n\n<p>Create an empty Excel book in OneDrive and link an office script to the Excel workbook created. This way, we can inject JavaScript using office scripts in power to automate and achieve the desired output from the office script.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"797\" height=\"352\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-2.png\" alt=\"Microsoft Power Platform\" class=\"wp-image-18939\" style=\"width:748px;height:auto\" srcset=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-2.png 797w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-2-300x132.png 300w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-2-768x339.png 768w\" sizes=\"auto, (max-width: 797px) 100vw, 797px\" \/><\/figure><\/div>\n\n\n<p>The following is the office script used to replace line breaks inside the field values and return JSON.<\/p>\n\n\n\n<p><strong>Step 5:<\/strong><br>Parse the JSON output from the above step.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"786\" height=\"460\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-3.png\" alt=\"Microsoft Power Platform\" class=\"wp-image-18940\" style=\"width:606px;height:auto\" srcset=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-3.png 786w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-3-300x176.png 300w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-3-768x449.png 768w\" sizes=\"auto, (max-width: 786px) 100vw, 786px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 6:<\/strong><br>Filter the JSON for empty Revision Number field values and get the results has have the data for the Revision Number field value.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"791\" height=\"312\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-4.png\" alt=\"Microsoft Flows\" class=\"wp-image-18941\" style=\"width:757px;height:auto\" srcset=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-4.png 791w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-4-300x118.png 300w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-4-768x303.png 768w\" sizes=\"auto, (max-width: 791px) 100vw, 791px\" \/><\/figure><\/div>\n\n\n<p><em>Formula used:<\/em><\/p>\n\n\n\n<p>@and(equals(empty(item()?[&#8216;Revision Number&#8217;]), false), not(equals(length(item()?[&#8216;Revision Number&#8217;]), 0)))<\/p>\n\n\n\n<p><strong>Step 7:<\/strong><br>Duplicates can be removed from the result using the Union function in power automate.<br>To get the same order for the columns, we can use the select function and select the value key-value pair from the filtered.<\/p>\n\n\n\n<p>The formula used for the input selection:<\/p>\n\n\n\n<p>union(body(&#8216;Filter_data_that_does_not_have_revision_number&#8217;), body(&#8216;Filter_data_that_does_not_have_revision_number&#8217;))<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"622\" height=\"532\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-5.png\" alt=\"Microsoft Flows\" class=\"wp-image-18942\" style=\"width:530px;height:auto\" srcset=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-5.png 622w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-5-300x257.png 300w\" sizes=\"auto, (max-width: 622px) 100vw, 622px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 8:<\/strong><br>Covert data to CSV table<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"493\" height=\"147\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-6.png\" alt=\"Workflows\" class=\"wp-image-18943\" srcset=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-6.png 493w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-6-300x89.png 300w\" sizes=\"auto, (max-width: 493px) 100vw, 493px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 9:<\/strong><br>Check if the file already exists in the SharePoint output location.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"766\" height=\"520\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-7.png\" alt=\"Workflows\" class=\"wp-image-18944\" style=\"width:594px;height:auto\" srcset=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-7.png 766w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-7-300x204.png 300w\" sizes=\"auto, (max-width: 766px) 100vw, 766px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 10:<\/strong><br>If the file already exists, update the file name by appending the date to the existing name.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"713\" height=\"507\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-8.png\" alt=\"Introduction Power Automate \" class=\"wp-image-18945\" style=\"width:529px;height:auto\" srcset=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-8.png 713w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-8-300x213.png 300w\" sizes=\"auto, (max-width: 713px) 100vw, 713px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 11:<\/strong><br>Get the file identifier from Get file properties and move the file to the desired folder using the file identifier.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"637\" height=\"602\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-9.png\" alt=\"Power Automate\" class=\"wp-image-18946\" style=\"width:455px;height:auto\" srcset=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-9.png 637w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-9-300x284.png 300w\" sizes=\"auto, (max-width: 637px) 100vw, 637px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 12:<\/strong><br>Create a file in SharePoint using the output from step 8.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"777\" height=\"312\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-10.png\" alt=\"Power Automate\" class=\"wp-image-18947\" srcset=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-10.png 777w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-10-300x120.png 300w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/image-10-768x308.png 768w\" sizes=\"auto, (max-width: 777px) 100vw, 777px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 10:<\/strong><br>Deleting the temporary CSV file created in OneDrive in step 1.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Conclusion: <\/strong><\/p>\n\n\n\n<p>We can automate complex manual work using power automation and reduce manual effort.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Reference links:<br>https:\/\/learn.microsoft.com\/en-us\/power-automate\/getting-started<br>https:\/\/learn.microsoft.com\/en-us\/office\/dev\/scripts\/overview\/excel<\/p>\n","protected":false},"excerpt":{"rendered":"<p>What is Power Automate? Power&nbsp;Automate&nbsp;is&nbsp;a&nbsp;service&nbsp;that&nbsp;can&nbsp;be&nbsp;used&nbsp;to&nbsp;automate&nbsp;tasks&nbsp;and&nbsp;thus&nbsp;increase&nbsp;the&nbsp;efficiency&nbsp;of&nbsp;any&nbsp;organization.&nbsp;You&nbsp;can&nbsp;create&nbsp;cloud&nbsp;flows,&nbsp;desktop&nbsp;flows,&nbsp;or&nbsp;business&nbsp;process flows. Microsoft&nbsp;Power&nbsp;Automate&nbsp;(formerly&nbsp;Microsoft&nbsp;Flow)&nbsp;is&nbsp;cloud-based&nbsp;software&nbsp;that&nbsp;allows&nbsp;employees&nbsp;to create&nbsp;and&nbsp;run&nbsp;tasks&nbsp;and&nbsp;tasks&nbsp;across&nbsp;multiple&nbsp;applications&nbsp;and&nbsp;services&nbsp;without&nbsp;manual effort. Extensive data cleanup for CSV using Power Automate: Requirement: An email with a CSVCSV attachment is received in the Inbox of the shared mailbox, whose attachment needs data clean up, and after the cleanup, the file has to be uploaded to SharePoint automatically. Details for the&hellip; <a class=\"more-link\" href=\"https:\/\/viewmyprojects.com\/winwirewp\/blog\/power-automate-what-is-it-how-it-works-and-its-applications\/\">Continue reading <span class=\"screen-reader-text\">Power Automate: What Is It, How It Works and Its Applications<\/span><\/a><\/p>\n","protected":false},"author":133,"featured_media":18955,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","_uag_custom_page_level_css":"","footnotes":""},"categories":[59,61],"tags":[],"class_list":["post-18936","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blogs","category-app-modernization-blogs","entry"],"acf":[],"featured_image_src":"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/Blog_Dec2023.png","author_info":{"display_name":"Jyothi","author_link":"https:\/\/viewmyprojects.com\/winwirewp\/author\/jyothi\/"},"views":2989,"uagb_featured_image_src":{"full":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/Blog_Dec2023.png",800,440,false],"thumbnail":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/Blog_Dec2023-150x150.png",150,150,true],"medium":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/Blog_Dec2023-300x165.png",300,165,true],"medium_large":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/Blog_Dec2023-768x422.png",750,412,true],"large":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/Blog_Dec2023.png",750,413,false],"1536x1536":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/Blog_Dec2023.png",800,440,false],"2048x2048":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/Blog_Dec2023.png",800,440,false],"post-thumbnail":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/12\/Blog_Dec2023.png",800,440,false]},"uagb_author_info":{"display_name":"Jyothi","author_link":"https:\/\/viewmyprojects.com\/winwirewp\/author\/jyothi\/"},"uagb_comment_info":0,"uagb_excerpt":"What is Power Automate? Power&nbsp;Automate&nbsp;is&nbsp;a&nbsp;service&nbsp;that&nbsp;can&nbsp;be&nbsp;used&nbsp;to&nbsp;automate&nbsp;tasks&nbsp;and&nbsp;thus&nbsp;increase&nbsp;the&nbsp;efficiency&nbsp;of&nbsp;any&nbsp;organization.&nbsp;You&nbsp;can&nbsp;create&nbsp;cloud&nbsp;flows,&nbsp;desktop&nbsp;flows,&nbsp;or&nbsp;business&nbsp;process flows. Microsoft&nbsp;Power&nbsp;Automate&nbsp;(formerly&nbsp;Microsoft&nbsp;Flow)&nbsp;is&nbsp;cloud-based&nbsp;software&nbsp;that&nbsp;allows&nbsp;employees&nbsp;to create&nbsp;and&nbsp;run&nbsp;tasks&nbsp;and&nbsp;tasks&nbsp;across&nbsp;multiple&nbsp;applications&nbsp;and&nbsp;services&nbsp;without&nbsp;manual effort. Extensive data cleanup for CSV using Power Automate: Requirement: An email with a CSVCSV attachment is received in the Inbox of the shared mailbox, whose attachment needs data clean up, and after the cleanup, the file has to be uploaded to SharePoint automatically. Details for the&hellip;&hellip;","_links":{"self":[{"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/posts\/18936","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/users\/133"}],"replies":[{"embeddable":true,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/comments?post=18936"}],"version-history":[{"count":9,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/posts\/18936\/revisions"}],"predecessor-version":[{"id":18961,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/posts\/18936\/revisions\/18961"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/media\/18955"}],"wp:attachment":[{"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/media?parent=18936"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/categories?post=18936"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/tags?post=18936"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}