Content Manager hosted table search gives no result

jpilbeam

Is there a way to search your Enterprise Portal for a hosted table using the content manager search()? I've tried a few different ways using the item_type= parameter, but I get nothing. And there is no obvious mention of tables in the Items and item types API help page?

 

table = gis.content.search(query="title:csvtest", item_type='table')

 

I've also tried these:

 

item_type='hosted table'
item_type='Table'
item_type='Table Layer'

 

They all give me this

 

[]

 

 

There is, however, a table in my content. I can find it with the required query parameter alone. The item type will come back as Table Layer, which, as you see above, I have tried.

 

table = gis.content.search(query="title:csvtest")

###result
<Item title:"csvtest" type:Table Layer owner:admin>

 

jcarlson

When you call Item.type on a table, you get 'Feature Service'. Specifying that in the item_type parameter will return table layers, too.

However, there does seem to be some separate attribute being stored somewhere that identifies the service as a table, but where? If you look at the service JSON, you'll see something like this:

 

{
...
  "type" : "Feature Service", 
  "typeKeywords" : [
    "ArcGIS Server", 
    "Data", 
    "Feature Access", 
    "Feature Service", 
    "Service", 
    "Table", 
    "Hosted Service"
  ],
...
}

 

 

Refer to the search reference page, and you'll see that 'typekeywords' is its own search parameter, and goes in the query string.

 

# This works
gis.content.search('table')

# This is more specific, and probably better
gis.content.search('typekeywords:table')

 

 

Both  commands return:

[<Item title:"Join_Features_to_GISFIPSMG" type:Table Layer owner:carlsonj9>,
<Item title:"date test" type:Table Layer owner:carlsonj9>,
<Item title:"GISFIPSMG" type:Table Layer owner:carlsonj9>]

 EDIT: It looks like the items and item types page does not reference tables in type or typekeyword, so you'd be forgiven for not being able to find this information. I've sent feedback for the page to get updated.