Not a customer? Click the 'Start a free trial' link to begin a 30-day SaaS trial of our product and to join our community.
Existing Cisco AppDynamics customers should click the 'Sign In' button to authenticate to access the community
03-06-2019 11:14 AM
Question about working with Json data.
So I have a template file that is in json format that I need to work with.
Within that Json file there are a bunch of different "widgets". Within each widget, there is a listing of "entity" names, one per server (but invalid servers that need removed and replaced with this script).
I need to import this json file. Go into each widget. Look at the formatting of the existing entities, save that. Remove all the existing entities. Then add an entity for each server in my serverlist using the formatting template I saved.
The entities I need to remove are deep into the file, so that may throw a cog into this.
I have attached a screenshot of the entities that need to come out, you can see they are under .entityNames within each widget.
Any tips or suggestions would be helpful. I've been researching myself online.
The following text can be copied and pasted into your code editor:
# So far I'm able to successfully import my json data using this code
$jsoninput = Get-Content -Path "$thisfolder\APPD-DASHBOARD-GENERATOR.input.json" | ConvertFrom-Json
# I then run a foreach against each widget found within the json.
foreach ($widget in $jsoninput.widgetTemplates)
{
# I then look up the first entity in the widget, I'm going to use this as a template later.
$first1 = $widget.dataSeriesTemplates.metricMatchCriteriaTemplate.entityMatchCriteria.entityNames| Select-Object -First 1
# I then need a method for removing each of the existing entities found...
foreach ($entity in $widget.dataSeriesTemplates.metricMatchCriteriaTemplate.entityMatchCriteria.entityNames)
{
!!! Not sure what to do here !!!
}
# I then need a method for adding an entry for each server found in the server list.
foreach ($server in $servers)
{
# I have this template from earlier
$first1
}
}
03-28-2019 08:47 AM
It's possible to do this, but I don't know powershell :( . I do this with a shell script, using sed to replace the entity names. If you have the option of running this on a UNIX host I can send you an example of a script.
Thank you! Your submission has been received!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form