Skip to main content

Postman - Useful Queries for Azure Search Service

Search by text

https://YOUR-AZURE-SEARCH-SERVICE-NAME.search.windows.net/indexes/YOUR-AZURE-SEARCH-INDEX-NAME/docs?search=cbt&api-version=2016-09-01&$count=true
https://YOUR-AZURE-SEARCH-SERVICE-NAME.search.windows.net/indexes/YOUR-AZURE-SEARCH-INDEX-NAME/docs?search=kerr&api-version=2016-09-01&$count=true

Top&skip
https://YOUR-AZURE-SEARCH-SERVICE-NAME.search.windows.net/indexes/YOUR-AZURE-SEARCH-INDEX-NAME/docs?api-version=2016-09-01&$top=3&$skip=0&$count=true

Facets - postman
https://YOUR-AZURE-SEARCH-SERVICE-NAME.search.windows.net/indexes/YOUR-AZURE-SEARCH-INDEX-NAME/docs?api-version=2016-09-01&$count=true&facet=specialisms

Facets - return all facets
https://YOUR-AZURE-SEARCH-SERVICE-NAME.search.windows.net/indexes/YOUR-AZURE-SEARCH-INDEX-NAME/docs?api-version=2016-09-01&$count=true&facet=specialisms, count:9999&facet=clientele, count:9999&$filter=listingType eq 'Therapist'

Return everything and count(*) for YOUR-AZURE-SEARCH-INDEX-NAME
https://YOUR-AZURE-SEARCH-SERVICE-NAME.search.windows.net/indexes/YOUR-AZURE-SEARCH-INDEX-NAME/docs?api-version=2016-09-01&$count=true

Return event recordType and count(*) for YOUR-AZURE-SEARCH-INDEX-NAME
https://YOUR-AZURE-SEARCH-SERVICE-NAME.search.windows.net/indexes/YOUR-AZURE-SEARCH-INDEX-NAME/docs?api-version=2016-09-01&$filter=(recordType eq 'Event')&$count=true

Return non-event recordTypes and count(*) for YOUR-AZURE-SEARCH-INDEX-NAME
https://YOUR-AZURE-SEARCH-SERVICE-NAME.search.windows.net/indexes/YOUR-AZURE-SEARCH-INDEX-NAME/docs?api-version=2016-09-01&$count=true&$filter=(recordType ne 'Event')

Return event recordType where title is not null or empty
https://YOUR-AZURE-SEARCH-SERVICE-NAME.search.windows.net/indexes/YOUR-AZURE-SEARCH-INDEX-NAME/docs?api-version=2016-09-01&$count=true&$filter=(recordType eq 'Event') and ((title ne null) or (title ne ''))

Return up-to-date events
https://YOUR-AZURE-SEARCH-SERVICE-NAME.search.windows.net/indexes/YOUR-AZURE-SEARCH-INDEX-NAME/docs?api-version=2016-09-01&$count=true&$filter=((title ne '')) and (((eventStartDate ge 2018-02-07T11:56:01.0797535Z)))

Return non-event recordTypes and count(*) where they all will have titles and also order by eventStartDate desc
https://YOUR-AZURE-SEARCH-SERVICE-NAME.search.windows.net/indexes/YOUR-AZURE-SEARCH-INDEX-NAME/docs?api-version=2016-09-01&$count=true&$filter=(recordType ne 'Event') and ((title eq ''))&$orderby=eventStartDate desc

Order by
https://YOUR-AZURE-SEARCH-SERVICE-NAME.search.windows.net/indexes/YOUR-AZURE-SEARCH-INDEX-NAME/docs?api-version=2016-09-01&$count=true&$filter=(recordType eq 'Event')&$orderby=eventStartDate desc

Order by location asc
https://YOUR-AZURE-SEARCH-SERVICE-NAME.search.windows.net/indexes/YOUR-AZURE-SEARCH-INDEX-NAME/docs?api-version=2016-09-01&$count=true&$filter=(recordType eq 'Event')&$orderby=geo.distance(location, geography'POINT(51.455546 -2.5834746)') asc

Return jobs for YOUR-AZURE-SEARCH-INDEX-NAME
https://YOUR-AZURE-SEARCH-SERVICE-NAME.search.windows.net/indexes/YOUR-AZURE-SEARCH-INDEX-NAME/docs?api-version=2016-09-01&$count=true&$orderby=postedDate desc

Role base protection return locked down data
https://YOUR-AZURE-SEARCH-SERVICE-NAME.search.windows.net/indexes/YOUR-AZURE-SEARCH-INDEX-NAME/docs?api-version=2016-09-01&$count=true&$filter=(recordType eq 'Event') and (title ne '') and ((memberOnlyContent ne true) or ((memberOfGroups/any(t: t eq 'TT')) or (memberOfGroups/any(t: t eq 'SERV'))))

