Results in separate columns per character

Ask a question
1

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?

image
image1390×902 86.9 KB

Thank you in advance!

2

Hey Sabrina! Are you able to link me to the API Documentation you’re referencing? A screenshot of the documentation would help too. Thanks!

3

Hi Sachi,

The documentation for this API version is

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 :joy:

Thank you in advance!

4

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 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?

5

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! :hugs:

6

Hi Sachi.

I have a new problem with this…

image

Is there a way to cut the repsonese off at a number of characters?

Thank you in advance.

7

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 instead of API Enrichment, select the criteria that you can, and then use the Join step 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:

{
        "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

8

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! :raised_hands:

1 Like
9

Sounds good, Sabrina! We’re happy to help and answer your questions. Keep 'em coming! :muscle:

1 Like