anivtk
New Contributor II
Joined 6 years ago
User Profile
User Widgets
Contributions
How to add a custom Header in a file?
Hi, I am reading some table data from a SQL Server (‘SQL Server - Execute’ snap) and writing the output to a text file (‘File Writer’ snap) (using a ‘CSV formatter’ between he above snaps) ‘SQL Server - Execute’ → ‘CSV formatter’ → ‘File Writer’ Requirement I don’t need the SQL column name name as the header ==> I am able to achieve this by unchecking “Write CSV header” in ‘CSV Formatter’ But I need a new heading (instead of the column name) which is would be the “number of records returned by the SQL query”. i.e. If the SQL query returns 99 records, the file should look like 99 Row 1 Row 2 Row 3 … … Row 99 Any help on how can I achieve this is appreciated. Thanks!Solved3.6KViews0likes2CommentsRe: Converting Varchar data into Datetime
Awesome, this worked! Thanks for your quick help. Note: Inorder to insert that into SQL server I have changed the output to a format SQL server supporst. So the parse function I used is Date.parse($create_time).toLocaleDateTimeString({“format”:“yyyy-MM-dd’T’HH:mm:ss.SSSSSS”}) Thanks again!2.4KViews1like0CommentsRe: Converting Varchar data into Datetime
I am calling the snapLogic Activity API and its returning the date in the format as “2020-02-21T17:44:19.996000+00:00” I am trying to store this data into SQL server and SQL server doesn’t accept this data in DateTime data type. I tried to use some simple pare method and it’s still not accepting. Later I used some complex Parse method like below, but its still not working. Date.parse($create_time,“yyyy-MM-dd’T’HH:mm:ss.SSSSSSX”).toLocaleDateTimeString({“format”:“yyyyMMdd-HHmmss”}) Can someone provide how to parse the data in this format “2020-02-21T17:44:19.996000+00:00” to DateTime which is compatible with SQL server ?2.4KViews0likes2CommentsRe: How to execute curl command using snaps
Sowmya, I saw your post for running curl command and saw that you ran it successfully using REST POST. can you please share details how to run the curl command using REST POST. Note: I need to run the curl command like curl -v -u abc@pqr.com -H ‘Content-Type:application/json’ --data-binary ‘{“unlock”:true}’ ‘https://elastic.snaplogic.com/api/1/rest/asset/user/xyz@pqr.com’2.1KViews0likes1CommentSnaps to copy data to Google Storage
I have a requirement to move/copy many files (1000s of files) to Google Storage. I did some reading in SnapLogic documentation and saw that we might have to use “Google BigQuery Bulk Load (Cloud Storage)” for this. Is this correct understanding? Any more details or any links to sample pipeline or snap configuration would be really helpful. Thanks in advance.Solved