The API column expects a result in a very specific format, and your API doesnât provide that format (not its fault, it wasnât built to work with Glideâs API column). Youâll have to either change the result format of that API, if itâs under your control, or implement a go-between server.
The API column is also meant to just read data, not write it. You canât (or rather, shouldnât) use it to actuate a pump.