# Results in separate columns per character
**URL:** https://community.parabola.io/t/results-in-separate-columns-per-character/278
**Category:** Ask a question
**Tags:** Using-APIs
**Created:** [April 2, 2020, 3:19pm UTC](https://community.parabola.io/t/results-in-separate-columns-per-character/278 "2020-04-02T15:19:29Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@Sabrina\_Dekkers](https://community.parabola.io/u/Sabrina_Dekkers)
#### Post date: [April 2, 2020, 3:19pm UTC](https://community.parabola.io/t/results-in-separate-columns-per-character/278/1 "2020-04-02T15:19:29Z")
Hi guys!
Hope everyone is healthy!
I’m having another challenge on my hands, maybe you have a good tip how to handle this.
I managed to get another API working with enrichment on orderid, but it gives results in separate columns per character, any tips on how to prevent that from happening, or how to fix it using Parabola steps in a quick and easy way?
Thank you in advance!
---
### Author:  [@sachi](https://community.parabola.io/u/sachi)
#### Post date: [April 2, 2020, 4:19pm UTC](https://community.parabola.io/t/results-in-separate-columns-per-character/278/2 "2020-04-02T16:19:44Z")
Hey Sabrina! Are you able to link me to the API Documentation you’re referencing? A screenshot of the documentation would help too. Thanks!
---
### Author:  [@Sabrina\_Dekkers](https://community.parabola.io/u/Sabrina_Dekkers)
#### Post date: [April 2, 2020, 4:37pm UTC](https://community.parabola.io/t/results-in-separate-columns-per-character/278/3 "2020-04-02T16:37:05Z")
Hi Sachi,
The documentation for this API version is
> **[sticky.io Platform Legacy API & Integrations v7.50](https://developer-legacy-prod.sticky.io/?version=latest#d6ecbb2b-e8cc-46fc-be21-05fee8d664cf)**
>
> sticky.io Legacy API and Integrations
>
> \[JSON API\](https://developer-prod.sticky.io/)
They have 3 versions, and this one is the only one that gave me any result at all so far on what I was looking for, just almost 5000 columns of result, with 1 character in each column 😂
Thank you in advance!
---
### Author:  [@sachi](https://community.parabola.io/u/sachi)
#### Post date: [April 2, 2020, 8:31pm UTC](https://community.parabola.io/t/results-in-separate-columns-per-character/278/4 "2020-04-02T20:31:01Z")
Thanks, Sabrina. This is strange, but it looks like it’s an issue with how the API is sending back the response code. We can easily filter those columns out by just using a [Column Filter](https://parabola.io/transforms/column-filter) step right afterwards and filter FOR the columns that we want to keep.
Are you seeing the data you wished to get back with this API Enrichment step?
---
### Author:  [@Sabrina\_Dekkers](https://community.parabola.io/u/Sabrina_Dekkers)
#### Post date: [April 3, 2020, 9:31am UTC](https://community.parabola.io/t/results-in-separate-columns-per-character/278/5 "2020-04-03T09:31:15Z")
I can try sorting out which columns of the 5000 I do need and filter that, not ideal to set up, but in the end it will give me what I need.
Thank you! 🤗
---
### Author:  [@Sabrina\_Dekkers](https://community.parabola.io/u/Sabrina_Dekkers)
#### Post date: [April 3, 2020, 11:25am UTC](https://community.parabola.io/t/results-in-separate-columns-per-character/278/6 "2020-04-03T11:25:48Z")
Hi Sachi.
I have a new problem with this…
Is there a way to cut the repsonese off at a number of characters?
Thank you in advance.
---
### Author:  [@sachi](https://community.parabola.io/u/sachi)
#### Post date: [April 3, 2020, 8:59pm UTC](https://community.parabola.io/t/results-in-separate-columns-per-character/278/7 "2020-04-03T20:59:42Z")
Oh no, that’s no good! I looked into the newer version of their API, and I think it will work. One thing is that it doesn’t look to accept order\_ids as a parameter so you should use the [API Import step](https://parabola.io/sources/api-import) instead of API Enrichment, select [the criteria](https://developer-prod.sticky.io/?version=latest#271e24aa-fda9-4779-8c0a-7d45f6eb05e9) that you can, and then use the [Join step](https://parabola.io/transforms/join) to find matches with your data.
Here’s how you should configure the API Import:
Type: `Post`
API Endpoint URL: `https://httpcollectivebridge2.sticky.io/api/v1/order_find`
Body:
```auto
{
"campaign_id":"31,37,38,39,40,41,42",
"start_date":"03/01/2020",
"end_date":"03/21/2020",
"date_type":"create",
"criteria":
{
"return_type":"order_view"
}
}
```
Authentication: `Username and Password`
Username: `Your username`
Password: `Your password`
Header Key: `Content-Type`
Header Value: `application/json`
Don’t forget to consult their API docs and add other criteria into your Body: [https://developer-prod.sticky.io/?version=latest#271e24aa-fda9-4779-8c0a-7d45f6eb05e9](https://developer-prod.sticky.io/?version=latest#271e24aa-fda9-4779-8c0a-7d45f6eb05e9)
---
### Author:  [@Sabrina\_Dekkers](https://community.parabola.io/u/Sabrina_Dekkers)
#### Post date: [April 3, 2020, 10:10pm UTC](https://community.parabola.io/t/results-in-separate-columns-per-character/278/8 "2020-04-03T22:10:16Z")
Thank you Sachi,
I have another step running in the newer API version (V1) and that seems to be working fine, so I expect this to have potential as well. I love to be learning so much right now, I hope soon I won’t be needing so much help anymore, I am very happy you guys are so helpful, you are my heroes! 🙌
---
### Author:  [@sachi](https://community.parabola.io/u/sachi)
#### Post date: [April 3, 2020, 11:21pm UTC](https://community.parabola.io/t/results-in-separate-columns-per-character/278/9 "2020-04-03T23:21:02Z")
Sounds good, Sabrina! We’re happy to help and answer your questions. Keep 'em coming! 💪