Unanswered

Table from json response example

(0) Share

Report

Posted on by migdc

Hello! We have a URL of the type https://helpdesk.com/<Ticket Number> it returns json code with the structure
{
"subject"="Mouse Problem",
"status"="Open",
"date"="01112002"
}

Depending on the TicketNumber, it returns a different json, with the ticket data.

Will they have an example in PVA to be able to return to the user, after entering the ticket number (we already have this created), a table with the values that the json returns? Thanks in advance

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Pstork1 69,554 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

I have an example of something similar. The key is to read the JSON array in the flow and build a markdown string that will display as a table after the string is returned to the bot. Here are a couple screenshots

This is my Table header

And this is the Apply to Each where I append each row to the table

I then return the string variable that has been created and the bot displays it as a table.

Was this reply helpful? Yes No
migdc 3 on at

Like
a
(0)

Report
Copy link

Link copied!
Ok, thanks for response.
I get a tiny example for begin the "json to table" response.
https://reqbin.com/echo/get/json for example
this page returns the following json:
{"success":"true"}
Easy (for easy understdanding the idea). what I need to understand is how do I return that text "True" value as a message to the user:
My flow was.... but dont work,

Was this reply helpful? Yes No