Ad Widget

Collapse

How can export a value from url output

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bab
    Senior Member
    • Aug 2020
    • 194

    #1

    How can export a value from url output

    This is my output URL :

    1.jpg

    So I want to get value status that is showing success from this output
    I did follow steps :

    Create an HTTP item while due parse or get value :

    {"paymentCode":"0","paymentCodeValid":"0","errorCo de":null,"errorMsg":null,"result":"0","status":"SU CCESS","accountComment"}

    Also I know we have to use preprocessing . Would you please help me ? Please correct me if that is not correct also please help me how can just show status value that is here "SUCCESS" to create trigger according that

    Attached Files
  • bab
    Senior Member
    • Aug 2020
    • 194

    #2
    Would you please help me ?

    Comment

    • Brambo
      Senior Member
      • Jul 2023
      • 250

      #3
      But what do you want to get?
      If only 1 value is important, than after you did the xml to json stop add extra step like Jsonpath: $.paymentCode
      (you can set item value to integer for better storage)
      When you want more values stored: leave item value of you http item > create dependant items from http item> use jsonpath like above per item value

      Comment

      • Rudlafik
        Senior Member
        • Nov 2018
        • 165

        #4

        Value: {"paymentCode":"0","paymentCodeValid":"0","erro rCo de":null,"errorMsg":null,"result":"0","status":" SU CCESS","accountComment"}

        preprocessing: Regular exprression - SUCCESS - \0

        result: SUCCESS

        Note: If you want a numeric value, I recommend REPLACE value "SUCCESS" to a boolean value in the second step and then to numeric (Boolean to decimal) in the third step. Don't forget that the collected value is "text" at the beginning. (Edit the item accordingly.)

        Comment

        Working...