Search Assets at a Site via API

[NPAT]

Hello,

I am looking for the API endpoint that will allow me to retrieve all assets at a particular site via API. 

I have tried entityBrowseRecords2 but it says h_site is not allowed.

 

I have also tried searching for h_site in h_cmdb_assets but it says h_cmdb_assets does not exist.

[Victor]

@NPAT what is the payload you used?

[Steve Giller]

11 hours ago, NPAT said:

I have also tried searching for h_site in h_cmdb_assets but it says h_cmdb_assets does not exist.

Also, h_cmdb_assets definitely exists, and it has an h_site column (and h_site_id) so the question here is what do you mean by 'searching for' and where/how are you searching?

[NPAT]

@Victor @Steve Giller

 

I want to use an API and specify a site, then get back all the assets at that site.

I have seen the entity Asset (h_cmdb_assets) contains site, but Site is not a searchable field on that Entity as far as I can see?

[NPAT]

I've managed to do it by getting all assets via API and filtering the response my side.

There must be a more efficient way? 

[Victor]

... again, what is the payload you use?

[NPAT]

1 minute ago, Victor said:

... again, what is the payload you use?

@Victor

 

{

  "@service": "data",

  "@method": "entityBrowseRecords2",

  "params": {

    "application": "com.hornbill.servicemanager",

    "entity": "Asset",

    "searchFilter": [

      {

        "column": "h_site",

        "value": ["siteName"]

      }

    ]

  }

}

[Gareth Cantrell]

@NPAT I usually use data?method=entityGetBrowseMetaData before using method=entityBrowseRecords2.

This will tell you which fields of the entity you can use in the searchFilter and which fields will be returned in the result.

{
  "@service": "data",
  "@method": "entityGetBrowseMetaData",
  "params": {
    "application": "com.hornbill.servicemanager",
    "entity": "Asset"
  }
}

As an aside, neither h_site not h_site_id are defined as a searchable fields for the Asset entity.

[NPAT]

Thanks @Gareth Cantrell

 

So it's not possible to search for assets at a certain site at this moment?

[Victor]

@NPAT these are the (current) searchable colums for the Asset entity:

 

https://docs.hornbill.com/servicemanager-api-api/entities/asset/index