Share via

Load API data having data Array

Arun Kumar 0 Reputation points
2023-10-06T10:16:24.8966667+00:00

I am fetching the data from API and that have "recipients": [******@xyz.com, @mail.com]. I want to load the data into SQL column rec as complete string separated by "," like "@xyz.com, ******@mail.com".

Community Center | Not monitored
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vahid Ghafarpour 23,605 Reputation points
    2023-10-29T03:32:35.6333333+00:00

    You can use programming language-specific functions to achieve this. For example, in Python, you can use join() to concatenate the elements of the array into a string.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.