Processing csv files

Options
Geoffroy
Geoffroy Member ✭
in ? Help! I'm a Noob
Hello,
I need to feed my database with external API sources, but also csv files for download.
What is the right procedure?
Can I upload the files to Xano and then process the csv file in a function?
· Share on Twitter

Comments

  • Chris Coleman
    Chris Coleman Administrator

    ADMIN
    Options
    Hi, Geoffroy! Went ahead and put together a tutorial on how to process an uploaded CSV file in your function stack. I know your use case might vary a bit, so definitely let me know if I can clarify anything. There's also a snippet available if you want to dive in right away.

    Video 

    Snippet
    · Share on Twitter
  • Geoffroy
    Geoffroy Member ✭
    Options
    Hi Chris !
    Work fine ! Big thanks & good timing 🙂
    · Share on Twitter
  • Geoffroy
    Geoffroy Member ✭
    Options
     How to deal with special character (.) in the csv keys ?
    · Share on Twitter
  • Chris Coleman
    Chris Coleman Administrator

    ADMIN
    Options
     What's happening if you have special characters in your CSV?
    · Share on Twitter
  • Geoffroy
    Geoffroy Member ✭
    Options
     Key with special character aren't found.
    I've used replace filter to deal with that issue :
    [screenshot.xano.io-2022.06.15-17_43_55.png]
    · Share on Twitter
  • Chris Coleman
    Chris Coleman Administrator

    ADMIN
    Options
     Interesting. Typically, this shouldn't be an issue. I'd actually like to take a look at your CSV file, if that's okay. If so, could you send that to me at chris@xano.com?
    · Share on Twitter

Categories