Please check our example projects for Data API and Admin API queries. List.Cell(List.LastIndex, i) = fieldData.Value(fields(I)) List.AddRow "" For i As Integer = 0 To c- 1 If fields.Ubound < 0 Then // first time Dim keys() As Variant = fieldData.keys Title = Str(returnedCount)+ " records." Dim Data() As Variant = result.Lookup( "data", Nil)ĭim fields() As String Dim List As Listbox // some listbox to fill Dim recordID As Integer For Each record As Dictionary In data Return End If Dim returnedCount As Integer = dataInfo.Value( "returnedCount") Return End If Dim Result As Dictionary = r.Resultĭim dataInfo As Dictionary = Result.Lookup( "dataInfo", Nil) You can also run a script to sort and specify in your request which portals to return. Optionally you can specify a script to run before the query to gather the records. The layout defines which fields are available to set or query. Otherwise the default setting is to return first 50 records.įor a lot of operations, a layout must be specified. With request object you can specify the limit and offset for the query to get paged results.
To query records, please specify the layout to use as that one defines which fields. Connection.Layout = "Testing" Dim request As New FMRequestMBSįieldData.Value( "Company") = "Test Ltd."
0 kommentar(er)
