Lookup does not support http, and the site has a cert which sumo thinks is invalid

Comments

1 comment

  • Avatar
    Rick Jury

    Hi Stephen,

    the best way to resolve the cert issue would be to log a ticket with our support team. 

    As a workaround you can upload files to sumo and create a lookup table in sumo for them like this:

    1. https://help.sumologic.com/03Send-Data/Setup-Wizard/Upload-Static-Files-with-the-Setup-Wizard . upload the file as per this example. choose type 'other' and give it a category you can find like test/csv

    2. you can use the save operator to save any query result as a lookup table. https://help.sumologic.com/05Search/Search-Query-Language/Search-Operators/save 

    to find the logs I just uploaded:

    _sourceCategory="test/csv"

    3. create a lookup file.

    _sourceCategory="test/csv"
    | parse "*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*" as FID,the_geom,FID_,scalerank,featurecla,labelrank,sovereignt,sov_a3,adm0_dif,level,type,admin,adm0_a3,geou_dif,geounit,gu_a3,su_dif,subunit,su_a3,brk_diff,name,name_long,brk_a3,brk_name,brk_group,abbrev,postal,formal_en,formal_fr,note_adm0,note_brk,name_sort,name_alt,mapcolor7,mapcolor8,mapcolor9,mapcolor13,pop_est,gdp_md_est,pop_year,lastcensus,gdp_year,economy,income_grp,wikipedia,fips_10,iso_a2,iso_a3,iso_n3,un_a3,wb_a2,wb_a3,woe_id,adm0_a3_is,adm0_a3_us,adm0_a3_un,adm0_a3_wb,continent,region_un,subregion,region_wb,name_len,long_len,abbrev_len,tiny,homepart,Longitude,Latitude
    | count by FID,the_geom,FID_,scalerank,featurecla,labelrank,sovereignt,sov_a3,adm0_dif,level,type,admin,adm0_a3,geou_dif,geounit,gu_a3,su_dif,subunit,su_a3,brk_diff,name,name_long,brk_a3,brk_name,brk_group,abbrev,postal,formal_en,formal_fr,note_adm0,note_brk,name_sort,name_alt,mapcolor7,mapcolor8,mapcolor9,mapcolor13,pop_est,gdp_md_est,pop_year,lastcensus,gdp_year,economy,income_grp,wikipedia,fips_10,iso_a2,iso_a3,iso_n3,un_a3,wb_a2,wb_a3,woe_id,adm0_a3_is,adm0_a3_us,adm0_a3_un,adm0_a3_wb,continent,region_un,subregion,region_wb,name_len,long_len,abbrev_len,tiny,homepart,Longitude,Latitude
    | fields -_count
    | save /shared/lookup/geonode

    4. you can view the contents with cat /shared/lookup/geonode and you can now reference this in your lookup statement.

    0
    Comment actions Permalink

Please sign in to leave a comment.