![]() ![]() Next, add the Text Helper connector and set the operation to 'Get text after'. Remember that the format in which you receive data will vary depending on where it is coming from - pulling records from Salesforce, Outreach, etc., will have different results/views. The records received by the Webhook are in JSON format: This makes the workflow ready to receive incoming calls. This makes the workflow ready to receive incoming calls.īe sure to click the 'Enable' button before continuing. Be sure to click the 'Enable' button before continuing. When using a Webhook trigger 'When webhook is received, auto respond with HTTP 200' is the most common operation, unless you want to specify a custom response. Read the records from the Redshift database. Push the records one by one into the Redshift database using the Loop connector. Pull the client records from the source (a webhook trigger in this example) and create the table (if it doesn't exist) in the Redshift database. ![]() Insert new rows: Inserts one or more rows into your chosen Redshift database.įind rows: Finds and reads the rows from your chosen database based on the specified criteria. Run SQL query: Executes a raw specified SQL query on the chosen database. This example demonstrates the following operations of the Redshift connector: Once the records are added, the workflow continues to read the records from the selected Redshift table. If it does not, then the workflow creates a new table and then adds the received records to that table. Upon receiving the records, the workflow checks whether the table we want to add these records to already exists in Redshift. Once this is done, copy and paste the URL into said 'Host' field.īelow is an example of how you could potentially use the Redshift connector to insert new records into the Redshift database and read all the records from said database. You will need to edit the given URL before adding it to your Tray.io authentication model.įor example, if your 'Endpoint' URL is: .:5427/dev, users will need to remove everything after :5427 in order to have valid information for the 'Host' field. The Host name is the 'Endpoint' listed within the 'General informtion' section. From the available list of clusters, select the one that you're trying to connect.įirstly, it asks for 'Host'. In order to get details about your reshift cluster, log on to AWS and head over to the Clusters screen in your Amazon Redshift account. The first page will ask you to name your authentication, and state which type of authentication you wish to create ('Personal' or 'Organisational').Īs you can see, the next page asks you for the details about your redshift cluster ('Host', 'Port', 'Database', and 'Schema') and your credentials ('User' and 'Password'). ![]() This will result in a Tray.io authentication pop-up window. ![]()
0 Comments
Leave a Reply. |