Hi @Darren_Murphy ,
I have created APIMutationTemplate column
{ "kind": "add-row-to-table",
"tableName": "native-table-XyL4p8zo4LtMuC61CLBt",
"columnValues": {
"Name": "[{"text":"This is so inspiring! I gave birth 5 months ago and needed to see this because right now trying to find time is hard. This encouraged me to accept my new body , new routine, and get back to myself ❤️","created_at":1728623608,"sentiment":1,"like_count":"","commenter":"meenalmathur22"},{"text":"Love this ❤️❤️🙌","created_at":1728545072,"sentiment":1,"like_count":"","commenter":"jas91minhas"},{"text":"Really inspirational 😍","created_at":1728521934,"sentiment":1,"like_count":"","commenter":"nitijainphotography"},{"text":"I am in awe of you and your journey. Wishing you the best always :)","created_at":1728540534,"sentiment":1,"like_count":"","commenter":"kritibordia"},{"text":"More power to you 😍","created_at":1728535705,"sentiment":0,"like_count":"","commenter":"slow_solorunner"},{"text":"Wowww🔥🔥🔥🔥 in that weather","created_at":1728523995,"sentiment":0,"like_count":"","commenter":"barefoot.suzie"},{"text":"Bro you inspire 😍👏","created_at":1728531753,"sentiment":1,"like_count":"","commenter":"that_pahadii_soul"},{"text":"All in one pack. More power to you ma'am","created_at":1728535780,"sentiment":0,"like_count":"","commenter":"faraah_deebaa"},{"text":"❤️so Inspiring 👏🏻❤️ ma'am","created_at":1728528142,"sentiment":1,"like_count":"","commenter":"natural_yog_fitness"},{"text":"So needed to hear this","created_at":1728495161,"sentiment":0,"like_count":"","commenter":"needlestalk"},{"text":"Aapne ye start kaise kiya 😍","created_at":1728493585,"sentiment":0,"like_count":"","commenter":"himali.soni.965"},{"text":"As always ... U r amazing ❤️🫂 @thatfitmum","created_at":1729303636,"sentiment":1,"like_count":1,"commenter":"nishananiazzz"},{"text":"@nishananiazzz ❤️🫶🏻","created_at":1729316052,"sentiment":0,"like_count":1,"commenter":"thatfitmum"},{"text":"Awesome video and wordings","created_at":1728795394,"sentiment":1,"like_count":0,"commenter":"venkiwrites"},{"text":"Omg! I love you so much!! ❤️❤️ you are such an inspiration :)","created_at":1728722815,"sentiment":1,"like_count":1,"commenter":"swati.chopra3"},{"text":"You’re giving lifestyle and health goals to people Neha. Being a single motherI know how difficult it is to find time for yourself, juggling with emotional and financial responsibilities. Yet I do manage some time for my fitness and things I love doing. Really appreciate your posts; you have no clue how much you’re inspiring your fellow beings!!! More power to you girl.. keep the consistency up!!!! ❤️❤️❤️❤️","created_at":1728706423,"sentiment":1,"like_count":2,"commenter":"the_enchanted_botanistt"},{"text":"❤️❤️👏 super inspiring and much needed at large!","created_at":1728697485,"sentiment":1,"like_count":0,"commenter":"raminder0108"},{"text":"You’re truly an inspiration and motivation to many many of us ❤️❤️❤️ more power to you to keep pushing yourself and us","created_at":1728696715,"sentiment":1,"like_count":0,"commenter":"manasa_praveen"}]",
"45B79": "SentimentScore",
"StVj5": "eebewbew"
}
``` this is the output of it.
It gives Array of comments text in Under key called "Name":
I have next created a joined list of above separated by comma
{
“kind”: “add-row-to-table”,
“tableName”: “native-table-XyL4p8zo4LtMuC61CLBt”,
“columnValues”: {
“Name”: “”,
“45B79”: “SentimentScore”,
“StVj5”: “Doms June 2nd Campaign”
}, {
“kind”: “add-row-to-table”,
“tableName”: “native-table-XyL4p8zo4LtMuC61CLBt”,
“columnValues”: {
“Name”: “”,
“45B79”: “SentimentScore”,
“StVj5”: “Adiga’s Kanakapura Restaurant Opening”
}, {
“kind”: “add-row-to-table”,
“tableName”: “native-table-XyL4p8zo4LtMuC61CLBt”,
“columnValues”: {
“Name”: “”,
“45B79”: “SentimentScore”,
“StVj5”: “Doms June campaign”
}, {
“kind”: “add-row-to-table”,
“tableName”: “native-table-XyL4p8zo4LtMuC61CLBt”,
“columnValues”: {
“Name”: “”,
“45B79”: “SentimentScore”,
“StVj5”: “Bacchus Monsoon Campaign”
}, {
“kind”: “add-row-to-table”,
“tableName”: “native-table-XyL4p8zo4LtMuC61CLBt”,
“columnValues”: {
“Name”: “”,
“45B79”: “SentimentScore”,
“StVj5”: “Pigeon Cookers Monsoon Sale”
}, {
“kind”: “add-row-to-table”,
“tableName”: “native-table-XyL4p8zo4LtMuC61CLBt”,
“columnValues”: {
“Name”: “”,
“45B79”: “SentimentScore”,
“StVj5”: “Iluvia Monsoon Campaign”
}, {
“kind”: “add-row-to-table”,
“tableName”: “native-table-XyL4p8zo4LtMuC61CLBt”,
“columnValues”: {
“Name”: “”,
“45B79”: “SentimentScore”,
“StVj5”: “Monsoon campaign 3”
}, {
“kind”: “add-row-to-table”,
“tableName”: “native-table-XyL4p8zo4LtMuC61CLBt”,
“columnValues”: {
“Name”: “”,
“45B79”: “SentimentScore”,
“StVj5”: “Iluvia Beauty product launch”
}, {
“kind”: “add-row-to-table”,
“tableName”: “native-table-XyL4p8zo4LtMuC61CLBt”,
“columnValues”: {
“Name”: “”,
“45B79”: “SentimentScore”,
“StVj5”: “Iluvia Shampoo launch”
}, {
“kind”: “add-row-to-table”,
“tableName”: “native-table-XyL4p8zo4LtMuC61CLBt”,
“columnValues”: {
“Name”: “”,
“45B79”: “SentimentScore”,
“StVj5”: “Iluvia Skincare product Launch”
}, {
“kind”: “add-row-to-table”,
“tableName”: “native-table-XyL4p8zo4LtMuC61CLBt”,
“columnValues”: {
“Name”: “”,
“45B79”: “SentimentScore”,
“StVj5”: “Pigeon cookers July campaigns”
}, {
“kind”: “add-row-to-table”,
“tableName”: “native-table-XyL4p8zo4LtMuC61CLBt”,
“columnValues”: {
“Name”: “”,
“45B79”: “SentimentScore”,
“StVj5”: “August Launch”
}, {
“kind”: “add-row-to-table”,
“tableName”: “native-table-XyL4p8zo4LtMuC61CLBt”,
“columnValues”: {
“Name”: “”,
“45B79”: “SentimentScore”,
“StVj5”: “test”
}, {
“kind”: “add-row-to-table”,
“tableName”: “native-table-XyL4p8zo4LtMuC61CLBt”,
“columnValues”: {
“Name”: “”,
“45B79”: “SentimentScore”,
“StVj5”: “tenhtrnh”
}, {
“kind”: “add-row-to-table”,
“tableName”: “native-table-XyL4p8zo4LtMuC61CLBt”,
“columnValues”: {
“Name”: “”,
“45B79”: “SentimentScore”,
“StVj5”: " gf vfd df"
}, {
“kind”: “add-row-to-table”,
“tableName”: “native-table-XyL4p8zo4LtMuC61CLBt”,
“columnValues”: {
“Name”: “”,
“45B79”: “SentimentScore”,
“StVj5”: “hrthrtehre”
}, {
“kind”: “add-row-to-table”,
“tableName”: “native-table-XyL4p8zo4LtMuC61CLBt”,
“columnValues”: {
“Name”: “”,
“45B79”: “SentimentScore”,
“StVj5”: “rhrthtrehtre”
}, {
“kind”: “add-row-to-table”,
“tableName”: “native-table-XyL4p8zo4LtMuC61CLBt”,
“columnValues”: {
“Name”: “[{“text”:“This is so inspiring! I gave birth 5 months ago and needed to see this because right now trying to find time is hard. This encouraged me to accept my new body , new routine, and get back to myself
”,“created_at”:1728623608,“sentiment”:1,“like_count”:”“,“commenter”:“meenalmathur22”},{“text”:“Love this ![]()
![]()
”,“created_at”:1728545072,“sentiment”:1,“like_count”:”“,“commenter”:“jas91minhas”},{“text”:“Really inspirational
”,“created_at”:1728521934,“sentiment”:1,“like_count”:”“,“commenter”:“nitijainphotography”},{“text”:“I am in awe of you and your journey. Wishing you the best always :)”,“created_at”:1728540534,“sentiment”:1,“like_count”:”“,“commenter”:“kritibordia”},{“text”:“More power to you
”,“created_at”:1728535705,“sentiment”:0,“like_count”:”“,“commenter”:“slow_solorunner”},{“text”:“Wowww:fire:![]()
![]()
in that weather”,“created_at”:1728523995,“sentiment”:0,“like_count”:”“,“commenter”:“barefoot.suzie”},{“text”:“Bro you inspire ![]()
”,“created_at”:1728531753,“sentiment”:1,“like_count”:”“,“commenter”:“that_pahadii_soul”},{“text”:“All in one pack. More power to you ma’am”,“created_at”:1728535780,“sentiment”:0,“like_count”:”“,“commenter”:“faraah_deebaa”},{“text”:“
so Inspiring ![]()
ma’am”,“created_at”:1728528142,“sentiment”:1,“like_count”:”“,“commenter”:“natural_yog_fitness”},{“text”:“So needed to hear this”,“created_at”:1728495161,“sentiment”:0,“like_count”:”“,“commenter”:“needlestalk”},{“text”:“Aapne ye start kaise kiya
”,“created_at”:1728493585,“sentiment”:0,“like_count”:”“,“commenter”:“himali.soni.965”},{“text”:“As always … U r amazing ![]()
@thatfitmum”,“created_at”:1729303636,“sentiment”:1,“like_count”:1,“commenter”:“nishananiazzz”},{“text”:”@nishananiazzz
🫶🏻",“created_at”:1729316052,“sentiment”:0,“like_count”:1,“commenter”:“thatfitmum”},{“text”:“Awesome video and wordings”,“created_at”:1728795394,“sentiment”:1,“like_count”:0,“commenter”:“venkiwrites”},{“text”:“Omg! I love you so much!! ![]()
you are such an inspiration :)”,“created_at”:1728722815,“sentiment”:1,“like_count”:1,“commenter”:“swati.chopra3”},{“text”:“You’re giving lifestyle and health goals to people Neha. Being a single motherI know how difficult it is to find time for yourself, juggling with emotional and financial responsibilities. Yet I do manage some time for my fitness and things I love doing. Really appreciate your posts; you have no clue how much you’re inspiring your fellow beings!!! More power to you girl… keep the consistency up!!! ![]()
![]()
![]()
”,“created_at”:1728706423,“sentiment”:1,“like_count”:2,“commenter”:“the_enchanted_botanistt”},{“text”:“![]()
![]()
super inspiring and much needed at large!”,“created_at”:1728697485,“sentiment”:1,“like_count”:0,“commenter”:“raminder0108”},{“text”:“You’re truly an inspiration and motivation to many many of us ![]()
![]()
more power to you to keep pushing yourself and us”,“created_at”:1728696715,“sentiment”:1,“like_count”:0,“commenter”:“manasa_praveen”}]“,
“45B79”: “SentimentScore”,
“StVj5”: “eebewbew”
}, {
“kind”: “add-row-to-table”,
“tableName”: “native-table-XyL4p8zo4LtMuC61CLBt”,
“columnValues”: {
“Name”: “[{“text”:“This is so inspiring! I gave birth 5 months ago and needed to see this because right now trying to find time is hard. This encouraged me to accept my new body , new routine, and get back to myself
”,“created_at”:1728623608,“sentiment”:1,“like_count”:””,“commenter”:“meenalmathur22”},{“text”:“Love this ![]()
![]()
”,“created_at”:1728545072,“sentiment”:1,“like_count”:“”,“commenter”:“jas91minhas”},{“text”:“Really inspirational
”,“created_at”:1728521934,“sentiment”:1,“like_count”:“”,“commenter”:“nitijainphotography”},{“text”:“I am in awe of you and your journey. Wishing you the best always :)”,“created_at”:1728540534,“sentiment”:1,“like_count”:“”,“commenter”:“kritibordia”},{“text”:“More power to you
”,“created_at”:1728535705,“sentiment”:0,“like_count”:“”,“commenter”:“slow_solorunner”},{“text”:“Wowww:fire:![]()
![]()
in that weather”,“created_at”:1728523995,“sentiment”:0,“like_count”:“”,“commenter”:“barefoot.suzie”},{“text”:“Bro you inspire ![]()
”,“created_at”:1728531753,“sentiment”:1,“like_count”:“”,“commenter”:“that_pahadii_soul”},{“text”:“All in one pack. More power to you ma’am”,“created_at”:1728535780,“sentiment”:0,“like_count”:“”,“commenter”:“faraah_deebaa”},{“text”:“
so Inspiring ![]()
ma’am”,“created_at”:1728528142,“sentiment”:1,“like_count”:“”,“commenter”:“natural_yog_fitness”},{“text”:“So needed to hear this”,“created_at”:1728495161,“sentiment”:0,“like_count”:“”,“commenter”:“needlestalk”},{“text”:“Aapne ye start kaise kiya
”,“created_at”:1728493585,“sentiment”:0,“like_count”:“”,“commenter”:“himali.soni.965”},{“text”:“As always … U r amazing ![]()
@thatfitmum”,“created_at”:1729303636,“sentiment”:1,“like_count”:1,“commenter”:“nishananiazzz”},{“text”:“@nishananiazzz
🫶🏻”,“created_at”:1729316052,“sentiment”:0,“like_count”:1,“commenter”:“thatfitmum”},{“text”:“Awesome video and wordings”,“created_at”:1728795394,“sentiment”:1,“like_count”:0,“commenter”:“venkiwrites”},{“text”:“Omg! I love you so much!! ![]()
you are such an inspiration :)”,“created_at”:1728722815,“sentiment”:1,“like_count”:1,“commenter”:“swati.chopra3”},{“text”:“You’re giving lifestyle and health goals to people Neha. Being a single motherI know how difficult it is to find time for yourself, juggling with emotional and financial responsibilities. Yet I do manage some time for my fitness and things I love doing. Really appreciate your posts; you have no clue how much you’re inspiring your fellow beings!!! More power to you girl… keep the consistency up!!! ![]()
![]()
![]()
”,“created_at”:1728706423,“sentiment”:1,“like_count”:2,“commenter”:“the_enchanted_botanistt”},{“text”:“![]()
![]()
super inspiring and much needed at large!”,“created_at”:1728697485,“sentiment”:1,“like_count”:0,“commenter”:“raminder0108”},{“text”:“You’re truly an inspiration and motivation to many many of us ![]()
![]()
more power to you to keep pushing yourself and us”,“created_at”:1728696715,“sentiment”:1,“like_count”:0,“commenter”:“manasa_praveen”}]",
“45B79”: “SentimentScore”,
“StVj5”: “Testing Saree Campaign”
}
What can I do so that it adds only the comment text and “sentiment”: to another row along with campaign name.
let me know if you need images of my columns for better understanding
Regards,
Dilip