Forum Discussion

Surendar's avatar
Surendar
Contributor
8 years ago

Generate multiple files based on single column

I need to generate multiple files based on category, say for example, The table having list of columns and category column have multiple values. Category: milk_products water_products oil_p...
api_management
proxy
snaplogic_api
Garrett's avatar
Garrett
New Contributor II
5 years ago
Copy LinkReport

Some info I found:

Here are two simple and short solution which could resolve this error for you.

  1. You could possibly change your database schema, to allow NULL values.

UPDATE table SET datefield = NULL WHERE datefield = ‘0000-00-00 00:00:00’;

  1. In your datasource configuration, you can edit JDBC URL by setting a parameter called ‘zeroDateTimeBehavior’ to ‘convertToNull’.

jdbc:mysql://localhost:3306/yourMySqlDatabase?zeroDateTimeBehavior=convertToNull

Is there a way I can set that convertToNull piece into the call on the Snap?

Related Content