Validate csv data before uploading to Data Store

Validate csv data before uploading to Data Store

We would suggest you to pass your CSV file to a catalyst function where you can add your own conditions to read the file, perform your validations and then upload the same to Catalyst filestore and send the uploaded file ID back as a response. You can use that file ID in order to perform the bulk write operation. You can find code samples on how to send a file to catalyst functions here.

    • Related Articles

    • Multiline text fields in the Catalyst Data Store

      You can create your application with multiline text and rich text fields and use the text datatype available in the Catalyst Datastore in order to save the contents of those fields. You can find the help documentation regarding the same here. 

    • Limit of text data type in Catalyst Data Store

      The limit of text datatype in the Catalyst Datastore is 10000. If your message contains more than 10000characters, please consider creating a file in the FileStore and upload the content to it.

    • Catalyst Data Store tables are empty in production

      We would suggest you to use the Catalyst CLI/Bulk Write API to perform the bulk write operation in your table in the production environment. You can export the same from development and import it into production. Please check this link for more ...

    • Catalyst Data Store : API Limit Reached - Error 403

      As the message indicates, you have reached the maximum limit for row count in your development environment. You can query the tables in order to find the count of rows in specific table in the ZCQL console. Also, the limit will be 5000 rows per table ...

    • Basic I/O function in Nodejs to insert row in Catalyst Data Store

      const catalyst = require("zcatalyst-sdk-node"); module.exports = async(context, basicIO) => {     const tablename = "Students"     const app = catalyst.initialize(context);     let name = basicIO.getArgument("name");     let age = ...