Api advice from yaml file

Hi looking for advice really, i need to host an api that one of our suppliers can put data to, they have provided me the open api config required as a yaml file.

is there a way i can use this in retool, ideally in a workflow? or do i need to host api elsewhere and then call it as an openapi resource?

I need to take the data send to me and then put it into an api call that i have working in retool already , so was thinking of doing something in a work flow.

any advice would be awesome , if i do need to find an api gateway ,some recommendations would be great.

Hello @northdevon!

Ok interesting question.

It sounds like rather than hosting an API, you are looking to host a backend server, which connects to and controls a database, which suppliers are able to interact with to get, upload and search for data using an API :sweat_smile:

A workflow is a good idea for implementing this. As workflows have a URL that requests can be made to. This way both your Retool app and other users such as suppliers are able to send in requests for data and for data related actions to the workflow.

With a workflow you can build out the automated logic to handle making the queries to the Resource. With the resource making the api calls/queries to that you currently have working in Retool already.

I would highly recommend going over our workflows docs, walking through the examples so you understand the flow of events to best set up the architecture to receive and handle requests appropriately!

Those docs will help you understand how to accomplish the actions you are looking to implement.

I would say that using ChatGPT to break down and understand the YAML file and then using the Retool AI bot(purple icon in bottom right of Workflow queries) to help with the technical details of implementing the API routes and data processing will be helpful for your usecase!