We have requirement where we need to pull data from one of the table(Not Relational Database and it is Big Data environment) to our schema or application.
Data will be off appx 90 columns and 15+ column may have defined length of 4000 Char. And At a time it will provide 250+ rows.
We need to pull this data via Appian without doing Databasse to database integration though We just need to dump this data into our schema and landing table.
I am thinking it may have impact on performance of the enviroment or Time out with API call but want to understand if any solution can be done via web API or any other way.
Discussion posts and replies are publicly visible
If you need to call an API, there is 5 MB limit.
.
If you're exposing your database via a Web API, I would recommend implementing some form of pagination to avoid performance issues.