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
Hi @rmedeiros ,
Can you try to set “approval_prompt” to force in SnapLogic and check the created account after that ?
Thanks a lot for your answer. I tried it and its connecting now… I`ll do more test to assure its auto-refreshing.
Thanks for the help!
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
