Forum Discussion

Abhijit's avatar
Abhijit
New Contributor
9 years ago

UNION: Preserve source data sequence

I need to preserve the sequence of source data to produce line by line output. It seems UNION snap cannot do that as I just find “December 20, 2014: Preserve order was removed.” comment in SnapLogic ...
SGArchitect's avatar
SGArchitect
New Contributor II
4 years ago
Copy LinkReport

Hi @alchemiz ,

Thank you very much for the response. I still couldn’t understand how I could download the CSV file. Could you please let me know the snap that I could use to download the CSV file once I make the REST API call “/bulk/v1/leads/export/{exportID}/file.json”?
“file.json” REST API call returns a CSV file as per Marketo documentation.

    • NAl's avatar
      NAl
      Contributor
      4 years ago
      Copy LinkReport

      Hi Spiro,

      Below is the received error message. It doesn’t work either with 2 equal signs…

      Expression parsing failed near -- SSO__c >> = << TRUE (Reason: Attempt to use assignment at line 1:7, which is not supported in the expression language; Resolution: If you meant to compare two values, use two equals signs (==))

      • SpiroTaleski's avatar
        SpiroTaleski
        Valued Contributor
        4 years ago
        Copy LinkReport

        @NAl

        If you have the expression button on, try:

        “CUSTOM_FIELD__c = TRUE”

  • SpiroTaleski's avatar
    SpiroTaleski
    Valued Contributor
    4 years ago
    Copy LinkReport

    @NAl

    Use ‘=’ instead of ‘==’ on the place where you make comparison .

    Or please share the query that you are trying to execute.

    • NAl's avatar
      NAl
      Contributor
      4 years ago
      Copy LinkReport

      Hi @Spiro_Taleski,

      After attempting lots of variations, this one did the trick:
      'CUSTOM_FIELD__c = TRUE'

      As always thanks for your help