web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Getting Data from a Cu...

Power Automate

Answered

Getting Data from a Custom Object

(0) Share

Report

Report

Posted on by Steve48

431

I am making an app that talsk to chatGPT. using the Invoke Web Service action. I then used the Convert JSON to custom object action. I was able to print the text of my result using:

%AnswerCustomObject['choices'][0].text%

I need help extracting the token details which is in the usage part of the custom object.
would like to extract prompt_tokens, completion_tokens, and total_tokens as 3 different variables.

I wasn't sure of the syntax. TIA

Categories:

Power Automate Desktop

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Steve48

to get values inside the usage key, use below expression to retrive tokena value.

%AnswerCustomObject['usage']['prompt_tokens']% : to get prompt tokens

%AnswerCustomObject['usage']['completion_tokens']% : to get completion tokens

%AnswerCustomObject['usage']['total_tokens']% : to get total tokens

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
Steve48 431 on at

Like
a
(0)

Report
Copy link

Link copied!

@Nived_Nambiar Thank you-that worked

Was this reply helpful? Yes No

Join the conversation