Answered

json parsing error expected object but got string

(1) Share

Report

Posted on by CU05081455-1

can you please help me on this, i want to retrieve text and links which is present inside json file which is like this{
"session_id": "string",
"answer": {
"text": "string",
"links": [
"string"
]
}
}
when i am doing this i can fetch the text inside answer from below query Set(varResponse,askSRE.GetAnswer({db:Dbvar,msg:'Pass your Query'.Text,session_id:CurrentSessionID}));
Patch(DataTable,{SessionID:CurrentSessionID,Question:'Pass your Query'.Text,Answer:varResponse.answer.text});
But when i am trying to perform operation i see json parsing error expected object but got string.....can you please help on this

Categories:

AI Builder

Error.png

I have the same question (0)

All responses (7)

Answers (1)

Kameshm05 302 Moderator on at

Like (1)

Report

Hi,

Can you show me what will you see in the "varResponse" variable? If it is returns string you need to convert string to json.

Please reply here if it is not solve your problem.

Was this reply helpful? Yes No
CU05081455-1 10 on at

Like (0)

Report

I see 3 variables which are there in response, I am able to see the text,session_id and links which is present in the response but not able to figure out how to get links in answer section and sent it to Excel sheet as i can see my answer type inside galary is Text and inside that i have given ThisItem.Answer...

Was this reply helpful? Yes No
Kameshm05 302 Moderator on at

Like (1)

Report

Hi,

Here the links looks like Table, can you click on the Icon under the links. so you can get more info about that.

To get the text, you can use this syntax varResponse.text.
here the links is like an array. what do you want to exactly extract from the links array? Just share the screenshot to understand how the links array looks.

Was this reply helpful? Yes No
CU05081455-1 10 on at

Like (1)

Report

Hi,

Inside links there is links of array which i want to fetch.

Was this reply helpful? Yes No
Kameshm05 302 Moderator on at

Like (1)

Report
Hi,

Thanks for the response. Where do you want to store this links? In an string column or do you have the separate table to store this links array?

If you want to store in a single string column you can use this syntax. The syntax will give all the links as comma separated string.

If you want to store this in separate table, you have loop the links array and need to patch into the new table.

Concat( varResponse.links, Value, ", " )

Let me know if you need more info

Thanks

Was this reply helpful? Yes No
CU05081455-1 10 on at

Like (1)

Report

Hi,

I am able to see all the links and they are clickable but now the issue is all the linked are merged into one, how can i use one link at a time if the links are stored in table, for making link as clickable i have inserted html text inside gallery.

"<a href='" & ThisItem.Links & "' target='_blank'>" & ThisItem.Links & "</a>"

Was this reply helpful? Yes No
Verified answer

Kameshm05 302 Moderator on at

Like (1)

Report

For this clickable link, you don't have to concat the table values. Just insert a gallery, add the varResponse.Links in the items property.
Add the HTMLText control inside the gallery and set the value for the html text like below.

"<a href='" & ThisItem.Value & "' target='_blank'>" & ThisItem.Value & "</a>"

Thanks

Was this reply helpful? Yes No