Avatar

Gerard Cafaro

  • Total activity 961
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 15
  • Subscriptions 598

Activity overview

Latest activity by Gerard Cafaro
  • Avatar

    Gerard Cafaro commented,

    Each record fed into the HTTP node will trigger its own API call. Does the header property come from a data flow property or a field? If it comes from a field, does the input match on all of the re...

  • Avatar

    Gerard Cafaro commented,

    The HTTP 401 error looks like a username and password weren't provided to the endpoint. There are several ways to authenticate an API request, and a particular API may only support a subset of ways...

  • Avatar

    Gerard Cafaro commented,

    The API endpoint will return an HTTP status code alongside its response. The HTTP status code can be captured by specifying an output field within the HTTP node's StatusCodeOutputField property. If...

  • Avatar

    Gerard Cafaro created an article,

    How to test email / SMTP connection in Data360 DQ+

    This article covers how to test email and SMTP connections within Data360 DQ+.  Testing an installation's SMTP connection During installation, the primary admin account specified within the propert...

  • Avatar

    Gerard Cafaro created an article,

    How to check the driver class of a jdbc driver

    Depending on the use case of the jdbc driver, it may be possible to skip specifying a driver class. However, there are use cases when specifying a driver class is required. The instructions below c...

  • Avatar

    Gerard Cafaro created an article,

    Using Windows Authentication to connect to SQL Server from Linux

    This article will cover how to setup Windows Authentication to connect to SQL Server from a Linux server. This functionality is dependent on the version of your SQL Server driver. SQL Server driver...

  • Avatar

    Gerard Cafaro commented,

    I had a comment half-typed about str vs unicode - I see you edited note with the same findings. Glad to hear you got it working! It's recommended to use unicode across the board when dealing with s...

  • Avatar

    Gerard Cafaro commented,

    You could put functions in the ProcessRecords property too, but that means the function would get re-defined each time a record is processed. The ConfigureFields property is only processed once per...

  • Avatar

    Gerard Cafaro commented,

    I use the regex code example from this Stackoverflow response for stripping HTML: https://stackoverflow.com/a/12982689 I embedded the import and function within a Transform node's ConfigureField pr...

  • Avatar

    Gerard Cafaro commented,

    The endpoints GraphQL connects with aren't exposed for direct access. DQ+'s available REST API endpoints are covered in our Using Data360 DQ+'s REST APIs article, although there aren't REST API end...