How to concatenate strings from a JSON/Array in Pabbly?
Status: Closed · Asked by shyrz on · 0 views
Hey, I received a JSON and used Iterator to get every item of it. Then I wanted to concatenate strings from these items into a single string. In coding, I can do it with a for loop. How should I do that in Pabbly?
Btw, the number of JSON items is unpredictable.
Thank you!
Try using Data Transformer - Line Itemizer. It will give you comma separated values for JSON array.
Well, I tried "Data Transformer - Line Itemizer" already. It works only if I want to simply join strings together. It won't work when I want to do more complex operations.
For example, I received data from Browse AI here:
[{"Position":"1","Item Title":"\u5fae\u4fe1\u53d1\u5e03\u516c\u4f17\u53f7\u5934\u50cf\u8bbe\u7f6e\u65b0\u89c4\u8303\uff0c\u7981\u6b62\u4eff\u5192\u5b98\u65b9\u6d88\u606f\u63d0\u9192","Item Link":"https:\/\/readhub.cn\/topic\/8iq7NR7itNh"},{"Position":"2","Item Title":"\u4e2d\u56fd\u4eba\u5bff\u3001\u4e2d\u56fd\u77f3\u5316\u3001\u4e2d\u56fd\u77f3\u6cb9\u3001\u4e2d\u56fd\u94dd\u4e1a\u62df\u5c06\u7f8e\u56fd\u5b58\u6258\u80a1\u4efd\u4ece\u7ebd\u7ea6\u8bc1\u5238\u4ea4\u6613\u6240\u9000\u5e02","Item Link":"https:\/\/readhub.cn\/topic\/8iqd2zKRBsS"},{"Position":"3","Item Title":"\u94f6\u4fdd\u76d1\u4f1a\uff1a\u6cb3\u5357\u3001\u5b89\u5fbd 5 \u5bb6\u6751\u9547\u94f6\u884c\u6d89\u5acc\u4e25\u91cd\u72af\u7f6a","Item Link":"https:\/\/readhub.cn\/topic\/8iqgkb8wDhj"},{"Position":"4","Item Title":"\u817e\u8baf\u65b0\u4e13\u5229\uff1a\u53ef\u5b9a\u65f6\u53d1\u9001\u4f1a\u8bdd\u6d88\u606f","Item Link":"https:\/\/readhub.cn\/topic\/8iq0b0eiHdY"},{"Position":"5","Item Title":"\u641c\u72d7\u641c\u7d22 App \u505c\u670d\uff0c\u66f4\u540d\u540e\u7684 Bingo \u4e5f\u5df2\u4e0b\u67b6","Item Link":"https:\/\/readhub.cn\/topic\/8ipYrypxPS2"},{"Position":"6","Item Title":"\u67d0\u7528\u6237\u56e0\u957f\u671f\u8bcb\u6bc1\u6bd4\u4e9a\u8fea\uff0c\u9053\u6b49\u5e76\u8d54\u507f 3 \u4e07","Item Link":"https:\/\/readhub.cn\/topic\/8ipSMZ2dxZa"},{"Position":"7","Item Title":"\u6d88\u606f\u79f0\u82f9\u679c\u8981\u6c42\u4ee3\u5de5\u5546\u751f\u4ea7 9000 \u4e07\u90e8 iPhone 14","Item Link":"https:\/\/readhub.cn\/topic\/8ipjeNRWlgi"},{"Position":"8","Item Title":"\u82f9\u679c\u516c\u5e03\u6c7d\u8f66\u65e0\u6e90\u8fdb\u5165\u4e13\u5229\uff0c\u667a\u80fd\u624b\u673a\u624b\u8868\u7b49\u8bbe\u5907\u53ef\u4e0e\u8f66\u8f86\u4ea4\u4e92","Item Link":"https:\/\/readhub.cn\/topic\/8ipVTh8JkS4"},{"Position":"9","Item Title":"\u5b81\u5fb7\u65f6\u4ee3\uff1a\u62df\u4e0d\u8d85 73.4 \u4ebf\u6b27\u5143\u5308\u7259\u5229\u5efa\u5382","Item Link":"https:\/\/readhub.cn\/topic\/8iq9PAQ9Bqc"},{"Position":"10","Item Title":"\u94f6\u4fdd\u76d1\u4f1a\u8c08\u300c\u4fdd\u4ea4\u697c\u300d\uff1a\u6709\u6548\u6ee1\u8db3\u623f\u5730\u4ea7\u4f01\u4e1a\u5408\u7406\u878d\u8d44\u9700\u6c42","Item Link":"https:\/\/readhub.cn\/topic\/8iqfegRPPGp"},{"Position":"11","Item Title":"\u6caa\u6df1\u6e2f\u901a\u4ea4\u6613\u65e5\u5386\u4f18\u5316\u5de5\u4f5c\u6b63\u5f0f\u542f\u52a8","Item Link":"https:\/\/readhub.cn\/topic\/8iqd1ew8vBS"},{"Position":"12","Item Title":"\u5357\u4eac\u4e0b\u8c03\u4f4f\u623f\u8d37\u6b3e\u9996\u4ed8\u6bd4\u4f8b\uff0c\u4e8c\u5957\u623f\u6700\u4f4e 30%","Item Link":"https:\/\/readhub.cn\/topic\/8iqjygYDExX"}]If I want to concat strings like this:
{{Position}}: {{Item Title}}Can I do it?
Using iterator it will be possible for only 1 item of the JSON array, there is no concatenate function for this requirement for now.
Still tagging their team here - @Supreme @Pabbly , may be they can help better.
Using iterator it will be possible for only 1 item of the JSON array, there is no concatenate function for this requirement for now.Still tagging their team here - @Supreme @Pabbly , may be they can help better.
That's alright, thanks for your kindly help!
Unfortunately, it is not possible for now, But, if you are good in coding then, I would recommend you to use Cloudflare Workers scripts for manipulating your received JSON. In Pabbly Connect, you can make use of API steps to call the Cloudflare workers API.
Wow, thank you. A new idea for me!