Question

ShipStation fields automatically merged together

  • 12 August 2021
  • 2 replies
  • 23 views

I am trying to link Shipstation to Google Doc, as show in the image. The options pull through perfectly. However when I look to action them to a google sheet, the names and values get merged together, you can see this in the second Image. I only want to reference option 1 - value, any help would be much appreciated.

 

Image 1) Test Pull through

Imager 2) Merging Of Fields

 


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +14

Hi @Beer Cartel 

The data is structured as line items (aka arrays) which is why you are seeing it “grouped” together in the Action step.

Check out this help article for working with line items: https://zapier.com/help/doc/how-use-line-items-formatterv2

Userlevel 7
Badge +9

Hi @Beer Cartel 

The numbered values retrieved from ShipStation are called line-items. Parsing these information is technically a bit challenging. The best way to do that is by using a code step (JS/Python). However, you can parse the items in separate labels using Formatter > Line item to text and then Formatter > Separator (,).