@michaellarsen-8252 Thanks for using Microsoft Q&A !!
I do not think you can get this data using REST source in copy data as this is a JSON array of numbers. In order to get this data one approach is to fetch JSON data using HTTP Connector as a source in Copy Data Activity and store this data as a CSV file on a Blob storage as a staging as some scrubbing (removal of '[' ) is required.
You then need to use another Copy Activity to pull from staging to final SQL destination considering input as a csv data file. I have tried in my environment and it worked for me.
You could try this in your environment if this solution works for you. Please find below the GIF for your reference
Please let me know if you have any questions
Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.