Retrieving data from an API and displaying it on Appian

Question

Hi, 
 I have a requirement to call an API that returns a response(REST), and then display the elements in a grid in Appian. 
 I was able to create a process model with a " Call Integration " to which I passed the end-point and request and upon clicking " TEST RESULT " I am able to see the response body( Convert the JSON Response body to an Appian value ) as expected. 
 I want to display this response on a grid and am unsure how to do it. Any help with inputs or links to sources would be highly appreciated. 
 
 Thanks, 
 Subramaniyan J P

aloks0189 · Answer

Hi subramaniyanjp you can follow below mentioned steps to achieve your requirement: 
 
 Return the response in JSON Format via Integration Object 
 Store this response into a process variable of type TEXT 
 Create an Expression Rule having a rule input of type Text (or) Any Type 
 Pass this process variable as an input to this rule 
 Make the use fromJson() to return Dictionary format data out of your JSON and cast it to a CDT array having similar structure(name of the attribute and it's type) as your Dictionary 
 Return the casted CDT array as the response of this Rule 
 Now, because you have the data ready in CDT format, you can easily prepare a grid to display these data. 
 
 Hope this will help you.

Ashwin · Answer

Hello Praveen, 
 
 As you mention that you are new to this and also you are able to get the response from the "call integration" smart service so We want to understand what kind of response is that is it json response cast into CDT? and if yes then we can save the value in process variable(PV) and then we can call that data into form(interface) using User input task and then using grid layout you can display all the value in read only mode as mention by stewart. 
 you can use below link on how to pass values to form(interface) using user input task 
 https://docs.appian.com/suite/help/20.1/Configuring_the_User_Input_Task.html 
 You can use below link to built a read-only grid on interface level 
 https://docs.appian.com/suite/help/20.1/read-only-grid-configuration.html 
 
 Let us know if you need something more. 
 
 Thanks, 
 Ashwin