Import Rest API Data into SQL server using Azure Data Factory (ADF)
Paiement à la livraison
I have REST API and I need to import the data into a Azure SQL Server table.
I am using Azure Data Factory Data flow (attached) which was working fine but as the data grew I started getting the below error
Azure data factory REST API Job aborted due to stage failure: Serialized task 16:0 was bytes, which exceeds max allowed: [login to view URL] (134217728 bytes).
So I had to split the source API data into two parts using $top and $skip
Like below, two URL calls.
I am looking for efficient way of doing it by using for loop or parametrization or anything which makes it work even if the data further grows.
Example API data : [login to view URL]$expand=Trips
If you can use above api and import all the data fields into SQL server.
Nº du projet : #37514388
À propos du projet
12 freelances font une offre moyenne de 43 $ pour ce travail
I read your requirement for Azure Data Factory. I will check your REST API data and help you to resolve your problem. I have good experience in import data at SQL Server. You can view my profile for completed project Plus
Hello I understand your request that you’re demanding Import Rest API Data into SQL server using Azure Data Factory (ADF) As a Professional Geeks, I can avail creative, proactive and high-tech solutions to your devel Plus