Hi @Darren_Murphy ,
Isn’t the miracle method bit of an issue in terms of feasibility ?
I might be getting in new row added every minute. how do we handle it then?
This way whatever blank row I create will run off very soon right ?
Regards,
Dilip
I don’t really know what you mean.
There may be situations where the Miracle Method isn’t appropriate, but it’s an incredibly useful technique to have in your Glide Toolbox. I use variations of it in almost every App that I create.
1 Like
Thank you for replying.
Scenario
We are making an API call, There maybe N number of elements in the array right ? We may never really know how many rows should be there in helper table. As and when the API keeps getting called new rows have to be created without knowing which might be the increase in the data coming.
How can we handle such a situation? It’s a situation where we would ideally want new rows to be created dynamically right?
Regards
Dilip
I’ve split this into a separate topic.
Why can’t you just add more rows than you are likely to need?
There is no reason why you can’t add 1000 rows (or more) to a helper table.
Thank you @Darren_Murphy for creating a seperate thread, Was just about to ask you.
I can add rows, But what if I am getting like new data every minute.
It means I’ll have to create like 1000 rows every day. That would be sort of cumbersome right?
is there a way we can dynamically create it? Meaning whenever new data comes it will automatically add a row?
I have tried doing this by using make
Was wondering wether I can do this without make?
let me know if you need more explanation from my end.
Regards,
Dilip
I think I need to understand your use case better before I can make any further comment.
What are you actually doing with this data?
My use case is as follows.
I have a 3rd party which does reporting for me, it gives me campaign stats, Sentimental analysis (It reads comments on my posts and gives me sentimental analysis)
I have a list of campaigns, I am calling an API every day morning to fetch the JSON in which there will be all the data including Array of comments and sentiment score for each campaign.
When I query and parse the data I will be able to get all comments in one column’s cell.
But Using the miracle method I can write each item of array into a seperate row right ?
But for that I would have to keep adding extra rows in the table so that they keep getting written to inidivudal rows rather than everything in single cell
For my use case it becomes cumbersome right?
Let me know if this gives better clarity?
Sorry I might not be good in explaining things.
Thank you for your patience.
Regards,
Dilip
The idea with a Helper Table is that it doesn’t contain any permanent data.
If I understand correctly, you should be using the Helper Table to parse the data, prepare a bunch of mutations, and then use Call API or Make to add new rows to some other table.
So as long as you have enough rows to cater for the maximum number of comments you would expect on any one day, then that’s all you need.
1 Like
Hi @Darren_Murphy ,
Thank you for your reply.
Are you proposing to do something like this ?
Where I store responses of all campaigns in mutations and then make use of it and write in separate rows?
ill give it a try today and ask you questions if I have any doubt?
Thank you for providing this Idea. if it works then I dont have to make use of make.
Regards,
Dilip
Yes. The idea is to have a fixed number of rows in your helper table, and you use the same rows over and over again as a staging area for adding rows to some other table.
Hi @Darren_Murphy ,
Correct me if I am wrong In following these steps
I have list of campaigns → Against each campaign column I have the response that comes from the API it will have the JSON
What I should do
- Create the joined List of all the response of call campaigns separated by comma
- Put it into my helped table by doing single value column fetch
- Then try to call add API to add them into new table as individual rows?
Am I correct?
Also one more question I have is:
There will be array of comments and sentiment score in each response body.
They have to be linked to respective campaign name.
How can I do this? I am able to Do JSOn query to get the name of the campaign from response body.
Here is an example of ,my response body
It is from one campaign
{"status":"live","share_url":"https://insights.ylytic.com/campaign?id=671f92816267c014acf994fe","start_date":null,"connectors":["instagram"],"posts_count":1,"creators_count":1,"reach":105733,"views":117482,"followers":323966,"comments":158,"likes":3153,"engagement":3311,"er":1.02,"erv":2.82,"top_posts":[{"connector":"instagram","shortcode":"DA6AeOgND_Y","comments_count":158,"likes_count":3153,"post_type":"REEL","title":"To me self care is strength, fitness & growth.\nI prioritise peace and choose to push boundaries everyday\nI move for the mind to keep my sprint happy.\nPick a sport, hustle everyday, #feeltheshift & gear up with @decathlonsportsindia\n\n#momonthego #worldmentalhealthday #worldmentalhealthday2024 #mentalhealthday2024 #mentalheakthawareness #mentalhealthawarenessweek #junoonmeinsukoonhai #bemore #chooseyourmentalhealth #decathalonsportsindia #decathalonindia #selfcarematters #mentalhealthmatters #ad","description":"To me self care is strength, fitness & growth.\nI prioritise peace and choose to push boundaries everyday\nI move for the mind to keep my sprint happy.\nPick a sport, hustle everyday, #feeltheshift & gear up with @decathlonsportsindia\n\n#momonthego #worldmentalhealthday #worldmentalhealthday2024 #mentalhealthday2024 #mentalheakthawareness #mentalhealthawarenessweek #junoonmeinsukoonhai #bemore #chooseyourmentalhealth #decathalonsportsindia #decathalonindia #selfcarematters #mentalhealthmatters #ad","hashtags":["#feeltheshift","#momonthego","#worldmentalhealthday","#worldmentalhealthday2024","#mentalhealthday2024","#mentalheakthawareness","#mentalhealthawarenessweek","#junoonmeinsukoonhai","#bemore","#chooseyourmentalhealth","#decathalonsportsindia","#decathalonindia","#selfcarematters","#mentalhealthmatters","#ad"],"creator":{"handle":"thatfitmum","url":"https://www.instagram.com/thatfitmum","full_name":"Neha Bangia","follower_count":323966,"media_count":1254,"connector":"instagram"},"posted_date":"Wed, 09 Oct 2024 14:17:41 GMT","post_url":"https://www.instagram.com/p/DA6AeOgND_Y/","image_url":"https://s3.ap-south-1.amazonaws.com/nudges//tmp/DA6AeOgND_Y.jpg","display_url":"https://s3.ap-south-1.amazonaws.com/nudges//tmp/DA6AeOgND_Y.jpg","reach":105733,"views":117482,"er":1.02,"saved":null,"shares":null,"comments":[{"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 \u2764\ufe0f","created_at":1728623608,"sentiment":1,"like_count":"","commenter":"meenalmathur22"},{"text":"Love this \u2764\ufe0f\u2764\ufe0f\ud83d\ude4c","created_at":1728545072,"sentiment":1,"like_count":"","commenter":"jas91minhas"},{"text":"Really inspirational \ud83d\ude0d","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 \ud83d\ude0d","created_at":1728535705,"sentiment":0,"like_count":"","commenter":"slow_solorunner"},{"text":"Wowww\ud83d\udd25\ud83d\udd25\ud83d\udd25\ud83d\udd25 in that weather","created_at":1728523995,"sentiment":0,"like_count":"","commenter":"barefoot.suzie"},{"text":"Bro you inspire \ud83d\ude0d\ud83d\udc4f","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":"\u2764\ufe0fso Inspiring \ud83d\udc4f\ud83c\udffb\u2764\ufe0f 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 \ud83d\ude0d","created_at":1728493585,"sentiment":0,"like_count":"","commenter":"himali.soni.965"},{"text":"As always ... U r amazing \u2764\ufe0f\ud83e\udec2 @thatfitmum","created_at":1729303636,"sentiment":1,"like_count":1,"commenter":"nishananiazzz"},{"text":"@nishananiazzz \u2764\ufe0f\ud83e\udef6\ud83c\udffb","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!! \u2764\ufe0f\u2764\ufe0f you are such an inspiration :)","created_at":1728722815,"sentiment":1,"like_count":1,"commenter":"swati.chopra3"},{"text":"You\u2019re 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\u2019re inspiring your fellow beings!!! More power to you girl.. keep the consistency up!!!! \u2764\ufe0f\u2764\ufe0f\u2764\ufe0f\u2764\ufe0f","created_at":1728706423,"sentiment":1,"like_count":2,"commenter":"the_enchanted_botanistt"},{"text":"\u2764\ufe0f\u2764\ufe0f\ud83d\udc4f super inspiring and much needed at large!","created_at":1728697485,"sentiment":1,"like_count":0,"commenter":"raminder0108"},{"text":"You\u2019re truly an inspiration and motivation to many many of us \u2764\ufe0f\u2764\ufe0f\u2764\ufe0f more power to you to keep pushing yourself and us","created_at":1728696715,"sentiment":1,"like_count":0,"commenter":"manasa_praveen"}],"commentors":[{"username":"meenalmathur22","connector":"instagram"},{"username":"sharmashipra275","connector":"instagram"},{"username":"yogaa.live","connector":"instagram"},{"username":"astha.sahani2018","connector":"instagram"},{"username":"jas91minhas","connector":"instagram"},{"username":"nitijainphotography","connector":"instagram"},{"username":"officialthepk","connector":"instagram"},{"username":"kritibordia","connector":"instagram"},{"username":"slow_solorunner","connector":"instagram"},{"username":"barefoot.suzie","connector":"instagram"},{"username":"that_pahadii_soul","connector":"instagram"},{"username":"faraah_deebaa","connector":"instagram"},{"username":"natural_yog_fitness","connector":"instagram"},{"username":"needlestalk","connector":"instagram"},{"username":"himali.soni.965","connector":"instagram"},{"username":"nishananiazzz","connector":"instagram"},{"username":"thatfitmum","connector":"instagram"},{"username":"consciousapien_07","connector":"instagram"},{"username":"venkiwrites","connector":"instagram"},{"username":"swati.chopra3","connector":"instagram"},{"username":"the_enchanted_botanistt","connector":"instagram"},{"username":"raminder0108","connector":"instagram"},{"username":"manasa_praveen","connector":"instagram"}],"refresh_date":"Tue, 29 Oct 2024 01:00:15 GMT","cpr":0.0,"cpv":0.0,"shortlink":null,"cost":0,"affiliate_orders_count":null,"affiliate_orders_amount":null,"shortlinks_analysis":null,"erv":2.82}],"posts":[{"connector":"instagram","shortcode":"DA6AeOgND_Y","comments_count":158,"likes_count":3153,"post_type":"REEL","title":"To me self care is strength, fitness & growth.\nI prioritise peace and choose to push boundaries everyday\nI move for the mind to keep my sprint happy.\nPick a sport, hustle everyday, #feeltheshift & gear up with @decathlonsportsindia\n\n#momonthego #worldmentalhealthday #worldmentalhealthday2024 #mentalhealthday2024 #mentalheakthawareness #mentalhealthawarenessweek #junoonmeinsukoonhai #bemore #chooseyourmentalhealth #decathalonsportsindia #decathalonindia #selfcarematters #mentalhealthmatters #ad","description":"To me self care is strength, fitness & growth.\nI prioritise peace and choose to push boundaries everyday\nI move for the mind to keep my sprint happy.\nPick a sport, hustle everyday, #feeltheshift & gear up with @decathlonsportsindia\n\n#momonthego #worldmentalhealthday #worldmentalhealthday2024 #mentalhealthday2024 #mentalheakthawareness #mentalhealthawarenessweek #junoonmeinsukoonhai #bemore #chooseyourmentalhealth #decathalonsportsindia #decathalonindia #selfcarematters #mentalhealthmatters #ad","hashtags":["#feeltheshift","#momonthego","#worldmentalhealthday","#worldmentalhealthday2024","#mentalhealthday2024","#mentalheakthawareness","#mentalhealthawarenessweek","#junoonmeinsukoonhai","#bemore","#chooseyourmentalhealth","#decathalonsportsindia","#decathalonindia","#selfcarematters","#mentalhealthmatters","#ad"],"creator":{"handle":"thatfitmum","url":"https://www.instagram.com/thatfitmum","full_name":"Neha Bangia","follower_count":323966,"media_count":1254,"connector":"instagram"},"posted_date":"Wed, 09 Oct 2024 14:17:41 GMT","post_url":"https://www.instagram.com/p/DA6AeOgND_Y/","image_url":"https://s3.ap-south-1.amazonaws.com/nudges//tmp/DA6AeOgND_Y.jpg","display_url":"https://s3.ap-south-1.amazonaws.com/nudges//tmp/DA6AeOgND_Y.jpg","reach":105733,"views":117482,"er":1.02,"saved":null,"shares":null,"comments":[{"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 \u2764\ufe0f","created_at":1728623608,"sentiment":1,"like_count":"","commenter":"meenalmathur22"},{"text":"Love this \u2764\ufe0f\u2764\ufe0f\ud83d\ude4c","created_at":1728545072,"sentiment":1,"like_count":"","commenter":"jas91minhas"},{"text":"Really inspirational \ud83d\ude0d","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 \ud83d\ude0d","created_at":1728535705,"sentiment":0,"like_count":"","commenter":"slow_solorunner"},{"text":"Wowww\ud83d\udd25\ud83d\udd25\ud83d\udd25\ud83d\udd25 in that weather","created_at":1728523995,"sentiment":0,"like_count":"","commenter":"barefoot.suzie"},{"text":"Bro you inspire \ud83d\ude0d\ud83d\udc4f","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":"\u2764\ufe0fso Inspiring \ud83d\udc4f\ud83c\udffb\u2764\ufe0f 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 \ud83d\ude0d","created_at":1728493585,"sentiment":0,"like_count":"","commenter":"himali.soni.965"},{"text":"As always ... U r amazing \u2764\ufe0f\ud83e\udec2 @thatfitmum","created_at":1729303636,"sentiment":1,"like_count":1,"commenter":"nishananiazzz"},{"text":"@nishananiazzz \u2764\ufe0f\ud83e\udef6\ud83c\udffb","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!! \u2764\ufe0f\u2764\ufe0f you are such an inspiration :)","created_at":1728722815,"sentiment":1,"like_count":1,"commenter":"swati.chopra3"},{"text":"You\u2019re 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\u2019re inspiring your fellow beings!!! More power to you girl.. keep the consistency up!!!! \u2764\ufe0f\u2764\ufe0f\u2764\ufe0f\u2764\ufe0f","created_at":1728706423,"sentiment":1,"like_count":2,"commenter":"the_enchanted_botanistt"},{"text":"\u2764\ufe0f\u2764\ufe0f\ud83d\udc4f super inspiring and much needed at large!","created_at":1728697485,"sentiment":1,"like_count":0,"commenter":"raminder0108"},{"text":"You\u2019re truly an inspiration and motivation to many many of us \u2764\ufe0f\u2764\ufe0f\u2764\ufe0f more power to you to keep pushing yourself and us","created_at":1728696715,"sentiment":1,"like_count":0,"commenter":"manasa_praveen"}],"commentors":[{"username":"meenalmathur22","connector":"instagram"},{"username":"sharmashipra275","connector":"instagram"},{"username":"yogaa.live","connector":"instagram"},{"username":"astha.sahani2018","connector":"instagram"},{"username":"jas91minhas","connector":"instagram"},{"username":"nitijainphotography","connector":"instagram"},{"username":"officialthepk","connector":"instagram"},{"username":"kritibordia","connector":"instagram"},{"username":"slow_solorunner","connector":"instagram"},{"username":"barefoot.suzie","connector":"instagram"},{"username":"that_pahadii_soul","connector":"instagram"},{"username":"faraah_deebaa","connector":"instagram"},{"username":"natural_yog_fitness","connector":"instagram"},{"username":"needlestalk","connector":"instagram"},{"username":"himali.soni.965","connector":"instagram"},{"username":"nishananiazzz","connector":"instagram"},{"username":"thatfitmum","connector":"instagram"},{"username":"consciousapien_07","connector":"instagram"},{"username":"venkiwrites","connector":"instagram"},{"username":"swati.chopra3","connector":"instagram"},{"username":"the_enchanted_botanistt","connector":"instagram"},{"username":"raminder0108","connector":"instagram"},{"username":"manasa_praveen","connector":"instagram"}],"refresh_date":"Tue, 29 Oct 2024 01:00:15 GMT","cpr":0.0,"cpv":0.0,"shortlink":null,"cost":0,"affiliate_orders_count":null,"affiliate_orders_amount":null,"shortlinks_analysis":null,"erv":2.82}],"all_comments":[{"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 \u2764\ufe0f","created_at":1728623608,"sentiment":1,"like_count":"","commenter":"meenalmathur22"},{"text":"Love this \u2764\ufe0f\u2764\ufe0f\ud83d\ude4c","created_at":1728545072,"sentiment":1,"like_count":"","commenter":"jas91minhas"},{"text":"Really inspirational \ud83d\ude0d","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 \ud83d\ude0d","created_at":1728535705,"sentiment":0,"like_count":"","commenter":"slow_solorunner"},{"text":"Wowww\ud83d\udd25\ud83d\udd25\ud83d\udd25\ud83d\udd25 in that weather","created_at":1728523995,"sentiment":0,"like_count":"","commenter":"barefoot.suzie"},{"text":"Bro you inspire \ud83d\ude0d\ud83d\udc4f","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":"\u2764\ufe0fso Inspiring \ud83d\udc4f\ud83c\udffb\u2764\ufe0f 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 \ud83d\ude0d","created_at":1728493585,"sentiment":0,"like_count":"","commenter":"himali.soni.965"},{"text":"As always ... U r amazing \u2764\ufe0f\ud83e\udec2 @thatfitmum","created_at":1729303636,"sentiment":1,"like_count":1,"commenter":"nishananiazzz"},{"text":"@nishananiazzz \u2764\ufe0f\ud83e\udef6\ud83c\udffb","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!! \u2764\ufe0f\u2764\ufe0f you are such an inspiration :)","created_at":1728722815,"sentiment":1,"like_count":1,"commenter":"swati.chopra3"},{"text":"You\u2019re 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\u2019re inspiring your fellow beings!!! More power to you girl.. keep the consistency up!!!! \u2764\ufe0f\u2764\ufe0f\u2764\ufe0f\u2764\ufe0f","created_at":1728706423,"sentiment":1,"like_count":2,"commenter":"the_enchanted_botanistt"},{"text":"\u2764\ufe0f\u2764\ufe0f\ud83d\udc4f super inspiring and much needed at large!","created_at":1728697485,"sentiment":1,"like_count":0,"commenter":"raminder0108"},{"text":"You\u2019re truly an inspiration and motivation to many many of us \u2764\ufe0f\u2764\ufe0f\u2764\ufe0f more power to you to keep pushing yourself and us","created_at":1728696715,"sentiment":1,"like_count":0,"commenter":"manasa_praveen"}],"word_cloud":[{"text":"power","value":4},{"text":"needed","value":3},{"text":"time","value":3},{"text":"love","value":3},{"text":"inspiring","value":3},{"text":"you\u2019re","value":3},{"text":":)","value":2},{"text":"ma'am","value":2},{"text":"\ud83c\udffb","value":2},{"text":"inspiration","value":2},{"text":"inspiring!","value":1},{"text":"birth","value":1},{"text":"5","value":1},{"text":"months","value":1},{"text":"ago","value":1},{"text":"hard","value":1},{"text":"encouraged","value":1},{"text":"accept","value":1},{"text":"body","value":1},{"text":"routine","value":1},{"text":"inspirational","value":1},{"text":"awe","value":1},{"text":"journey","value":1},{"text":"wishing","value":1},{"text":"wowww","value":1},{"text":"weather","value":1},{"text":"bro","value":1},{"text":"inspire","value":1},{"text":"pack","value":1},{"text":"hear","value":1},{"text":"aapne","value":1},{"text":"ye","value":1},{"text":"start","value":1},{"text":"kaise","value":1},{"text":"kiya","value":1},{"text":"amazing","value":1},{"text":"thatfitmum","value":1},{"text":"nishananiazzz","value":1},{"text":"awesome","value":1},{"text":"video","value":1},{"text":"wordings","value":1},{"text":"omg!","value":1},{"text":"much!!","value":1},{"text":"lifestyle","value":1},{"text":"health","value":1},{"text":"goals","value":1},{"text":"people","value":1},{"text":"neha","value":1},{"text":"single","value":1},{"text":"motheri","value":1},{"text":"difficult","value":1},{"text":"juggling","value":1},{"text":"emotional","value":1},{"text":"financial","value":1},{"text":"responsibilities","value":1},{"text":"manage","value":1},{"text":"fitness","value":1},{"text":"things","value":1},{"text":"posts;","value":1},{"text":"clue","value":1},{"text":"fellow","value":1},{"text":"beings!!!","value":1},{"text":"girl","value":1},{"text":"consistency","value":1},{"text":"up!!!!","value":1},{"text":"super","value":1},{"text":"large!","value":1},{"text":"motivation","value":1},{"text":"pushing","value":1}],"age_gender_distribution":null,"audience":{"age_group_distribution":null,"age_gender_distribution":null,"gender_distribution":{"male":52,"female":48},"city_distribution":{"Others":100.0},"top":{"gender":"Male","gender_per":52,"age_group":"18-24","age_group_per":0,"location":"","location_per":0,"country":""},"comments_sentiment_analysis":{"comments":[{"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 \u2764\ufe0f","created_at":1728623608,"sentiment":1,"like_count":"","commenter":"meenalmathur22"},{"text":"Love this \u2764\ufe0f\u2764\ufe0f\ud83d\ude4c","created_at":1728545072,"sentiment":1,"like_count":"","commenter":"jas91minhas"},{"text":"Really inspirational \ud83d\ude0d","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 \ud83d\ude0d","created_at":1728535705,"sentiment":0,"like_count":"","commenter":"slow_solorunner"},{"text":"Wowww\ud83d\udd25\ud83d\udd25\ud83d\udd25\ud83d\udd25 in that weather","created_at":1728523995,"sentiment":0,"like_count":"","commenter":"barefoot.suzie"},{"text":"Bro you inspire \ud83d\ude0d\ud83d\udc4f","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":"\u2764\ufe0fso Inspiring \ud83d\udc4f\ud83c\udffb\u2764\ufe0f 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 \ud83d\ude0d","created_at":1728493585,"sentiment":0,"like_count":"","commenter":"himali.soni.965"},{"text":"As always ... U r amazing \u2764\ufe0f\ud83e\udec2 @thatfitmum","created_at":1729303636,"sentiment":1,"like_count":1,"commenter":"nishananiazzz"},{"text":"@nishananiazzz \u2764\ufe0f\ud83e\udef6\ud83c\udffb","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!! \u2764\ufe0f\u2764\ufe0f you are such an inspiration :)","created_at":1728722815,"sentiment":1,"like_count":1,"commenter":"swati.chopra3"},{"text":"You\u2019re 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\u2019re inspiring your fellow beings!!! More power to you girl.. keep the consistency up!!!! \u2764\ufe0f\u2764\ufe0f\u2764\ufe0f\u2764\ufe0f","created_at":1728706423,"sentiment":1,"like_count":2,"commenter":"the_enchanted_botanistt"},{"text":"\u2764\ufe0f\u2764\ufe0f\ud83d\udc4f super inspiring and much needed at large!","created_at":1728697485,"sentiment":1,"like_count":0,"commenter":"raminder0108"},{"text":"You\u2019re truly an inspiration and motivation to many many of us \u2764\ufe0f\u2764\ufe0f\u2764\ufe0f more power to you to keep pushing yourself and us","created_at":1728696715,"sentiment":1,"like_count":0,"commenter":"manasa_praveen"}],"total_comments":18,"sentiment":{"positives":66,"negatives":0,"neutral":33},"word_cloud":[{"text":"power","value":4},{"text":"needed","value":3},{"text":"time","value":3},{"text":"love","value":3},{"text":"inspiring","value":3},{"text":"you\u2019re","value":3},{"text":":)","value":2},{"text":"ma'am","value":2},{"text":"\ud83c\udffb","value":2},{"text":"inspiration","value":2},{"text":"inspiring!","value":1},{"text":"birth","value":1},{"text":"5","value":1},{"text":"months","value":1},{"text":"ago","value":1},{"text":"hard","value":1},{"text":"encouraged","value":1},{"text":"accept","value":1},{"text":"body","value":1},{"text":"routine","value":1},{"text":"inspirational","value":1},{"text":"awe","value":1},{"text":"journey","value":1},{"text":"wishing","value":1},{"text":"wowww","value":1},{"text":"weather","value":1},{"text":"bro","value":1},{"text":"inspire","value":1},{"text":"pack","value":1},{"text":"hear","value":1},{"text":"aapne","value":1},{"text":"ye","value":1},{"text":"start","value":1},{"text":"kaise","value":1},{"text":"kiya","value":1},{"text":"amazing","value":1},{"text":"thatfitmum","value":1},{"text":"nishananiazzz","value":1},{"text":"awesome","value":1},{"text":"video","value":1},{"text":"wordings","value":1},{"text":"omg!","value":1},{"text":"much!!","value":1},{"text":"lifestyle","value":1},{"text":"health","value":1},{"text":"goals","value":1},{"text":"people","value":1},{"text":"neha","value":1},{"text":"single","value":1},{"text":"motheri","value":1},{"text":"difficult","value":1},{"text":"juggling","value":1},{"text":"emotional","value":1},{"text":"financial","value":1},{"text":"responsibilities","value":1},{"text":"manage","value":1},{"text":"fitness","value":1},{"text":"things","value":1},{"text":"posts;","value":1},{"text":"clue","value":1},{"text":"fellow","value":1},{"text":"beings!!!","value":1},{"text":"girl","value":1},{"text":"consistency","value":1},{"text":"up!!!!","value":1},{"text":"super","value":1},{"text":"large!","value":1},{"text":"motivation","value":1},{"text":"pushing","value":1}]}},"reach_trends":[{"2024-10-29":{"reach":105733}}],"engagement_trends":[{"2024-10-29":{"engagement":1.02}}],"views_trends":[{"2024-10-29":{"views":117482}}],"cumulative_engagement_trends":[{"2024-10-29":{"engagement":3311}}],"cumulative_erv_trends":[{"2024-10-29":{"erv":[2.82]}}],"hashtag_insights":null,"hashtag_overview":{"total_reach":0,"total_post_count":0,"total_views":0,"cpr":0,"cpv":0},"hashtags":["#ad","#decathalonindia","#feeltheshift","#chooseyourmentalhealth","#momonthego","#mentalhealthday2024","#selfcarematters","#worldmentalhealthday","#mentalhealthmatters","#mentalheakthawareness","#mentalhealthawarenessweek","#bemore","#junoonmeinsukoonhai","#worldmentalhealthday2024","#decathalonsportsindia"],"saved":0,"shares":0,"total_affiliate_orders_count":0,"total_affiliate_orders_amount":0,"cost_of_campaign":0,"custom_field_name":null,"insights_refreshed_at":"Tue, 29 Oct 2024 05:01:02 GMT","custom_field_value":null,"name":"Testing Saree Campaign","brand_name":"Kay Sarees","brand_logo_url":"https://img.icons8.com/ios/512/no-image.png","client_name":"Aflog","client_logo_url":"https://ylytic.s3.ap-south-1.amazonaws.com/uploads/fe200de4-1cdc-4ce9-81e1-1980180db96f.jpeg","insights_link":"https://insights.ylytic.com/campaign?id=671f92816267c014acf994fe","threshold_reach":null,"threshold_er":null}
Thank you in advance for your help.
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
Hi @Darren_Murphy ,
I used some Java script code and was able to generate Mutations as follows
{
"appID": "cnDHhD0ZHdBFK7M7qY32",
"mutations": [{"kind":"add-row-to-table","tableName":"native-table-jWEMMuChAFBW3berD6UM","columnValues":{"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 ❤️","sentiment":1}},{"kind":"add-row-to-table","tableName":"native-table-jWEMMuChAFBW3berD6UM","columnValues":{"text":"Love this ❤️❤️🙌","sentiment":1}},{"kind":"add-row-to-table","tableName":"native-table-jWEMMuChAFBW3berD6UM","columnValues":{"text":"Really inspirational 😍","sentiment":1}},{"kind":"add-row-to-table","tableName":"native-table-jWEMMuChAFBW3berD6UM","columnValues":{"text":"I am in awe of you and your journey. Wishing you the best always :)","sentiment":1}},{"kind":"add-row-to-table","tableName":"native-table-jWEMMuChAFBW3berD6UM","columnValues":{"text":"More power to you 😍","sentiment":""}},{"kind":"add-row-to-table","tableName":"native-table-jWEMMuChAFBW3berD6UM","columnValues":{"text":"Wowww🔥🔥🔥🔥 in that weather","sentiment":""}},{"kind":"add-row-to-table","tableName":"native-table-jWEMMuChAFBW3berD6UM","columnValues":{"text":"Bro you inspire 😍👏","sentiment":1}},{"kind":"add-row-to-table","tableName":"native-table-jWEMMuChAFBW3berD6UM","columnValues":{"text":"All in one pack. More power to you ma'am","sentiment":""}},{"kind":"add-row-to-table","tableName":"native-table-jWEMMuChAFBW3berD6UM","columnValues":{"text":"❤️so Inspiring 👏🏻❤️ ma'am","sentiment":1}},{"kind":"add-row-to-table","tableName":"native-table-jWEMMuChAFBW3berD6UM","columnValues":{"text":"So needed to hear this","sentiment":""}},{"kind":"add-row-to-table","tableName":"native-table-jWEMMuChAFBW3berD6UM","columnValues":{"text":"Aapne ye start kaise kiya 😍","sentiment":""}},{"kind":"add-row-to-table","tableName":"native-table-jWEMMuChAFBW3berD6UM","columnValues":{"text":"As always ... U r amazing ❤️🫂 @thatfitmum","sentiment":1}},{"kind":"add-row-to-table","tableName":"native-table-jWEMMuChAFBW3berD6UM","columnValues":{"text":"@nishananiazzz ❤️🫶🏻","sentiment":""}},{"kind":"add-row-to-table","tableName":"native-table-jWEMMuChAFBW3berD6UM","columnValues":{"text":"Awesome video and wordings","sentiment":1}},{"kind":"add-row-to-table","tableName":"native-table-jWEMMuChAFBW3berD6UM","columnValues":{"text":"Omg! I love you so much!! ❤️❤️ you are such an inspiration :)","sentiment":1}},{"kind":"add-row-to-table","tableName":"native-table-jWEMMuChAFBW3berD6UM","columnValues":{"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!!!! ❤️❤️❤️❤️","sentiment":1}},{"kind":"add-row-to-table","tableName":"native-table-jWEMMuChAFBW3berD6UM","columnValues":{"text":"❤️❤️👏 super inspiring and much needed at large!","sentiment":1}},{"kind":"add-row-to-table","tableName":"native-table-jWEMMuChAFBW3berD6UM","columnValues":{"text":"You’re truly an inspiration and motivation to many many of us ❤️❤️❤️ more power to you to keep pushing yourself and us","sentiment":1}}]
}
Can you let me know if this is acceptable? I am looking at writing ‘Text’ and ‘sentiment’ to another another table.
I am using scheduler action to call API currently its saying
Thank you for your help in advance.
Regards,
Dilip
You know, it really isn’t that difficult to format JSON so it’s somewhat readable…
{
"appID": "cnDHhD0ZHdBFK7M7qY32",
"mutations": [
{
"kind": "add-row-to-table",
"tableName": "native-table-jWEMMuChAFBW3berD6UM",
"columnValues": {
"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 ❤️",
"sentiment": 1
}
},
{
"kind": "add-row-to-table",
"tableName": "native-table-jWEMMuChAFBW3berD6UM",
"columnValues": {
"text": "Love this ❤️❤️🙌",
"sentiment": 1
}
},
{
"kind": "add-row-to-table",
"tableName": "native-table-jWEMMuChAFBW3berD6UM",
"columnValues": {
"text": "Really inspirational 😍",
"sentiment": 1
}
},
{
"kind": "add-row-to-table",
"tableName": "native-table-jWEMMuChAFBW3berD6UM",
"columnValues": {
"text": "I am in awe of you and your journey. Wishing you the best always :)",
"sentiment": 1
}
},
{
"kind": "add-row-to-table",
"tableName": "native-table-jWEMMuChAFBW3berD6UM",
"columnValues": {
"text": "More power to you 😍",
"sentiment": ""
}
},
{
"kind": "add-row-to-table",
"tableName": "native-table-jWEMMuChAFBW3berD6UM",
"columnValues": {
"text": "Wowww🔥🔥🔥🔥 in that weather",
"sentiment": ""
}
},
{
"kind": "add-row-to-table",
"tableName": "native-table-jWEMMuChAFBW3berD6UM",
"columnValues": {
"text": "Bro you inspire 😍👏",
"sentiment": 1
}
},
{
"kind": "add-row-to-table",
"tableName": "native-table-jWEMMuChAFBW3berD6UM",
"columnValues": {
"text": "All in one pack. More power to you ma'am",
"sentiment": ""
}
},
{
"kind": "add-row-to-table",
"tableName": "native-table-jWEMMuChAFBW3berD6UM",
"columnValues": {
"text": "❤️so Inspiring 👏🏻❤️ ma'am",
"sentiment": 1
}
},
{
"kind": "add-row-to-table",
"tableName": "native-table-jWEMMuChAFBW3berD6UM",
"columnValues": {
"text": "So needed to hear this",
"sentiment": ""
}
},
{
"kind": "add-row-to-table",
"tableName": "native-table-jWEMMuChAFBW3berD6UM",
"columnValues": {
"text": "Aapne ye start kaise kiya 😍",
"sentiment": ""
}
},
{
"kind": "add-row-to-table",
"tableName": "native-table-jWEMMuChAFBW3berD6UM",
"columnValues": {
"text": "As always ... U r amazing ❤️🫂 @thatfitmum",
"sentiment": 1
}
},
{
"kind": "add-row-to-table",
"tableName": "native-table-jWEMMuChAFBW3berD6UM",
"columnValues": {
"text": "@nishananiazzz ❤️🫶🏻",
"sentiment": ""
}
},
{
"kind": "add-row-to-table",
"tableName": "native-table-jWEMMuChAFBW3berD6UM",
"columnValues": {
"text": "Awesome video and wordings",
"sentiment": 1
}
},
{
"kind": "add-row-to-table",
"tableName": "native-table-jWEMMuChAFBW3berD6UM",
"columnValues": {
"text": "Omg! I love you so much!! ❤️❤️ you are such an inspiration :)",
"sentiment": 1
}
},
{
"kind": "add-row-to-table",
"tableName": "native-table-jWEMMuChAFBW3berD6UM",
"columnValues": {
"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!!!! ❤️❤️❤️❤️",
"sentiment": 1
}
},
{
"kind": "add-row-to-table",
"tableName": "native-table-jWEMMuChAFBW3berD6UM",
"columnValues": {
"text": "❤️❤️👏 super inspiring and much needed at large!",
"sentiment": 1
}
},
{
"kind": "add-row-to-table",
"tableName": "native-table-jWEMMuChAFBW3berD6UM",
"columnValues": {
"text": "You’re truly an inspiration and motivation to many many of us ❤️❤️❤️ more power to you to keep pushing yourself and us",
"sentiment": 1
}
}
]
}
Well, it’s valid JSON. So that’s a good start…
Did you have a question about this? Seems pretty obvious to me…
1 Like
I got that part too as experiments columns are not allowed in scheduled actions.
SO I dont think automatically running it every morning to generate reports is out of question for me.
I might have to just put in a button to run it manually?
Can you guide me if we still can use Scheduled actions?
Regards,
Dilip
Yes, perhaps. Or you could use something outside of Glide such as Make or Apps Script.
I can’t think of a way off the top of my head.
Hi @Darren_Murphy ,
I got this working using make.
I was trying to make use of the Scheduled Action Beta to try and make an automatic API call in the morning.
But seems like it wont work
Thank you for your help.
Regards,
Dilip