Get Visma Business NXT data
Gets data from Visma Business NXT using GraphQL.
This action gets data from Visma Business NXT using a GraphQL query and returns the result as a stream of rows through an IDataReader.
The stream can then be piped to a destination, for example a SQL Server table using the Insert data action.
Properties
Name | Type | Description |
---|---|---|
Connection | Required | A Visma Open Id connection. You need to specify the Client Id , Client secrent and the Customer Id . You can find these values in the Visma developer portal. |
GraphQL configuration | Required | Lets you define the GraphQL query, GraphQL query variables and the data definition format of the rows returned from the GraphQL query. |
GraphQL configuration
The following describes the GraphQL configuration setup.
GraphQL Expression (required)
Defines the GraphQL query used to fetch data. You can get started quickly by clicking Create from template
and use it as a starting point.
Variables (optional)
If the query is parameterized (which it usually is), you need to map the parameters in the query to variables.
Item type mapping (required)
The Item type mapping
describes the data definition of the entities returned from the GraphQL query. You need to specify the data type (String, Integer, DateTime, etc) of each field that you want to include from the query, so Flow can convert it to objects that can be used by subsequent actions.