Forum Discussion
In the copy activity RestMoreThanOneObjectsReturned Issue.
In the ADF copy activity i am using the TraceGains API that return the data directly in the top level array collection of json like - [ { "id": xxx, "supplierId": 1, ...
Hello NishantGarg​,
this can happen because the API returns a top-level JSON array, while ADF expects a single object.
You can fix it with the following steps:
- In the REST dataset (JSON) enable array handling and set Collection reference = $
- Disable RFC5988 unless the API returns a Link header [rel="next"]
- Use query-parameter pagination only, like page={page} with Range
Let us know how it goes.