https://api.bridgedataoutput.com/api/v2/OData/abor_ref/Member?$top=5&$filter=startswith(toupper(MemberLastName),'JOHNS')&$select=MemberFullName,MemberStatus
Filter on a string field value that starts with a certain value. This is case sensitive