Skip to main content

Notifications

Copilot Studio - General
Answered

Extract data from record returned by HTTP request

Like (1) ShareShare
ReportReport
Posted on 1 Oct 2024 09:57:13 by 34
Hi, I'm making a HTTP request to return user data based on email address.
The request returns a large chunk of data and I only want to extract one piece, is there a formula I can use to extract only the one piece of information I need and save as a variable?
 
Below is the schema with the information I'm looking to save highlighted:
 
kind: Record
properties:
  data:
    type:
      kind: Table
      properties:
        balance: String
        branch: String
        courses:
          type:
            kind: Record
            properties:
              count: Number
              list:
                type:
                  kind: Table
                  properties:
                    formatted_name: String
                    from_timestamp: String
                    id: String
                    issued_certificate: String
                    score: String
                    status: String
                    to_timestamp: String
 
        email: String
        id: String
        login: String
        name: String
        surname: String
 
  executionDuration: Number
  success: Boolean
  version: String
Categories:
  • Verified answer
    JE-09091517-0 Profile Picture
    JE-09091517-0 34 on 01 Oct 2024 at 15:22:40
    Extract data from record returned by HTTP request
    I figured it out, posting the answer here for anyone else who needs it:
     
    Index(Topic.result.data,1).id

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #9 Get Recognized…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,316

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,290

Leaderboard
Loading complete