{"id":6777,"date":"2022-09-05T02:28:53","date_gmt":"2022-09-04T20:58:53","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/"},"modified":"2022-09-05T02:28:53","modified_gmt":"2022-09-04T20:58:53","slug":"solved-import-data-from-an-api-link-that-contains-json-to-excel-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/","title":{"rendered":"[Solved] Import data from an API link that contains JSON to EXCEL [closed]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-51624048\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"51624048\" data-parentid=\"51623127\" data-score=\"1\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>First of all you need to examine the structure of the JSON response, using any online JSON viewer (e. g. <a rel=\"nofollow noopener\" target=\"_blank\" href=\"http:\/\/jsonviewer.stack.hu\/\">http:\/\/jsonviewer.stack.hu\/<\/a>), where you can see that your JSON object contains <code>atletas<\/code> array, <code>clubes<\/code>, <code>posicoes<\/code>, <code>status<\/code>, <code>time<\/code> objects, and several properties with scalar values:<\/p>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-Import-data-from-an-API-link-that-contains-JSON.png\"><img decoding=\"async\" src=\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-Import-data-from-an-API-link-that-contains-JSON.png\" alt=\"JSON\"><\/a><\/p>\n<p>Going further there are objects within <code>atletas<\/code> array, each of them contains some properties that can be populated on the worksheet:<\/p>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/1662325132_96_Solved-Import-data-from-an-API-link-that-contains-JSON.png\"><img decoding=\"async\" src=\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/1662325132_96_Solved-Import-data-from-an-API-link-that-contains-JSON.png\" alt=\"atletas array\"><\/a><\/p>\n<p>Here is VBA example showing how that values could be retrieved. <strong>Import <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/github.com\/omegastripes\/VBA-JSON-parser\">JSON.bas<\/a> module into the VBA project for JSON processing.<\/strong><\/p>\n<pre class=\"lang-vb prettyprint-override\"><code>Option Explicit\n\nSub Test()\n\n    Dim sJSONString As String\n    Dim vJSON\n    Dim sState As String\n    Dim aData()\n    Dim aHeader()\n    Dim vResult\n    Dim sName\n\n    ' Retrieve JSON content\n    With CreateObject(\"MSXML2.XMLHTTP\")\n        .Open \"GET\", \"https:\/\/api.cartolafc.globo.com\/time\/slug\/umo\/16\", True\n        .send\n        Do Until .readyState = 4: DoEvents: Loop\n        sJSONString = .responseText\n    End With\n    ' Parse JSON sample\n    JSON.Parse sJSONString, vJSON, sState\n    If sState = \"Error\" Then\n        MsgBox \"Invalid JSON\"\n        End\n    End If\n    ' Example of processing single property\n    ' Get 'atletas' array of objects, there is no Set keyword for arrays\n    vResult = vJSON(\"atletas\")\n    '' Optional get 'clubes' object of objects, Set keyword used for objects represented by dictionaries\n    '' Set vResult = vJSON(\"clubes\")\n    ' Convert to 2d array\n    JSON.ToArray vResult, aData, aHeader\n    ' Output 2d array to first worksheet\n    With ThisWorkbook.Sheets(1)\n        .Cells.Delete\n        .Cells.WrapText = False\n        OutputArray .Cells(1, 1), aHeader\n        Output2DArray .Cells(2, 1), aData\n        .Columns.AutoFit\n    End With\n    ' Remove 'atletas' array from root object\n    vJSON.Remove \"atletas\"\n    ' Remove all worksheets but the first\n    Application.DisplayAlerts = False\n    With ThisWorkbook.Sheets\n        Do Until .Count = 1\n            .Item(.Count).Delete\n        Loop\n    End With\n    Application.DisplayAlerts = True\n    ' Example of processing multiply properties on separate worksheets\n    ' Processing all the rest of objects and arrays\n    For Each sName In vJSON\n        ' Check if the property is array or object\n        If IsArray(vJSON(sName)) Or IsObject(vJSON(sName)) Then\n            ' Convert to 2d array\n            JSON.ToArray vJSON(sName), aData, aHeader\n            ' Output 2d array to worksheet\n            With ThisWorkbook.Sheets.Add ' Create new worksheet for output\n                OutputArray .Cells(1, 1), aHeader\n                Output2DArray .Cells(2, 1), aData\n                .Columns.AutoFit\n            End With\n            ' Remove output object from root object\n            vJSON.Remove sName\n        End If\n    Next\n    ' Processing all the rest of properties with scalar values which remain in root object\n    ' Convert root object to 2d array\n    JSON.ToArray vJSON, aData, aHeader\n    ' Output 2d array to worksheet\n    With ThisWorkbook.Sheets.Add ' Create new worksheet for output\n        OutputArray .Cells(1, 1), aHeader\n        Output2DArray .Cells(2, 1), aData\n        .Columns.AutoFit\n    End With\n    ' Or the whole JSON structure could be flattened and output to worksheet\n    ' Parse JSON sample\n    JSON.Parse sJSONString, vJSON, sState\n    ' Flatten JSON\n    JSON.Flatten vJSON, vResult\n    ' Convert flattened JSON to 2d array\n    JSON.ToArray vResult, aData, aHeader\n    ' Output 2d array to worksheet\n    With ThisWorkbook.Sheets.Add ' Create new worksheet for output\n        OutputArray .Cells(1, 1), aHeader\n        Output2DArray .Cells(2, 1), aData\n        .Columns.AutoFit\n    End With\n    MsgBox \"Completed\"\n\nEnd Sub\n\nSub OutputArray(oDstRng As Range, aCells As Variant)\n\n    With oDstRng\n        .Parent.Select\n        With .Resize(1, UBound(aCells) - LBound(aCells) + 1)\n            .NumberFormat = \"@\"\n            .Value = aCells\n        End With\n    End With\n\nEnd Sub\n\nSub Output2DArray(oDstRng As Range, aCells As Variant)\n\n    With oDstRng\n        .Parent.Select\n        With .Resize( _\n                UBound(aCells, 1) - LBound(aCells, 1) + 1, _\n                UBound(aCells, 2) - LBound(aCells, 2) + 1)\n            .NumberFormat = \"@\"\n            .Value = aCells\n        End With\n    End With\n\nEnd Sub\n<\/code><\/pre>\n<p>The output for <code>atletas<\/code> array for me is as follows:<\/p>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/1662325133_14_Solved-Import-data-from-an-API-link-that-contains-JSON.png\"><img decoding=\"async\" src=\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/1662325133_14_Solved-Import-data-from-an-API-link-that-contains-JSON.png\" alt=\"enter image description here\"><\/a><\/p>\n<p>BTW, the similar approach applied in other answers.<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">1<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Import data from an API link that contains JSON to EXCEL [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] First of all you need to examine the structure of the JSON response, using any online JSON viewer (e. g. http:\/\/jsonviewer.stack.hu\/), where you can see that your JSON object contains atletas array, clubes, posicoes, status, time objects, and several properties with scalar values: Going further there are objects within atletas array, each of them &#8230; <a title=\"[Solved] Import data from an API link that contains JSON to EXCEL [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/\" aria-label=\"More on [Solved] Import data from an API link that contains JSON to EXCEL [closed]\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[1315,400,1566,356,401],"class_list":["post-6777","post","type-post","status-publish","format-standard","hentry","category-solved","tag-api","tag-excel","tag-import","tag-json","tag-vba"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] Import data from an API link that contains JSON to EXCEL [closed] - JassWeb<\/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:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Import data from an API link that contains JSON to EXCEL [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] First of all you need to examine the structure of the JSON response, using any online JSON viewer (e. g. http:\/\/jsonviewer.stack.hu\/), where you can see that your JSON object contains atletas array, clubes, posicoes, status, time objects, and several properties with scalar values: Going further there are objects within atletas array, each of them ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-04T20:58:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-Import-data-from-an-API-link-that-contains-JSON.png\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Import data from an API link that contains JSON to EXCEL [closed]\",\"datePublished\":\"2022-09-04T20:58:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/\"},\"wordCount\":128,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-Import-data-from-an-API-link-that-contains-JSON.png\",\"keywords\":[\"api\",\"excel\",\"import\",\"json\",\"vba\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/\",\"name\":\"[Solved] Import data from an API link that contains JSON to EXCEL [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-Import-data-from-an-API-link-that-contains-JSON.png\",\"datePublished\":\"2022-09-04T20:58:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/#primaryimage\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-Import-data-from-an-API-link-that-contains-JSON.png\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-Import-data-from-an-API-link-that-contains-JSON.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Import data from an API link that contains JSON to EXCEL [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Import data from an API link that contains JSON to EXCEL [closed] - JassWeb","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:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Import data from an API link that contains JSON to EXCEL [closed] - JassWeb","og_description":"[ad_1] First of all you need to examine the structure of the JSON response, using any online JSON viewer (e. g. http:\/\/jsonviewer.stack.hu\/), where you can see that your JSON object contains atletas array, clubes, posicoes, status, time objects, and several properties with scalar values: Going further there are objects within atletas array, each of them ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/","og_site_name":"JassWeb","article_published_time":"2022-09-04T20:58:53+00:00","og_image":[{"url":"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-Import-data-from-an-API-link-that-contains-JSON.png","type":"","width":"","height":""}],"author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Import data from an API link that contains JSON to EXCEL [closed]","datePublished":"2022-09-04T20:58:53+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/"},"wordCount":128,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"image":{"@id":"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/#primaryimage"},"thumbnailUrl":"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-Import-data-from-an-API-link-that-contains-JSON.png","keywords":["api","excel","import","json","vba"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/","name":"[Solved] Import data from an API link that contains JSON to EXCEL [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"primaryImageOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/#primaryimage"},"image":{"@id":"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/#primaryimage"},"thumbnailUrl":"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-Import-data-from-an-API-link-that-contains-JSON.png","datePublished":"2022-09-04T20:58:53+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/#primaryimage","url":"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-Import-data-from-an-API-link-that-contains-JSON.png","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-Import-data-from-an-API-link-that-contains-JSON.png"},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-import-data-from-an-api-link-that-contains-json-to-excel-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Import data from an API link that contains JSON to EXCEL [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/6777","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=6777"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/6777\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=6777"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=6777"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=6777"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}