topic Re: How to parse data for a table to display list in Getting Data In

How to parse data for a table to display list

skphi13 — Tue, 04 Jun 2019 15:26:48 GMT

This is what I have when I tried my search query.

INFO: Found installations for 8 accounts [scheduler]
       "accountNames": [
         "MTS",
         "hasc-services",
         "ahchaudhary",
         "reviews",
         "PM-Solutions",
         "traveler",
         "Affiliates",
         "Catalyst"
       ],
       "accountCount": 8

I am trying to parse the data to a table to display a list of accountNames only.

Any help would be appreciated.

Re: How to parse data for a table to display list

omuelle1 — Wed, 30 Sep 2020 00:47:40 GMT

I would recommend creating a field to extract the data using a regex:

Something like:

| rex field=_raw max_match=0 "\"(?.*)\""

Re: How to parse data for a table to display list

evania — Fri, 07 Jun 2019 15:48:21 GMT

Hi @skphi13 ,

Did you have a chance to check out an answer? If it worked, please resolve this post by approving it! If your problem is still not solved, keep us updated so that someone else can help you.

Thanks for posting!