no_name_needed
New Member
- Joined
- Jul 19, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I pulled data into excel from an API. However, it shows as list then record. I need all records expanded when I close and load, but can't figure it out. A few screenshots to help see what I'm trying to work with:
I need the values: id, ticket_id, user_id, reason, and created_at. I do not need updated_at and ticket. Now, I preface all of this with I am completely new to this and trying to learn and teach myself. I know I need to update the Power Automate but I'm not sure where to start. Any help is greatly appreciated here! I only have the basic where it's grabbing the source code from. I've looked at other posts but can't figure out how to alter what I've found to my API results.
I need the values: id, ticket_id, user_id, reason, and created_at. I do not need updated_at and ticket. Now, I preface all of this with I am completely new to this and trying to learn and teach myself. I know I need to update the Power Automate but I'm not sure where to start. Any help is greatly appreciated here! I only have the basic where it's grabbing the source code from. I've looked at other posts but can't figure out how to alter what I've found to my API results.
VBA Code:
let
Source = Json.Document(Web.Contents("https.....skips.json")),
in
skips2