I am trying to use data factory to get some ddata from a REST api that returns a JSON array.
Data factory insists it cannot read the response even though it is a proper JSON array being returned.
I am using the copy data activity with the REST source.
It should end in an SQL sink but neveer reaches that point.
The source url is https://esi.evetech.net/latest/alliances/?datasource=tranquility giving a response of [99000006,99000008,99000025,99000026,99000036,99000050.......]
Ho do I go about reading the response and saving it a database?