Reading Json Data from a Document

Hi harshav there can be a possibility to deal with this requirement, but need to do some R&D on this.

You can try converting the response file it Base64 and again Base64 to Text, so the content which will be returned to you, will be your Json Data.

But as i said, this required R&D and custom Plugin to be developed which can deal with files rather than normal texts for conversion into Base64 Format.

Hope this will give you an idea to proceed further.

Thanks for the reply alok, and I know this approach before but I was expecting any way with the inbuilt techniques.

Could you please post a sample request ?

[
{
"A": 0,
"B": "AAA",
"C": 0,
"D": "AAA",
"E": "Pending",
"F": "",
"G": "AAA",
"H": 1461220449000,
"I": " ",
"J": "",
"K": "",
"L": "AA 99000/0078 - 0001",
"M": 30379,
"N": "",
"O": "",
"P": "",
"Q": "",
"R": "",
"S": "",
"T": "",
"U": "2926",
"V": null,
"W": null,
"X": false,
"Y": false,
"Z": false

}
]

Just copy this into a document and save it as a json file for reference...
I need to read that file and show case this results in a CDT format and use that data in screens.

Thanks :)

It is working for me to map to a CDT, please remove the square bases and try ([])
{
"A": 0,
"B": "AAA",
"C": 0,
"D": "AAA",
"E": "Pending",
"F": "",
"G": "AAA",
"H": 1461220449000,
"I": " ",
"J": "",
"K": "",
"L": "AA 99000/0078 - 0001",
"M": 30379,
"N": "",
"O": "",
"P": "",
"Q": "",
"R": "",
"S": "",
"T": "",
"U": "2926",
"V": null,
"W": null,
"X": false,
"Y": false,
"Z": false

}

It is working for me to map to a CDT, please remove the square bases and try ([])
{
"A": 0,
"B": "AAA",
"C": 0,
"D": "AAA",
"E": "Pending",
"F": "",
"G": "AAA",
"H": 1461220449000,
"I": " ",
"J": "",
"K": "",
"L": "AA 99000/0078 - 0001",
"M": 30379,
"N": "",
"O": "",
"P": "",
"Q": "",
"R": "",
"S": "",
"T": "",
"U": "2926",
"V": null,
"W": null,
"X": false,
"Y": false,
"Z": false

}

braces* (typo error)

I never said it is not working for me Vijay, my question is how will you read this data if this is coming you from a file, I mean how will you read the data from the file to get this format is the first show stopper for me. After that I will use a!fromJson and get the output
if you have done copying this entire code in a Json file and did it please let me know the steps how to do it,

You can make an updated version of this plugin to support your use case I think forum.appian.com/.../summary

Sorry harshav, my understanding to your query is wrong.

Hi

Our Web API having input as document , where document having json body.

We are looking for any way to read json data from document having json body?

Regards

Aj

Hi

Thanks for your response,

My web api is getting document from third party, when I try to convert using readTextFromFile() , it is unable to read due to receiving file in binary format.

Any advice to overcome above situation,