Get Articles and Guidance
https://YOUR-AZURE-SEARCH-SERVICE-NAME.search.windows.net/indexes/YOUR-AZURE-SEARCH-INDEX-NAME/docs?api-version=2016-09-01&$filter=(recordType ne 'Event') and (title ne '') and (recordType eq 'Journals')&$count=true
Boosting exact matching items to return them on top of the list

https: ://YOUR-AZURE-SEARCH-SERVICE-NAME.search.windows.net/indexes/ YOUR-AZURE-SEARCH-INDEX-NAME /docs?api-version=2016-09-01&queryType=full&$count=true&searchFields=fullname&$select=fullname&search=fullname:("john smith")|(john)|(smith)&$orderby=search.score() desc,forename asc

Delete document using Postman - POST
https://YOUR-AZURE-SEARCH-SERVICE-NAME.search.windows.net/indexes/YOUR-AZURE-SEARCH-INDEX-NAME/docs/index?api-version=2016-09-01
BODY
{ 
  "value": [ 
    { 
      "@search.action": "delete", 
      "id": "YjgwZjQyMTMtNjkwYS1lODExLTgwZmEtMzg2M2JiMzRkYjAw" 
     } 
  ] 
} 
EXPECTED RESPONSE
{
    "value": [
        {
            "key": "YjgwZjQyMTMtNjkwYS1lODExLTgwZmEtMzg2M2JiMzRkYjAw",
            "status": true,
            "errorMessage": null,
            "statusCode": 200
        }
    ]
}


Labels:

Comments

Post a Comment

Popular posts from this blog

How to fix Umbraco v9 "Boot Failed : Umbraco failed to boot, if you are the owner of the website please see the log file for more details." error

If you have started working with Umbraco v9 and done your first Azure deployment to one of your testing environments, there is a possibility that you might see the following "Boot Failed" error. Error: Checking the logs In order to understand the problem, you should check the Umbarco log file.  The default location for this file is umbraco/Logs and this file contains the Machine name, along with the date information. You can reach this file via Azure's Kudu Service  or alternatively, you can get download your Azure App Service's publish profile and connect your App Service via an FTP application, i.e. FileZilla. See the FileZilla screen below; Once you get your log file, you can download it to your local machine and open it with a text editor, i.e. Notepad++. When you open it, you will see all logs, including the error message. Please be aware, as most things with Umbraco, logging is also customizable, so you can either use the default Umbraco logging which is Micros
Post a Comment
Read more

How to use JQuery Ajax Methods for Async ASP.NET MVC Action Methods

Making repeatedly calls to async methods can be a nightmare. In this case, it makes sense to use 2 ajax methods, instead of one. Here is a simple solution to overcome this problem. See that  ajaxcalls   is emptied after the success response for the first ajax call and then the second ajax method is used to make one single call to the async action method. Hope it helps. View: @section Scripts{     < script type ="text/javascript">         var smartDebitObject = new Object();         smartDebitObject.MembershipNumber = $( "#MembershipNumber" ).val();         smartDebitObject.ProfileId = $( "#ProfileId" ).val();         smartDebitObject.FirstName = $( "#FirstName" ).val();         smartDebitObject.LastName = $( "#LastName" ).val();         smartDebitObject.AddressLine1 = $( "#AddressLine1" ).val();         smartDebitObject.Postcode = $( "#Postcode" ).val();         smartDebitObject
Post a Comment
Read more

How to fix Git push error: "RPC failed; curl 56 HTTP/2 stream 7 was reset send-pack: unexpected disconnect while reading sideband packet fatal: the remote end hung up unexpectedly"

Problem Today I saw the following problem when I tried to push my changes to a Git server after doing some work for upgrading an Umbraco v7 project to v8.18.8.  Possible reasons After some investigations, it seems like this could be because of the following reasons; Git is not happy with the amount of changes that are being pushed into the server.  There are possible limitations on the server about the size/amount of files that you can push. Your internet connection is not good and stable enough. Your Git client's version is old. Solution options For me, the easiest option was connecting to another Wifi and trying again. Apparently, this option helped quite a few people, so it is worth giving it a try. Unfortunately, it didn't work for me. A bad internet connection wasn't an option for me either, as my internet is pretty fast (500 Mbps). Similarly, my Git client version was the latest version (git version 2.41.0.windows.3).  On StackOverflow, there were a lot of recommendat
Post a Comment
Read more