I need to connect with a webservice through a REST API, get data and insert that data in a Azure SQL Database. We are using Apache Airflow for that but our engineer is leaving. Finding a replacement has proven to be very hard. Programming skills (Python) are required to work with Apache Airflow.
That is why I am investigating if we use can Datafactory since it requires less programming skills. However, it seems that the REST connector only understands JSON, while our source is delivering XML.
What would be a possible solution getting XML from a REST API using datafactory? That requires little to no programming skills?