Merge multiple API in Single API

Content Authoring
1

Below are the four different API’s which are working fine. I want to make a single API to retrieve all the information including property name. I tried my self but did not able to achieve the requirements. Kindly help to make it single API with Property name.

https://abc.test.com:52311/api/query?relevance=(name of it,last report time of it) of bes computers

https://abc.test.com:52311/api/query?relevance=(names of computers of it, values of it) of results whose (exists values of it) of bes properties whose (name of it = "Staus")

https://abc.test.com:52311/api/query?relevance=(names of computers of it, values of it) of results whose (exists values of it) of bes properties whose (name of it = "Environment")

https://abc.test.com:52311/api/query?relevance=(names of computers of it, values of it) of results whose (exists values of it) of bes properties whose (name of it = "LMI")

2

Try this
https://bigfixserver:52311/api/query?relevance=(name of it, last report time of it, value of result from (bes property "Staus") of it | "N/A", value of result from (bes property "Environment") of it | "N/A", value of result from (bes property "LMI") of it | "N/A") of bes computers

3

Thanks, It gave me error “Requested resource does not exists” When i run my api one by one all worked fine for me.

4

This appears to be a typo, though it shouldn’t affect the API call itself.

I’d suggest URL-encoding the full relevance statement and retrying the API call.

//Example:
BigFix Rest API session relevance query - Content Authoring - BigFix Forum

5

Worth noting that this query while in its simplest possible form, is not optimized and won’t scale well (if for example you want to keep adding more properties and especially if you have big environment). The best way to do it with sets but the relevance itself gets messy/hard to follow & troubleshoot in a hurry.

1 Like
6

I have always found the Excel Connector a very useful way to build session relevance to use with the APIs (assuming of course you have Microsoft Excel). You can find it on the utilities page. The relevance it creates is scalable and wont have the problems @ageorgiev mentions when using a less complex forms of queries.

Rest API and Webreport not the same result :frowning: - Reporting - BigFix Forum

3 Likes
7

Have you had any luck getting it to work with Office 365 Excel by chance? I’ve just installed it but see no reference to it within Excel and can’t find any documentation for it.

8

When I had 365 in my previous employment it was working and my home setup has the C2R version of Office 2019/365 and it worked ok. Just installed on my newer setup with Office 365 build 2603 and all works ok.

image
image1003×487 33.1 KB

image
image534×313 6.77 KB

9

I recollect that the 3.3.6 version doesn’t work..needs to be 3.3.8

10

Thanks! I’ll need to hunt for 3.3.8. Our rep provided me this link and it downloaded 3.3.0.

11

You should find it on the Utilities section in the Bigfix Wiki

Utilities - BigFix Wiki Wiki

12

Right you are, thanks again!

13

Hi @gsing1987
This should solve your purpose.

(name of it, last report time of it as string, (if exists values of results (it, bes properties "Staus") then (concatenation "" of values of results (it, bes properties "Staus")) else "N/A"), (if exists values of results (it, bes properties "Environment") then (concatenation "" of values of results (it, bes properties "Environment")) else "N/A"), (if exists values of results (it, bes properties "LMI") then (concatenation "" of values of results (it, bes properties "LMI")) else "N/A")) of bes computers