Square API component: fails to pull specific Orders and Order Items

Matillion ETL
1

Struggling at the moment to configure the Matillion Square API component.

 

I need to pull Orders and Order Items for a list of order id's. I have two components (Orders and OrderItems) in a loop. Outside the loop I am creating the order_id strings to pass into these components.

 

Generally this is working. However I have hit a few really specific order_ids that just fail.

When this happens on a list of order_ids the error message is:

 java.util.Vector cannot be cast to java.lang.String

 

But when I finally isolated the exact order_id I am just getting the generic error message:

An error occurred while staging.

 

I have attached a level 4 debug log if anyone cares to have a peek?

 

I'm just curious why on certain order_ids the Matillion Square component fails?

 

Anyone else using Matillion to pull from Square? :)

 

Cheers

 

2

BUG: So the Square components are quite buggy and appear "unfinished" to me.

 

Other issues:

  1. Orders does not pull Order Date or Service Charge amount.
  2. Cannot use Search endpoint.
  3. Cannot pull Orders by day only by OrderId, so you really have to start by pulling Payments to get the OrderId's *then* you can pull Orders. Of course this only pulls paid orders.

 

Would be nice if someone at Matillion could have a look into the Square components and flesh these out to include a) all available fields and b) more endpoints.

 

Cheers,

Steve