Description Hi , I am getting the data in the below format in the json file. Could you please help me in extracting the following information from the below data. <a name="p-1921692-json-document-pages-pagenumber-1-entities-textanchor-textsegments-startindex-247-endindex-256-content-30-apr-24-type-invoice_date-mentiontext-30-apr-24-confidence-096529007-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-076442593-y-021404542-x-082331944-y-021404542-x-082331944-y-022750211-x-076442593-y-022750211-id-0-normalizedvalue-text-2024-04-30-datevalue-year-2024-month-4-day-30-textanchor-textsegments-startindex-1834-endindex-1843-content-1611000-type-total_amount-mentiontext-1611000-confidence-094710624-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-08441404-y-0764508-x-09411065-y-0764508-x-09411065-y-07804878-x-08441404-y-07804878-id-1-normalizedvalue-text-16110-textanchor-textsegments-startindex-1890-endindex-1899-content-29-jun-24-type-due_date-mentiontext-29-jun-24-confidence-09443872-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-08839976-y-08061396-x-094170135-y-08061396-x-094170135-y-08179142-x-08839976-y-08179142-id-2-normalizedvalue-text-2024-06-29-datevalue-year-2024-month-6-day-29-textanchor-textsegments-startindex-145-endindex-154-content-s01894912-type-invoice_id-mentiontext-s01894912-confidence-092988557-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-020880428-y-017325483-x-037834623-y-017325483-x-037834623-y-019512194-x-020880428-y-019512194-id-3-textanchor-textsegments-startindex-1291-endindex-1300-content-1611000-type-net_amount-mentiontext-1611000-confidence-092172015-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-086079717-y-073044574-x-093991673-y-073044574-x-093991673-y-074432296-x-086079717-y-074432296-id-4-normalizedvalue-text-16110-textanchor-textsegments-startindex-1830-endindex-1833-content-usd-type-currency-mentiontext-usd-confidence-08704995-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-06954194-y-076576954-x-07209994-y-076576954-x-07209994-y-07783852-x-06954194-y-07783852-id-5-normalizedvalue-text-usd-textanchor-textsegments-startindex-340-endindex-362-content-60-days-from-inv-date-type-payment_terms-mentiontext-60-days-from-inv-date-confidence-07146772-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-07638311-y-029394448-x-089827484-y-029394448-x-089827484-y-030824223-x-07638311-y-030824223-id-6-textanchor-textsegments-startindex-96-endindex-116-content-com-type-supplier_website-mentiontext-ecom-confidence-06468903-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-056157047-y-01312027-x-07430101-y-01312027-x-07430101-y-014550042-x-056157047-y-014550042-id-7-textanchor-textsegments-startindex-3-endindex-26-content-india-wide-logistics-type-supplier_name-mentiontext-india-wide-logistics-confidence-06138423-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-056632954-y-0042472664-x-078167754-y-0042472664-x-078167754-y-0058873-x-056632954-y-0058873-id-8-normalizedvalue-text-istics-textanchor-textsegments-startindex-27-endindex-70-content-7nusa-type-supplier_address-mentiontext-7nusa-confidence-05933487-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-056276023-y-0058873-x-07447948-y-0058873-x-07447948-y-010639193-x-056276023-y-010639193-id-9-normalizedvalue-text-usa-addressvalue-regioncode-us-languagecode-en-us-postalcode-administrativearea-illois-locality-palatine-addresslines-d-textanchor-textsegments-startindex-78-endindex-95-content-11-type-supplier_phone-mentiontext-11-confidence-059013975-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-06323617-y-010933558-x-07662106-y-010933558-x-07662106-y-012657696-x-06323617-y-012657696-id-10-normalizedvalue-text-66-0711-textanchor-textsegments-startindex-684-endindex-700-content-0003001003-00150-type-purchase_order-mentiontext-0003001003-00150-confidence-05397213-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-0215348-y-0490328-x-033372992-y-0490328-x-033372992-y-050546676-x-0215348-y-050546676-id-11-textanchor-textsegments-startindex-2087-endindex-2136-content-ponited-states-type-remit_to_address-mentiontext-po-nunited-states-confidence-044959384-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-050386673-y-084020185-x-06561571-y-084020185-x-06561571-y-08713204-x-050386673-y-08713204-id-12-type-invoice_type-confidence-03908778-pageanchor-pagerefs-id-13-normalizedvalue-text-invoice_statement-textanchor-textsegments-startindex-2057-endindex-2086-content-logistics-inc-type-remit_to_name-mentiontext-logistics-inc-confidence-020493957-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-050743604-y-08292683-x-072635335-y-08292683-x-072635335-y-0842725-x-050743604-y-0842725-id-14-textanchor-textsegments-startindex-1856-endindex-1866-content-whirlpsxx1-type-supplier_tax_id-mentiontext-whisxx1-confidence-0152821-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-020464009-y-079268295-x-029625222-y-079268295-x-029625222-y-08061396-x-020464009-y-08061396-id-15-textanchor-textsegments-startindex-1083-endindex-1114-content-abcee-columbus-united-states-type-ship_to_address-mentiontext-abcde-columbus-united-states-confidence-008760377-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-050386673-y-057611436-x-071802497-y-057611436-x-071802497-y-058915055-x-050386673-y-058915055-id-16-textanchor-textsegments-startindex-1206-endindex-1271-startindex-1272-endindex-1281-type-line_item-mentiontext-1611000-confidence-1-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-00594884-y-065937763-x-09405116-y-065937763-x-09405116-y-067535746-x-00594884-y-067535746-id-17-properties-textanchor-textsegments-startindex-1206-endindex-1271-content-0-container-8055-type-line_itemdescription-mentiontext-40-container-8055-confidence-06885872-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-00594884-y-065937763-x-06508031-y-065937763-x-06508031-y-067535746-x-00594884-y-067535746-id-18-textanchor-textsegments-startindex-1272-endindex-1281-content-1611000-type-line_itemamount-mentiontext-1611000-confidence-08672323-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-086020225-y-065979815-x-09405116-y-065979815-x-09405116-y-067283434-x-086020225-y-067283434-id-19-normalizedvalue-text-16110-humanreviewstatus-state-skipped-2" class="anchor" href="#p-1921692-json-document-pages-pagenumber-1-entities-textanchor-textsegments-startindex-247-endindex-256-content-30-apr-24-type-invoice_date-mentiontext-30-apr-24-confidence-096529007-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-076442593-y-021404542-x-082331944-y-021404542-x-082331944-y-022750211-x-076442593-y-022750211-id-0-normalizedvalue-text-2024-04-30-datevalue-year-2024-month-4-day-30-textanchor-textsegments-startindex-1834-endindex-1843-content-1611000-type-total_amount-mentiontext-1611000-confidence-094710624-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-08441404-y-0764508-x-09411065-y-0764508-x-09411065-y-07804878-x-08441404-y-07804878-id-1-normalizedvalue-text-16110-textanchor-textsegments-startindex-1890-endindex-1899-content-29-jun-24-type-due_date-mentiontext-29-jun-24-confidence-09443872-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-08839976-y-08061396-x-094170135-y-08061396-x-094170135-y-08179142-x-08839976-y-08179142-id-2-normalizedvalue-text-2024-06-29-datevalue-year-2024-month-6-day-29-textanchor-textsegments-startindex-145-endindex-154-content-s01894912-type-invoice_id-mentiontext-s01894912-confidence-092988557-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-020880428-y-017325483-x-037834623-y-017325483-x-037834623-y-019512194-x-020880428-y-019512194-id-3-textanchor-textsegments-startindex-1291-endindex-1300-content-1611000-type-net_amount-mentiontext-1611000-confidence-092172015-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-086079717-y-073044574-x-093991673-y-073044574-x-093991673-y-074432296-x-086079717-y-074432296-id-4-normalizedvalue-text-16110-textanchor-textsegments-startindex-1830-endindex-1833-content-usd-type-currency-mentiontext-usd-confidence-08704995-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-06954194-y-076576954-x-07209994-y-076576954-x-07209994-y-07783852-x-06954194-y-07783852-id-5-normalizedvalue-text-usd-textanchor-textsegments-startindex-340-endindex-362-content-60-days-from-inv-date-type-payment_terms-mentiontext-60-days-from-inv-date-confidence-07146772-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-07638311-y-029394448-x-089827484-y-029394448-x-089827484-y-030824223-x-07638311-y-030824223-id-6-textanchor-textsegments-startindex-96-endindex-116-content-com-type-supplier_website-mentiontext-ecom-confidence-06468903-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-056157047-y-01312027-x-07430101-y-01312027-x-07430101-y-014550042-x-056157047-y-014550042-id-7-textanchor-textsegments-startindex-3-endindex-26-content-india-wide-logistics-type-supplier_name-mentiontext-india-wide-logistics-confidence-06138423-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-056632954-y-0042472664-x-078167754-y-0042472664-x-078167754-y-0058873-x-056632954-y-0058873-id-8-normalizedvalue-text-istics-textanchor-textsegments-startindex-27-endindex-70-content-7nusa-type-supplier_address-mentiontext-7nusa-confidence-05933487-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-056276023-y-0058873-x-07447948-y-0058873-x-07447948-y-010639193-x-056276023-y-010639193-id-9-normalizedvalue-text-usa-addressvalue-regioncode-us-languagecode-en-us-postalcode-administrativearea-illois-locality-palatine-addresslines-d-textanchor-textsegments-startindex-78-endindex-95-content-11-type-supplier_phone-mentiontext-11-confidence-059013975-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-06323617-y-010933558-x-07662106-y-010933558-x-07662106-y-012657696-x-06323617-y-012657696-id-10-normalizedvalue-text-66-0711-textanchor-textsegments-startindex-684-endindex-700-content-0003001003-00150-type-purchase_order-mentiontext-0003001003-00150-confidence-05397213-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-0215348-y-0490328-x-033372992-y-0490328-x-033372992-y-050546676-x-0215348-y-050546676-id-11-textanchor-textsegments-startindex-2087-endindex-2136-content-ponited-states-type-remit_to_address-mentiontext-po-nunited-states-confidence-044959384-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-050386673-y-084020185-x-06561571-y-084020185-x-06561571-y-08713204-x-050386673-y-08713204-id-12-type-invoice_type-confidence-03908778-pageanchor-pagerefs-id-13-normalizedvalue-text-invoice_statement-textanchor-textsegments-startindex-2057-endindex-2086-content-logistics-inc-type-remit_to_name-mentiontext-logistics-inc-confidence-020493957-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-050743604-y-08292683-x-072635335-y-08292683-x-072635335-y-0842725-x-050743604-y-0842725-id-14-textanchor-textsegments-startindex-1856-endindex-1866-content-whirlpsxx1-type-supplier_tax_id-mentiontext-whisxx1-confidence-0152821-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-020464009-y-079268295-x-029625222-y-079268295-x-029625222-y-08061396-x-020464009-y-08061396-id-15-textanchor-textsegments-startindex-1083-endindex-1114-content-abcee-columbus-united-states-type-ship_to_address-mentiontext-abcde-columbus-united-states-confidence-008760377-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-050386673-y-057611436-x-071802497-y-057611436-x-071802497-y-058915055-x-050386673-y-058915055-id-16-textanchor-textsegments-startindex-1206-endindex-1271-startindex-1272-endindex-1281-type-line_item-mentiontext-1611000-confidence-1-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-00594884-y-065937763-x-09405116-y-065937763-x-09405116-y-067535746-x-00594884-y-067535746-id-17-properties-textanchor-textsegments-startindex-1206-endindex-1271-content-0-container-8055-type-line_itemdescription-mentiontext-40-container-8055-confidence-06885872-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-00594884-y-065937763-x-06508031-y-065937763-x-06508031-y-067535746-x-00594884-y-067535746-id-18-textanchor-textsegments-startindex-1272-endindex-1281-content-1611000-type-line_itemamount-mentiontext-1611000-confidence-08672323-pageanchor-pagerefs-boundingpoly-normalizedvertices-x-086020225-y-065979815-x-09405116-y-065979815-x-09405116-y-067283434-x-086020225-y-067283434-id-19-normalizedvalue-text-16110-humanreviewstatus-state-skipped-2"> ------------------------------- JSON -------------------------------------------- { “document”: { “pages”: [ { “pageNumber”: 1 } …

Hi @avinashy , Use “Deserialize JSON” Activity Assign the JSON string to a variable (jsonString). Use Deserialize JSON activity to convert it into a JObject (jsonObject). Extract Required Fields Using JSONPath or Dictionary Access Assign values using: invoice_date = jsonObject("document")("ent…

Need to Extract the Specific Data From Json

Help Activities

system (system) Closed March 21, 2025, 9:05am 5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Need to extract specific data from JSON data Studio studio , question , activities_panel	5	1112	February 2, 2024
How can I extract some data from a JSON file? Studio studio , question , activities_panel	7	1102	January 17, 2023
Extract data from json file Studio	25	3404	September 20, 2020
Extract data from Json format string Studio studio , question , activities_panel	5	273	February 2, 2024
How to extract the exact data from Json file Help studio	4	24557	May 13, 2019

Need to Extract the Specific Data From Json

Related topics