Query String from Xojo

1

I am using the following after connecting to my FM database:

Dim query As String = "{""query"": {""c_Haulier"": ""=Test Company""} }"
Dim findResponse As FMResponseMBS = connection.FindRecords(query)
If findResponse = Nil Or findResponse.ErrorCode <> 0 Then
MsgBox "Find failed: " + findResponse.ErrorMessage
Return
End If

I get the error “Find failed: ‘query’: Expected type array but found type object.

How can I change the string to correct the error?

2

Also tried:

Dim query As String = "{""query"":[{""c_Haulier"": ""=Test Company""}],""sort"":[{""fieldName"": ""c_Haulier"",""sortOrder"": ""ascend""}}] }"

3

Have you checked Claris' documentation?

So in the first thing you didn't pass an array for query with , but an object with {}.

What does happen for the second query?

PS: The second query has an extra } after ascend on the end.