UI builder Geomap dynamic data

[limuelcmend]

Hi, I am using geomap in UI builder works well but I wanna make it more dynamic by configuring the data configuration i thought it need only a table but it require a dynamic json as data resource how can I make this work do I have to re-create the dynamic json? transform it? my other problem with that is I can make the json but there are meta data there metricId where I dont know where to pull out? any idea where can i get this informations?

[SAPSnEnthusiast]

Hi @limuelcmend 

First yes for your table data into the required json format, you can take required json format using gpt 
and you need to map the metricid then create a Scripted Data Resource, again for creation use gpt for the format to generate.

For metric id mapping you can give id:metric_1 , label:''New''

Hope this helps

[limuelcmend]

Hello @SAPSnEnthusiast , 

thank you for this, I have a few questions, Scripted Data Recsource where can I find this, because it's not in my data resource options. Second will data transform be heavy specially with big data (do you also include pagination)? and is metricId not important? I really want to know where it is coming from. do you have examples I can see for reference?

[SAPSnEnthusiast]

Hi @limuelcmend 

https://developer.servicenow.com/dev.do#!/learn/courses/zurich/app_store_learnv2_uibuilder_zurich_ui...

For creation of Data resource
And will it be heavy NO (If correctly done) it depends on query parameters, so use setLimit().


And yes metric id is important and yes include pagination

https://developer.servicenow.com/dev.do#!/learn/courses/zurich/app_store_learnv2_rest_zurich_rest_in...

go through the links for your reference.