PostgreSQL Bulk Upload
When the INSERT query getting fired from Snaplogic, the PRIMARY_KEY is going as null which is causing issue to insert the data in the destination PostgreSQL database. The primary key column is auto-...
Forum Discussion
kindminis - Please download and decompress the attached ZIP file, the import the SLP file as a new pipeline. It is an example of how I would approach it using the XML Generator snap to create the portion of HTML to display 3 example tables in the Email HTML body. If you click into the Edit XML button on the snap, you can see I'm using the Apache Velocity Engine to generically run through each of the arrays to create the HTML tables.
As with any good development platform, there are other ways to do the same thing, but this is one solution that should work for you.
Hope this helps!
If you click on the gear icon at the top right of the page (user settings) you can choose a different number of preview records. The default is 50, that is usually enough, but you can choose up to 2000
It works ok for when set to 2000 now. I am finding difficulties to get an individual value from the object buts returns as object. Am I doing anything wrong ?
My expectation is return one value of Academic_level per academic_Record_wid
Hi @pmuthusamy,
If all Academic_levels in Student_course_regi… are same inside the list, you can get only the first element.
You just need to replace [*] with [0] inside the expression from above image.Regards,
Viktor
Thanks Viktor, This worked but my object is nested one, object within object, producing not right result.
I want to flatten the JSON into rows.
Thanks
Pazhaniappan
