When using the rest connector on the sink side of a copy activity, JSON arrays are not supported. MS docs state "The array of object as the response body is not supported in pagination."
The support for pagination in this senario is really powerful and negates the need to use an until activity iteration with pipeline variables.
Given the prevalence of rest calls returning multiple JSON objects within an array, and the fact that a JSON array is a 'standard' object in itself, can the copy activity add support for this rather than hardcoding the first object in the array? in the mapping
When using the rest connector on the sink side of a copy activity, JSON arrays are not supported. MS docs state "The array of object as the response body is not supported in pagination."
The support for pagination in this senario is really powerful and negates the need to use an until activity iteration with pipeline variables.
Given the prevalence of rest calls returning multiple JSON objects within an array, and the fact that a JSON array is a 'standard' object in itself, can the copy activity add support for this rather than hardcoding the first object in the array? in the mapping