REST command is not including all columns from CSV

Mary666 — Mon, 08 Nov 2021 19:51:31 GMT

Hello Splunk Community

I have managed to use REST to add some columns from my CSV files. However, not all the columns are uploaded. I am using the below script:

| rest /servicesNS/-/-/data/lookup-table-files search="*_Weather.Lookups.csv"

But the issue is that I am not getting all the fields associated with *_Weather.Lookups.csv anybody out there know how I can het all the fields or a specific field from the lookup ? Thanks in advance.

Re: REST command is not including all columns from CSV

Mary666 — Mon, 08 Nov 2021 23:00:01 GMT

I was able to figure it out, so basically:

| rest /servicesNS/-/-/data/lookup-table-files search="*_Weather_Report.csv"| inputlookup append=t New_Jersey_Weather_Report.csv

I just needed to add the append=t to have the lookup show me everything in it while still having the rest command.

topic REST command is not including all columns from CSV in Splunk Search

REST command is not including all columns from CSV

Re: REST command is not including all columns from CSV