search

turbot / steampipe-export

Steampipe Export is a zero-ETL CLI to fetch data from cloud services and APIs. Hundreds of plugins with thousands of documented examples.
https://steampipe.io
Apache License 2.0
8 stars 1 forks source link

Export CLI returns <nil> in case of NULL values in the CSV output #70

Closed pskrbasu closed 3 months ago

pskrbasu commented 3 months ago

CSV output:

steampipe_export_net net_dns_record --where 'domain="steampipe.io"'
_ctx,dns_server,domain,expire,ip,minimum,priority,refresh,retry,serial,tag,target,ttl,type,value
"{""connection_name"":""net"",""steampipe"":{""sdk_version"":""5.8.0""}}",<nil>,steampipe.io,<nil>,76.76.21.21,<nil>,<nil>,<nil>,<nil>,<nil>,<nil>,<nil>,300,A,<nil>
"{""connection_name"":""net"",""steampipe"":{""sdk_version"":""5.8.0""}}",<nil>,steampipe.io,<nil>,<nil>,<nil>,5,<nil>,<nil>,<nil>,<nil>,alt1.aspmx.l.google.com.,300,MX,<nil>
"{""connection_name"":""net"",""steampipe"":{""sdk_version"":""5.8.0""}}",<nil>,steampipe.io,<nil>,<nil>,<nil>,10,<nil>,<nil>,<nil>,<nil>,alt3.aspmx.l.google.com.,300,MX,<nil>
"{""connection_name"":""net"",""steampipe"":{""sdk_version"":""5.8.0""}}",<nil>,steampipe.io,<nil>,<nil>,<nil>,1,<nil>,<nil>,<nil>,<nil>,aspmx.l.google.com.,300,MX,<nil>
"{""connection_name"":""net"",""steampipe"":{""sdk_version"":""5.8.0""}}",<nil>,steampipe.io,<nil>,<nil>,<nil>,5,<nil>,<nil>,<nil>,<nil>,alt2.aspmx.l.google.com.,300,MX,<nil>
"{""connection_name"":""net"",""steampipe"":{""sdk_version"":""5.8.0""}}",<nil>,steampipe.io,<nil>,<nil>,<nil>,10,<nil>,<nil>,<nil>,<nil>,alt4.aspmx.l.google.com.,300,MX,<nil>
"{""connection_name"":""net"",""steampipe"":{""sdk_version"":""5.8.0""}}",<nil>,steampipe.io,<nil>,<nil>,<nil>,<nil>,<nil>,<nil>,<nil>,<nil>,ns-1455.awsdns-53.org.,21600,NS,<nil>
"{""connection_name"":""net"",""steampipe"":{""sdk_version"":""5.8.0""}}",<nil>,steampipe.io,<nil>,<nil>,<nil>,<nil>,<nil>,<nil>,<nil>,<nil>,ns-600.awsdns-11.net.,21600,NS,<nil>
"{""connection_name"":""net"",""steampipe"":{""sdk_version"":""5.8.0""}}",<nil>,steampipe.io,<nil>,<nil>,<nil>,<nil>,<nil>,<nil>,<nil>,<nil>,ns-128.awsdns-16.com.,21600,NS,<nil>
"{""connection_name"":""net"",""steampipe"":{""sdk_version"":""5.8.0""}}",<nil>,steampipe.io,<nil>,<nil>,<nil>,<nil>,<nil>,<nil>,<nil>,<nil>,ns-1628.awsdns-11.co.uk.,21600,NS,<nil>
"{""connection_name"":""net"",""steampipe"":{""sdk_version"":""5.8.0""}}",<nil>,steampipe.io,1209600,<nil>,86400,<nil>,7200,900,1,<nil>,ns-128.awsdns-16.com.,900,SOA,<nil>

steampipe output:

> select
  *
from
  net_dns_record
where
  domain = 'steampipe.io';
domain,type,dns_server,ip,target,priority,tag,value,ttl,serial,minimum,refresh,retry,expire,_ctx
steampipe.io,A,,76.76.21.21,,,,,300,,,,,,"{""connection_name"":""net"",""steampipe"":{""sdk_version"":""5.8.0""}}"
steampipe.io,MX,,,alt3.aspmx.l.google.com.,10,,,300,,,,,,"{""connection_name"":""net"",""steampipe"":{""sdk_version"":""5.8.0""}}"
steampipe.io,MX,,,alt2.aspmx.l.google.com.,5,,,300,,,,,,"{""connection_name"":""net"",""steampipe"":{""sdk_version"":""5.8.0""}}"
steampipe.io,MX,,,aspmx.l.google.com.,1,,,300,,,,,,"{""connection_name"":""net"",""steampipe"":{""sdk_version"":""5.8.0""}}"
steampipe.io,MX,,,alt4.aspmx.l.google.com.,10,,,300,,,,,,"{""connection_name"":""net"",""steampipe"":{""sdk_version"":""5.8.0""}}"
steampipe.io,MX,,,alt1.aspmx.l.google.com.,5,,,300,,,,,,"{""connection_name"":""net"",""steampipe"":{""sdk_version"":""5.8.0""}}"
steampipe.io,NS,,,ns-600.awsdns-11.net.,,,,21566,,,,,,"{""connection_name"":""net"",""steampipe"":{""sdk_version"":""5.8.0""}}"
steampipe.io,NS,,,ns-1455.awsdns-53.org.,,,,21566,,,,,,"{""connection_name"":""net"",""steampipe"":{""sdk_version"":""5.8.0""}}"
steampipe.io,NS,,,ns-1628.awsdns-11.co.uk.,,,,21566,,,,,,"{""connection_name"":""net"",""steampipe"":{""sdk_version"":""5.8.0""}}"
steampipe.io,NS,,,ns-128.awsdns-16.com.,,,,21566,,,,,,"{""connection_name"":""net"",""steampipe"":{""sdk_version"":""5.8.0""}}"
steampipe.io,SOA,,,ns-128.awsdns-16.com.,,,,900,1,86400,7200,900,1209600,"{""connection_name"":""net"",""steampipe"":{""sdk_version"":""5.8.0""}}"

Export CLI's CSV output should be same to steampipe.