{"id":1642,"date":"2021-12-05T10:25:37","date_gmt":"2021-12-05T10:25:37","guid":{"rendered":"https:\/\/365stack.in\/?p=1642"},"modified":"2021-12-05T10:28:42","modified_gmt":"2021-12-05T10:28:42","slug":"how-to-read-csv-file-using-power-automate","status":"publish","type":"post","link":"https:\/\/365stack.in\/index.php\/2021\/12\/05\/how-to-read-csv-file-using-power-automate\/","title":{"rendered":"How to read CSV file using Power Automate"},"content":{"rendered":"\n<p>We will see how to read CSV files using Power Automate and already a post is published to <a href=\"https:\/\/365stack.in\/index.php\/2021\/12\/03\/how-to-create-csv-file-in-power-automate\/\" target=\"_blank\" rel=\"noreferrer noopener\">create a CSV file<\/a> using power automate. This is one of the mandatory use cases in the Office 365 environment, either we will get the data from Email or from an external application or to read the data from a specified location.<\/p>\n\n\n\n<p>In this scenario, we will get the CSV file from one drive and In the &#8220;ComposeNewline&#8221; action add a new line<\/p>\n\n\n\n<div class=\"wp-block-jetpack-slideshow aligncenter\" data-effect=\"slide\"><div class=\"wp-block-jetpack-slideshow_container swiper-container\"><ul class=\"wp-block-jetpack-slideshow_swiper-wrapper swiper-wrapper\"><li class=\"wp-block-jetpack-slideshow_slide swiper-slide\"><figure><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"432\" alt=\"\" class=\"wp-block-jetpack-slideshow_image wp-image-1853\" data-id=\"1853\" src=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-240.png?resize=640%2C432&#038;ssl=1\" srcset=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-240.png?w=985&amp;ssl=1 985w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-240.png?w=300&amp;ssl=1 300w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-240.png?w=768&amp;ssl=1 768w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><figcaption class=\"wp-block-jetpack-slideshow_caption gallery-caption\">Get Data from One Drive<\/figcaption><\/figure><\/li><li class=\"wp-block-jetpack-slideshow_slide swiper-slide\"><figure><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"416\" alt=\"\" class=\"wp-block-jetpack-slideshow_image wp-image-1856\" data-id=\"1856\" src=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-241.png?resize=640%2C416&#038;ssl=1\" srcset=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-241.png?w=1011&amp;ssl=1 1011w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-241.png?w=300&amp;ssl=1 300w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-241.png?w=768&amp;ssl=1 768w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-241.png?w=368&amp;ssl=1 368w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><figcaption class=\"wp-block-jetpack-slideshow_caption gallery-caption\">Add new line in Compose<\/figcaption><\/figure><\/li><\/ul><a class=\"wp-block-jetpack-slideshow_button-prev swiper-button-prev swiper-button-white\" role=\"button\"><\/a><a class=\"wp-block-jetpack-slideshow_button-next swiper-button-next swiper-button-white\" role=\"button\"><\/a><a aria-label=\"Pause Slideshow\" class=\"wp-block-jetpack-slideshow_button-pause\" role=\"button\"><\/a><div class=\"wp-block-jetpack-slideshow_pagination swiper-pagination swiper-pagination-white\"><\/div><\/div><\/div>\n\n\n\n<p>In Capture CSV action, Split the CSV data and push it into an array for extraction.<\/p>\n\n\n\n<p><strong>Split Action<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>split(outputs('Get_file_content')?&#91;'body'], outputs('ComposeNewLine'))<\/code><\/pre>\n\n\n\n<p>We have to get the dynamic header values from CSV using the &#8220;Compose&#8221; action to map them in the &#8220;Select&#8221; action. <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><strong>\/\/Action Name - ComposeGetFieldNames<\/strong>\nsplit(first(outputs('Capture_CSV')),',')\n\n<strong>\/\/Input - &#91;'Header1,Header2','Data1,Data2']\n\/\/Output - &#91;'Header1,Header2']<\/strong><\/code><\/pre>\n\n\n\n<p>Next, we have to use the &#8220;Select&#8221; action to map the label to values.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"415\" data-attachment-id=\"1857\" data-permalink=\"https:\/\/365stack.in\/index.php\/2021\/12\/05\/how-to-read-csv-file-using-power-automate\/screenshot-248\/\" data-orig-file=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-248.png?fit=1013%2C657&amp;ssl=1?v=1638546782\" data-orig-size=\"1013,657\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Screenshot-248\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-248.png?fit=300%2C195&amp;ssl=1?v=1638546782\" data-large-file=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-248.png?fit=640%2C415&amp;ssl=1?v=1638546782\" src=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-248.png?resize=640%2C415&#038;ssl=1\" alt=\"\" class=\"wp-image-1857\" srcset=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-248.png?w=1013&amp;ssl=1 1013w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-248.png?w=300&amp;ssl=1 300w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-248.png?w=768&amp;ssl=1 768w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-248.png?w=368&amp;ssl=1 368w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><figcaption>Select Action<\/figcaption><\/figure><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code><strong>\/\/Select Action Expressions<\/strong>\n\n<strong>From =&gt;<\/strong> skip(outputs('ComposeGetFieldNames'), 1)\/\/ To igonore the header row\n<strong>Map Label =&gt;<\/strong> outputs('ComposeGetFieldNames')&#91;0]\n<strong>Map Value =&gt;<\/strong> split(item(), ',')?&#91;0]\n<\/code><\/pre>\n\n\n\n<p>Pass the data into the &#8220;Create Item&#8221; action. It will automatically create a &#8220;Apply to each&#8221; action because the &#8220;Select&#8221; action returns as an array.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"416\" data-attachment-id=\"1858\" data-permalink=\"https:\/\/365stack.in\/index.php\/2021\/12\/05\/how-to-read-csv-file-using-power-automate\/screenshot-251\/\" data-orig-file=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-251.png?fit=1045%2C679&amp;ssl=1?v=1638548075\" data-orig-size=\"1045,679\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Screenshot-251\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-251.png?fit=300%2C195&amp;ssl=1?v=1638548075\" data-large-file=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-251.png?fit=640%2C416&amp;ssl=1?v=1638548075\" src=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-251-1024x665.png?resize=640%2C416&#038;ssl=1\" alt=\"\" class=\"wp-image-1858\" srcset=\"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-251.png?w=1024&amp;ssl=1 1024w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-251.png?w=300&amp;ssl=1 300w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-251.png?w=768&amp;ssl=1 768w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-251.png?w=368&amp;ssl=1 368w, https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-251.png?w=1045&amp;ssl=1 1045w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><figcaption>Create Item<\/figcaption><\/figure>\n\n\n\n<p>But the only problem is if the values have a comma in them like below, as you have seen a similar example in the &#8220;<a href=\"https:\/\/365stack.in\/index.php\/2021\/12\/03\/how-to-create-csv-file-in-power-automate\/\" target=\"_blank\" rel=\"noreferrer noopener\">Create CSV<\/a>&#8221; post.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/CSV Output\n\n<strong>\/\/CSV output from Get file Content<\/strong>\n&#91;\n'Header1,Header2',\n'\"Data1,Value1\",Data2'\n]\n\n<strong>\/\/Select Output if there is no comma<\/strong>\n&#91;\n{\n\"Header1\":\"Data1\",\n\"Header2\":\"Data2\"\n}\n]\n\n<strong>\/\/Select Output if it has comma<\/strong> - Wrong Output\n&#91;\n{\n\"Header1\":\"Data1\",\n\"Header2\":\"Value1\"\n}\n]\n\n<\/code><\/pre>\n\n\n\n<p>To tackle this situation we need to replace the &#8220;,&#8221; with some other special characters like &#8220;#|#&#8221; from the CSV output before passing it into the Split expression.<\/p>\n\n\n\n<p>To do this we need to loop each column in a row and replace the comma separator with some other special character. There might many solutions to this problem, We followed the following approach please comment if there is any better way to do it.<\/p>\n\n\n\n<p><strong>Pseudocode of the logic<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><strong>\/\/Initialize proper variables<\/strong>\nIntialize mergetext = \"\";\nIntialize newline = \"\";\nInitialize IsSplit = false;\nInitialize arrContent = &#91;];\n\n<strong>Apply to each 4<\/strong> - output of capture csv \/\/ Loop each row\n\n<strong>Split fields<\/strong> - split(items('Apply_to_each_4'), ',')\n\nSet newline = \"\";\nSet mergetext = \"\";\n\n<strong>Apply to each 5<\/strong> - output of split fields \/\/ Loop each column\n\n\/\/Checking first char begins with \"\n<strong>Compose:<\/strong> firstChar -\n  if (equals(length(items('Apply_to_each_5')), 1), equals(variables('IsSplit'), 'false'),\nstartsWith(items('Apply_to_each_5'), '\"'))\n\n\/\/Checking last char ends with \"\n<strong>Compose:<\/strong> lastChar -\n    if (equals(length(items('Apply_to_each_5')), 1), equals(variables('IsSplit'), 'true'), endsWith(items('Apply_to_each_5'), '\"'))\n      \n\n\/\/condition to check the current value has comma in it \nIf(output \/ firstchar = true) {\n  if (output \/ firstchar = true and output \/ lastchar = true) {\n    append to \"newline\" - replace(items('Apply_to_each_5'), '\"', '') + #|#;\n    set \"mergedtext\"\n to \"newline\";\n  } else {\n    append to \"newline\" - replace(items('Apply_to_each_5'), '\"', '')\n    set \"mergedtext\"\n to \"newline\";\n    set \"IsSplit\"\n to true;\n  }\n}\nelse {\n  if (\"newline\"\n is empty) {\n    append to \"newline\" - items('Apply_to_each_5') + #|#;\n    set \"mergedtext\"\n to \"newline\";\n  } else {\n    If(output \/ lastchar = true) {\n      Set \"newline\"\n to \"mergedText\" + replace(items('Apply_to_each_5'), '\"', '') + #|#;\n      Set \"mergedText\"\n to \"newline\";\n      Set \"IsSplit\"\n to false;\n    }\n    else {\n      if (IsSplit = true) {\n        Set \"newline\"\n to \"mergedText\" + replace(items('Apply_to_each_5'), '\"', '');\n        Set \"mergedText\"\n to \"newline\";\n      } else {\n        Set \"newline\"\n to \"mergedText\" + items('Apply_to_each_5') + #|#;\n        Set \"mergedText\"\n to \"newline\";\n      }\n    }\n  }\n}\nend of Apply to each 5\nAppend newline to arrContent\nend of apply to each 4<\/code><\/pre>\n\n\n\n<p>The above Pseudocode should be translated to Power Automate actions. The above process is a simple string operation with the use of nested loops. The target is to replace the comma with some special characters and should not touch the commas inside the text. This &#8220;arrContent&#8221; variable should be passed to the &#8220;Capture CSV&#8221; action<\/p>\n\n\n\n<p>The above comma-separated expressions should be changed as follows:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><strong>\/\/Action Name - ComposeGetFieldNames<\/strong>\nsplit(first(outputs('Capture_CSV')),'#|#')\n\n\n\n<strong>\/\/Select Action Expressions<\/strong>\n<strong>From =&gt;<\/strong> skip(outputs('ComposeGetFieldNames'), 1)\/\/ To igonore the header row\n<strong>Map Label =&gt;<\/strong> outputs('ComposeGetFieldNames')&#91;0]\n<strong>Map Value =&gt;<\/strong> split(item(), '#|#')?&#91;0]\n\n<\/code><\/pre>\n\n\n\n<p>Whatever logic we can do in coding can be implemented in Power Automate with the help of expressions. We will see more use-cases related to expression.<\/p>\n\n\n\n<p>Please post your queries in the comment section. Happy Building \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We will see how to read CSV files using Power Automate and already a post is published to create a CSV file using power automate. This is one of the mandatory use cases in the Office 365 environment, either we will get the data from Email or from an external application or to read the data from a specified location. [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":1857,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[8,32,4],"tags":[72,61,46,33,10,30],"class_list":["post-1642","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-automate","category-power-platform","category-sharepoint","tag-comma-separated-values","tag-csv","tag-microsoft-365","tag-power-platform","tag-powerautomate","tag-sharepoint"],"jetpack_publicize_connections":[],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-248.png?fit=1013%2C657&ssl=1?v=1638546782","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":1640,"url":"https:\/\/365stack.in\/index.php\/2021\/12\/03\/how-to-create-csv-file-in-power-automate\/","url_meta":{"origin":1642,"position":0},"title":"How to create CSV file in Power Automate","author":"Hemanthkumar Rajan","date":"December 3, 2021","format":false,"excerpt":"Export to CSV is one of the common requirements in any application. But in this example, we are not going to show the procedure from the app that will be shared in a separate post. Here we are getting the data from Power Automate itself to support a large set\u2026","rel":"","context":"In &quot;Power Automate&quot;","block_context":{"text":"Power Automate","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/power-automate\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-229.png?fit=934%2C596&ssl=1%3Fv%3D1637940499&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1636,"url":"https:\/\/365stack.in\/index.php\/2021\/11\/29\/how-to-add-rows-in-excel-online-using-power-automate\/","url_meta":{"origin":1642,"position":1},"title":"How to add rows in Excel online using Power Automate","author":"Hemanthkumar Rajan","date":"November 29, 2021","format":false,"excerpt":"Adding rows to an excel file or exporting the data in \".xlsx\" format, which can be sent to users or other applications as data feed can be a common scenario. In this example, we used the \"Excel online business\" connector to add rows to the excel file, Previously we already\u2026","rel":"","context":"In &quot;Power Automate&quot;","block_context":{"text":"Power Automate","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/power-automate\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-214.png?fit=997%2C551&ssl=1%3Fv%3D1637930822&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1973,"url":"https:\/\/365stack.in\/index.php\/2022\/06\/24\/http-triggers-in-power-automate-explained\/","url_meta":{"origin":1642,"position":2},"title":"HTTP triggers in Power Automate explained","author":"Hemanthkumar Rajan","date":"June 24, 2022","format":false,"excerpt":"Power Automate flows can be triggered with HTTP triggers and it will be useful in many scenarios. There are HTTP actions available inside a flow that can be used to get or post data to an external system, In the Azure Form recognizer example, we have used HTTP get request.\u2026","rel":"","context":"In &quot;Power Automate&quot;","block_context":{"text":"Power Automate","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/power-automate\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-612-1.png?fit=1200%2C550&ssl=1%3Fv%3D1640102154&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1937,"url":"https:\/\/365stack.in\/index.php\/2022\/07\/01\/how-to-integrate-automation-anywhere-iq-bot-with-power-platform\/","url_meta":{"origin":1642,"position":3},"title":"How to integrate Automation Anywhere IQ Bot with Power Platform","author":"Hemanthkumar Rajan","date":"July 1, 2022","format":false,"excerpt":"This is a continuation of the OCR series, previously we showed how to extract data from PDF using Power Platform\"AI Builder\" and Azure \"Form Recognizer\". In this post, we will see how to extract data using IQ Bot. Automation Anywhere is one of the leading RPA tools, In Power Platform\u2026","rel":"","context":"In &quot;Power Automate&quot;","block_context":{"text":"Power Automate","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/power-automate\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/12\/Screenshot-380.png?fit=1051%2C631&ssl=1%3Fv%3D1639057573&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1472,"url":"https:\/\/365stack.in\/index.php\/2021\/09\/21\/read-pdf-files-using-ai-builder\/","url_meta":{"origin":1642,"position":4},"title":"How to read PDF files using AI Builder","author":"Hemanthkumar Rajan","date":"September 21, 2021","format":false,"excerpt":"Reading from PDF files is a common requirement in business applications. For eg: Reading the Invoice report from the sales team. Currently, even though the process is digitalized but the data collected from the user as receipt or feedback is in paper format it should be entered manually in the\u2026","rel":"","context":"In &quot;Power Platform&quot;","block_context":{"text":"Power Platform","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/09\/Screenshot-32-1.png?fit=1200%2C443&ssl=1%3Fv%3D1632209476&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1520,"url":"https:\/\/365stack.in\/index.php\/2021\/11\/19\/how-to-add-dynamic-attachments-in-power-automate-send-email-action\/","url_meta":{"origin":1642,"position":5},"title":"How to add dynamic attachments in Send Email\/Approval Action","author":"Hemanthkumar Rajan","date":"November 19, 2021","format":false,"excerpt":"In some scenarios, we may need to add attachments while sending emails to businesses, Some times the attachment files will be dynamic and it will be changed based on users or scenarios. We may get the files from SharePoint, Onedrive, Azure, or any HTTP request, In all cases we can\u2026","rel":"","context":"In &quot;Power Automate&quot;","block_context":{"text":"Power Automate","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/power-automate\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-131.png?fit=1047%2C653&ssl=1%3Fv%3D1637336922&resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/posts\/1642","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/comments?post=1642"}],"version-history":[{"count":6,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/posts\/1642\/revisions"}],"predecessor-version":[{"id":1865,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/posts\/1642\/revisions\/1865"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/media\/1857"}],"wp:attachment":[{"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/media?parent=1642"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/categories?post=1642"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/tags?post=1642"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}