External Database through API

Hello I am new to Wix and am need of some help. I have the need to make a dynamic table displayed on my website that is linked to an external database. I have a database in AWS DynamoDB that is updated daily for which I have created an API for. The API can be called by https://… (redacted) and the output is in json format. I have tried creating an external database on Wix but each time it fails with error: "Unable to fetch result Connector with namespace “test” and instance id “(list of numbers and strings” fails provision request. I don’t know how to fix this issue. A sample output is attached.