Store table data with multiple rows/columns and access from API Gateway

What product/components do you use and which version/fix level are you on?

Is your question related to the free trial, or to a production (customer) instance?

we have licensed customer instance - DEV

What are you trying to achieve? Please describe it in detail.

we want to access table data with multiple rows/columns and fetch the required row based on the condition from wm io API Gateway. Previously we have used AWS Dynamo DB which has option to create a table and store data with multiple rows/columns and fetch any single record based on condition. but the call from wm io API Gateway to AWS Dynamo DB adds the time delay of around 400 ms for turnaround and we are looking for similar option internally in wm io api gateway to improve the performance. Do we have any DB inside wm io?

Do you get any error messages? Please provide a full error message screenshot and log file.

SAG has provided options like account store and reference data but it has lot of limitations and does not fulfill our requirement.
Account store works only for GET calls and reference data is fetching all records but not single record, join condition does not apply.

Have you installed all the latest fixes for the products and systems you are using?

we are using 10.15.0.0.1013 version wm io

Hi @Vinaykumar_Samudrala ,
API Gateway will act as proxy, there are no options to store data in API Gateway.

Regards.