Skip to main content
Question

POS System - Data formatting

  • 7 October 2023
  • 1 reply
  • 17 views

Hi,
I am getting some data from our custom POS system - and it’s coming in a single line.

 

{"cardInfo":{"dankort":"1349","danskeecmcvi":"2199","udlexmxvijcb":"0","gebyr":"0"},"cashInfo":{"halvore":"0","enkr":"0","tokr":"0","femkr":"0","tikr":"0","tyvekr":"0","halvtredskr":"0","hundkr":"0","tohundkr":"0","femhundkr":"0","tusindkr":"0"}}

 

How can I format the above, so I get the data like:

dankort: 1349

danskeecmcvi: 2199

udlexmxvijcb: 0

gebyr: 0

 

See the attached screenshot as well.

 

Thank you in advance guys!

 

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

1 reply

Userlevel 7
Badge +14

Hi @Rayyw 

Good question.

You will need to use a custom Code step to parse and prep the raw JSON.

Code: https://zapier.com/apps