AnsweredAssumed Answered

Parsing json

Question asked by hankshrier on Sep 10, 2018
Latest reply on Sep 10, 2018 by wimdecorte

Thanks to Paul Jansen for helping me solve the problem.  This group is the best.


This is the message received back from the gateway


{"status":"approved","message":"Card Sale processed successfully. Success","transaction_id":"825228361599678","amount_approved":"1.00","authcode":"648154","token":"909055$O1IxPWLx","code":"MT00"}


I need to extract the work "approved", the authcode "648154".  and the token "909055$O1IxPWLx"


I think I need to use a JSONGetElement statement to extract what I need.  I can't figure out the syntax.


Ideally, I want to create a calculation for the fields involved. that creates the values based on the extractions.


I can also use a set varibable step and make the fields equal to the variable.


I've tried using the let function, but the punctuation makes figuring out where to start and stop tough.