# Bitrix24 Webhook integration - template of dataset

**URL:** <https://community.parabola.io/t/bitrix24-webhook-integration-template-of-dataset/1500>\
**Category:** Ask a question\
**Tags:** Building-Flows\
**Created:** [January 26, 2021, 9:53am UTC](https://community.parabola.io/t/bitrix24-webhook-integration-template-of-dataset/1500 "2021-01-26T09:53:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Frinet](https://avatars.discourse-cdn.com/v4/letter/f/f17d59/32.png) [@Frinet](https://community.parabola.io/u/Frinet)\
**Post date:** [January 26, 2021, 9:53am UTC](https://community.parabola.io/t/bitrix24-webhook-integration-template-of-dataset/1500/1 "2021-01-26T09:53:08Z")

</div>

Hi community!

I try to integrate Bitrix24 and Google SpreadSheet. In Bitrix24 I have an outgoing Webhook like this:

`https://parabola.io/api/hook/key?Name of activity={{Name of activity}}&Type of activities={{Type of activities}}&Employee={{Employee}}`

Webhook works correctly, in parabola I received the dataset. The problem of the dataset is multiples fields. For example, in the field “Employee” I can received from one to five ID of Employee. I want to  
transpose dataset in one row with columns “Employee\_1”, “Employee\_2”…“Employee\_5”.

To do this I:

1. Select “Employee” columns;
2. Split column to rows by “,”;
3. Enrich information about Employee;
4. Flip table;
5. Combine table.

Then I transform the dataset in parabola I cant create the template of the output dataset: the number and column names depending on the number of employees in the original dataset.

So, maybe you know a way to solve this problem?

 ![2021-01-26_12-46-44](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/e/e20904f2faedf319ccf50d909bf19f3253735607.png) ![2021-01-26_12-47-03](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/5/542dd1f648fa93c679a236ec2e3d5c827a314c88.png) ![2021-01-26_12-50-36](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/b/b29fec1317530e672effaa45d612eccbbe0417d5.png)

---

<div class="post-metadata">

**Author:** ![daniel](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/daniel/32/732_2.png) [@daniel](https://community.parabola.io/u/daniel)\
**Post date:** [January 27, 2021, 2:26am UTC](https://community.parabola.io/t/bitrix24-webhook-integration-template-of-dataset/1500/2 "2021-01-27T02:26:46Z")

</div>

Hi @Frinet 👋

Welcome to the community! Depending on your original dataset, we may be able to achieve this by using a Pivot columns step.

If you’re up for it, can you share a snippet of the full dataset after importing it from your webhook? If it’s easiest to send us that data outside of the community, send us an email at [help@parabola.io](mailto:help@parabola.io)

---

<div class="post-metadata">

**Author:** ![Frinet](https://avatars.discourse-cdn.com/v4/letter/f/f17d59/32.png) [@Frinet](https://community.parabola.io/u/Frinet)\
**Post date:** [January 27, 2021, 10:00am UTC](https://community.parabola.io/t/bitrix24-webhook-integration-template-of-dataset/1500/3 "2021-01-27T10:00:45Z")

</div>

Hi Daniel!

I found a solution on my own:

1. Add 5 rows to “Employee” table before Enrich data with an API
2. Add rows number
3. Add a new column “Employee + rows number”
4. Select columns “Employee name” + “Employee + rows number”
5. Limit 5 rows
6. Reorder columns
7. Flip table.

Also, modifying 1 field from the input dataset is 13 steps. In my opinion - it’s too hard a solution. It’s my first project in Parabola and I’m not sure if I did everything right.

In the evening I will send to you the input dataset - maybe you can find an easy solution

 ![Flow Parabola](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/d/df0147ace340e1ca9095faad082b3756055add7a.jpeg)