Skip to main content
Known Participant
Jun 13, 2023 6:49 AM UTC
Question

Log reader

Hi, are there any options in the readcsvlog plugin to extract specific columns? And how that csv can be stored in a table?

    11 replies

    stefanhelzle0001
    Brainy
    Jun 13, 2023 7:00 AM UTC

    When you download the plugin from the app market, it should include the documentation.

    To store that data to your database, create a record with the required fields and create a scheduled process that reads the log and stores the data.

    Known Participant
    Jun 13, 2023 7:39 AM UTC

    Can you help on how to extract specific columns?

    sanchitg0002
    Inspiring
    Jun 13, 2023 8:22 AM UTC

    Why not just index them explicitly in a rule?

    a!forEach(
      items: readcsvlog(csvPath: "login-audit.csv").rows,
      expression: index(split(fv!item, ","), 3, {})
    )
     

    harshitb6843
    Brainy
    Jun 13, 2023 7:08 AM UTC

    Csv can be stored in a table using the Excel tools plugin. Find it here - community.appian.com/.../excel-tools