What’s the easiest way to connect to a rest API source and dump the outputs to a CSV flat file with little to no coding done whatsoever?

If it's an API we support with a connector already, then I would suggest using that! (see catalog here). If not, you can request a new connector with this template here. You could also list it on the connector marketplace to get it built for $