Discussions

 View Only

Destringify Before Applying Regex in Pipeline

  • 1.  Destringify Before Applying Regex in Pipeline

    Posted 01-15-2022 22:27

    Hello:

    I have a pipeline that's submitting to Salesforce and I'd like to return the Salesforce ID after we posted, or grab the error, but we cannot, since the response is a serialized payload that cannot be changed from the Salesforce end - so it's coming over as an escaped string. It looks something like:

    {\"statusCode\":500,\"orderId\":null,\"message\":\"Internal Error Has Occured - Insert failed. First exception on row 0; first error: DUPLICATE_VALUE, duplicate value found: DTC_Order_Number__c duplicates value on record with id: 8014N000007z3Tb: []\"}""

    Typically the first thing you do is destringify the payload so you can use normal JSON notation to navigate it. Is it possible to destringify before applying the regex in Quickbase?

    I tried using the following regex to extract the value I needed, which seemed to work on https://regex101.com, but Pipelines didn't like it:
    (?<=orderId\\":)(?=[^a-z]*[a-z])

    I'd like to grab the values for orderId and for message.

    Any help is appreciated.



    ------------------------------
    Quincy Adam
    ------------------------------