Error: SyntaxError: Unexpected non-whitespace character after JSON at position 2097 - Githubissues

jeffreykemp / jk64-plugin-reportmap

Report Google Map APEX Plugin

https://jeffreykemp.github.io/jk64-plugin-reportmap/

MIT License

42 stars 16 forks source link

Error: SyntaxError: Unexpected non-whitespace character after JSON at position 2097 #165

Closed holtzmanwl closed 1 year ago

holtzmanwl commented 1 year ago

Describe the bug The plugin works when I choose the Marker Cluster option but with the Heat Map option I get the error in the title of this bug.

To Reproduce

Add a page to my application
Create a JK64 Report Google Map R1 on that page
Enter an SQL query with lat, lng, and two other fields
Choose Heatmap in the visualization attribute
View the output in the application

Expected behavior Expect to see a heat map as shown here https://github.com/jeffreykemp/jk64-plugin-reportmap

Screenshots

Device (please complete the following information):

Plugin Version: 1.5
APEX Version: 22.2.1
Oracle Database Version: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Browser: Chrome
OS: Windows 10 Home
Type: Desktop

Plugin Attributes heat map error.txt Debug Message Data.csv

holtzmanwl commented 1 year ago

Sorry, I figured it out based on the Demo app. My input needed SQL needed some work! Thanks for this amazing plugin!