How to concatenate strings from a JSON/Array in Pabbly?

[shyrz]

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!

 

[Fagun Shah]

Try using Data Transformer - Line Itemizer. It will give you comma separated values for JSON array.

 

[shyrz]

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}}: <a href="{{Item Link}}">{{Item Title}}</a>

Can I do it?

 

[Fagun Shah]

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.

 

[shyrz]

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!

 

[PabblyMember3]

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.

 

[shyrz]

Wow, thank you. A new idea for me!