Forum Discussion

VW's avatar
VW
Qrew Trainee
2 years ago

Pipeline validation error

Hi All,

We've set up a pipeline to our email to find a file.  We're able to find the file in the pipeline, but when we try to import the CSV into our QB application, we get the following error:

Validation error: Incorrect template "{{a.file_transfer_handle}}". ValueError: invalid literal for int() with base 10: 'file_transfer_handle'

Can anyone please give insight on what we need to change to resolve this?

Thank you!


------------------------------
VW
------------------------------
  • DougHenning1's avatar
    DougHenning1
    Community Manager
    Hi Val,
    Sounds like you're trying to access search records without a loop. If your step A is a search step, you need to add a loop to reference the individual items from the search.  However, if you know you'll only have one result or if you only want the first one, you can reference it as:
    {{a[0].file_transfer_handle}}


    ------------------------------
    Doug Henning
    ------------------------------
    • VW's avatar
      VW
      Qrew Trainee
      Thanks, Doug!  That seems to be working.

      ------------------------------
      Val Wong
      ------------------------------
      • PrashantMaheshw's avatar
        PrashantMaheshw
        Qrew Captain
        If there's something strangeIn your pipeline or jinaWho you gonna call?@Doug Henning! ​​​ !!!

        ------------------------------
        Prashant Maheshwari
        ------------------------------