# Integration Toolkit Solutions Wiki

**URL:** <https://forum.inductiveautomation.com/t/integration-toolkit-solutions-wiki/105080>\
**Category:** 3rd Party Modules\
**Tags:** scripting, ignition81\
**Created:** [April 14, 2025, 9:02pm UTC](https://forum.inductiveautomation.com/t/integration-toolkit-solutions-wiki/105080 "2025-04-14T21:02:36Z")\
**Posts on this page:** 1\
**Showing post:** 20

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [May 21, 2025, 2:49am UTC](https://forum.inductiveautomation.com/t/integration-toolkit-solutions-wiki/105080/20 "2025-05-21T02:49:32Z")

</div>

## Mimicking Python join to concatenate a list of dicts into a string

How would I do this?

e.g.  
Data:

```python
[
  {
    "datetime": 1747795200000,
    "price": 108.64
  },
  {
    "datetime": 1747795500000,
    "price": 119.71819
  },
  {
    "datetime": 1747795800000,
    "price": 119.71819
  },
  {
    "datetime": 1747796100000,
    "price": 114.23557
  }
]

```

Output:

```python
"2025-05-21 10:30 - $108.64
2025-05-21 11:00 - $119.72
2025-05-21 11:30 - $119.72
2025-05-21 12:00 - $114.24"

```

Python equivalent:

```python
"\r\n".join(
		"{} - ${:.2f}".format(
			system.date.format(system.date.fromMillis(row['datetime']), 'YYYY-MM-dd HH:mm'),
			row['price'])
		for row in value
	)

```

[PS. this wiki was such a good idea]

> **List concat**
>
> ```python
> groupConcat(
> forEach(
> {path.to.source.list},
> stringFormat(
> "%s - $%.f",
> dateFormat(
> fromMillis(it()['datetime']),
> 'yyyy-MM-dd HH:mm'
> ),
> it()['price']
> )
> ),
> "\r\n"
> )
> 
> ```

---

_[View the full topic](https://forum.inductiveautomation.com/t/integration-toolkit-solutions-wiki/105080)._