Map Specific Value From Output Bundle

Hi all, I’m new to Make but pretty experienced in web development. Been trying all day to map the value of “id” from a lengthy output bundle of an HTTP basic auth request (so long that it doesn’t show in any screenshot) which in this example is “2x7900” :

[{“statusCode”: 200,“headers”: [{“name”: “date”,“value”: “Thu, 25 Sep 2025 15:27:04 GMT”},{“name”: “server”,“value”: “Apache”},{“name”: “strict-transport-security”,“value”: “max-age=15768000”},{“name”: “upgrade”,“value”: “h2”},{“name”: “connection”,“value”: “Upgrade, Keep-Alive”},{“name”: “x-ratelimit-dailylimit”,“value”: “10000”},{“name”: “x-ratelimit-remaining”,“value”: “9968”},{“name”: “x-ratelimit-reset”,“value”: “1758844800”},{“name”: “x-floodcontrol-minutelimit”,“value”: “5”},{“name”: “x-floodcontrol-remaining”,“value”: “4”},{“name”: “x-floodcontrol-reset”,“value”: “1758814080”},{“name”: “x-vtiger-version”,“value”: “9.25.9.1”},{“name”: “content-length”,“value”: “1659”},{“name”: “keep-alive”,“value”: “timeout=5, max=100”},{“name”: “content-type”,“value”: “text/json; charset=UTF-8”}],“cookieHeaders”: ,“data”: “{“success”:true,“result”:{“firstname":“Ringo”,“lastname”:“Starr”,“leadstatus”:“Contacted”,“salutationtype”:“”,“mobile”:“447894321654”,“phone”:“”,“email”:"ring@starr.com”,“secondaryemail”:“”,“company”:“”,“fax”:“”,“industry”:“”,“website”:“”,“leadsource”:“Call”,“assigned_user_id”:“19x6”,“createdtime”:“2025-09-25 15:27:04”,“modifiedtime”:“2025-09-25 15:27:04”,“primary_twitter”:“”,“created_user_id”:“19x1”,“modifiedby”:“19x1”,“emailoptout”:“0”,“platform”:“”,“source_campaign”:“”,“creator_crmid”:“”,“adgroup”:“”,“modifier_crmid”:“”,“starred”:“0”,“tags”:“”,“record_currency_id”:“21x2”,“record_conversion_rate”:“1.00000”,“emailoptin_requestcount”:“0”,“emailoptin_lastrequestedon”:“”,“primary_phone_field”:“”,“primary_email_field”:“”,“isclosed”:0,“facebook_lead_id”:“”,“time_zone_greeting”:“”,“designation”:“Small: 30 - 45 sq ft”,“cf_leads_startdate”:“2025-10-01”,“noofemployees”:“0”,“annualrevenue_currency_value”:“”,“annualrevenue”:“”,“pobox”:“”,“lane”:“”,“city”:“”,“state”:“”,“code”:“”,“country”:“GB”,“mailing_gps_lat”:“”,“mailing_gps_lng”:“”,“description”:“”,“cf_leads_viewingarranged”:“”,“last_contacted_via”:“”,“last_contacted_on”:“”,“source”:“WEBSERVICE”,“time_zone”:“”,“lead_no”:“LEA177”,“engagement_score”:“0”,“language”:“”,“smsoptin”:“singleoptinuser”,“emailoptin”:“singleoptinuser”,“imagename”:“”,“facebookid”:“0”,“consent_requested”:“0”,“instagramid”:“”,“consent_trash_data”:“”,“twitterid”:“”,“data_erased”:“0”,“consent_lock_data”:“”,“consent_track_email_engagement”:“”,“consent_track_shared_documents”:“”,“consents_last_requested_on”:“”,“id”:“2x7900”,“label”:“Ringo Starr”,“url”:“https://morespace.od2.vtiger.com/view/detail?module=Leads&id=7900”}}”,“fileSize”: 1659}]

Tried using split, text & json aggregator & parser without success, but must be going wrong somewhere! So hopefully someone more experienced could kindly explain the best way to solve this please?

Welcome to the Make community!

The above is not valid JSON. You can verify this by copy-pasting into jsonformatter.org

Could you please try providing it again with the following instructions?

1. This forum might have or already changed your text

When pasting code/text examples into this forum, you should format the content using the richtext editor, otherwise this forum’s software (Discourse) will modify the content, and you might get incorrect answers from others because of it.

Some things this forum software might do to mangle your text:

– remove extra spaces (which may be necessary)
– convert links to titles (when copied is incorrect)
– incorrect joined links
– convert single and double quotes to smart angled quotes (“ ”)
– emojis
– etc.

This interferes with you receiving correct answers, because it:

– makes JSON invalid (you can check by copy-pasting into any JSON editor/formatter like jsonformatter.org)
– makes incorrect text examples when we need to build a pattern for text parsing

2. To prevent this in future, please format text in code blocks

Here are some ways to provide text content in a way that it won’t be modified by the forum.

  • Method 1: Type code fence manually
    Add three backticks ``` in a separate line before and after the content, like this,

    ```
    text goes here
    ```
    
  • Method 2: Highlight and click the “preformatted text” button in the editor

  • Method 3: Upload your file and share the public link
    (this method is only recommended for large files exceeding the forum upload limit)

3. You might need to re-copy the original text

Once the post has been submitted, it’s too late to format it since it’s already modified in the database, and you need to make a re-copy of the text and format it correctly before submitting the forum post.

Please let us know once you have corrected the issue. This will avoid others potentially providing wrong answers based on incorrect text in your question.

Thank you!

Hope you get it sorted. Feel free to ask if anything is unclear.

@samliew
P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!

Hey there,

when I tested with your data, the variable was directly accessible.

Can you share some screenshots of what issues are you facing? All I did was put the “data” JSON from your string in a Parse JSON module.