Not able to import excel to database using Receive Message vai email in Process mode

I am sending an email attached with excel sheet to process model vai Receive Email at start node. I could able to extract the excel from email but the data is not written in the database.
FYI: Using Plugin Import Excel to Database, Using CDT 

  Discussion posts and replies are publicly visible

Parents Reply Children
  • +1
    Certified Lead Developer
    in reply to abhishek_bhalke

    When email triggers a process, it runs as ANONYMOUS user who has no database write permissions. By setting the Import Excel node to “Run as whoever designed this process model,” it uses your permissions instead, which is why it now works - you have the necessary database access that ANONYMOUS lacks.
    For multiple attachments, save msg!properties.attachments to a process variable array (pv!attachments), then configure the Import Excel node as Multiple Node Instance (MNI). Set it to run for each item in pv!attachments, use pv!attachments[tp!index] as the Document input, and keep it running as designer.