Question

Converting a payment array to readable text

  • 28 November 2023
  • 3 replies
  • 21 views

I am trying to format this to readable text from my Jotform submission into my Shipday orders. I only want the highlighted product, amount, options to display as output. Any help would be appreciated! 

 

 

{product:[Anheuser-Busch Selection (Amount: 0.01 USD, Qty: 1, Select Beer Options: Stella Artois 6 Pack Bottles)],currency:USD,tax:0.00,shipping:0.00,subtotal:0.01,total:0.01,coupon:ORDERTEST,squareData:{transactionId:xQUWdq3ezexuvEjlHmRYXyCJfSLZY,amount:1,locationId:LVBRHWVBPCQK0,isCharged:true,currency:USD,submission_id:5770015757427076135}


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

3 replies

Userlevel 7
Badge +14

Hi @tglasgow 

Good question.

One option is to use AI.

Action: ChatGPT - Extract Structured Data

NOTES:

  • Requires a ChatGPT Plus subscription
  • Requires an OpenAI billing payment method

Thanks! Any other possible solutions? 

Userlevel 7
Badge +14

@tglasgow 

You can write custom Code to parse and prep the data.