HOW TO: Use a source field as a file name in FTP import

Comments

4 comments

  • David Gollom Strategic Partner
    Top Contributor
    Celigo University Level 4: Legendary
    Answer Pro
    Great Answer
    Engaged

    Hi Courtney.

    I was really having issues getting this to work this morning. I used AFE 2.0 and this path finally worked.  {{batch_of_records.0.record.eventObjectReference}}   I had to use batch_of_records. The flow originates with a webhook listener. 

    Maybe {{rows}} is a NetSuite export thing??  It's all very confusing still.  Is there a concise reference to the object model within IIO?  

    0
  • Stephen Brandt Documentation Manager Community moderator
    Celigo University Level 4: Legendary
    Engaged
    Great Answer
    Top Contributor

    Hi, David. That new data structure nomenclature came online in June, and it should be apparent in the sample exported records:

    https://docs.celigo.com/hc/en-us/articles/360045323471-integrator-io-release-notes-v6-6-1-0-June-2020#enhanced

    We're trying to catch up with the existing code samples, but for the near term, you should be able to use "data" references, in AFE 1.0 at least. 

    Sorry for the trial and error, but I'm thrilled to read about your progress. 

    0
  • SteinChu Strategic Support Lead

    hi guys, for file name in ftp imports, is that using afe 1 or 2?

    we can't seem to get the ff to work:

    batch_of_records.0.record.fieldname

    batch_of_records.0.record.0.fieldname

    batch_of_records.0.data.fieldname

    batch_of_records.0.data.0.fieldname

    record.fieldname

    data.fieldname

    record.0.fieldname

    data.0.fieldname

    0
  • SteinChu Strategic Support Lead

    update on this, we were able to make it work by adding file encoding and using following syntax:

    0

Please sign in to leave a comment.