Retrieving data from an API and displaying it on Appian

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.

Hi aloks0001 can you please provide me a reference example for the same? i am new to this.

or any link will be help full for me to achieve this. thanks

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

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

Hi Ashwin,

thanks for the inputs actually what exactly is i want like, need to call an api and get the data from the api and show it in the table.

can you please suggest me how to implement this scenario. 

Thanks,

Praveen