Avatar

Gerard Cafaro

Follow
  • 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,

    1. Community
    2. Data360® Analyze
    3. JSON Node Unexpected characters error

    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,

    1. Community
    2. Data360® Analyze
    3. JSON Node Unexpected characters error

    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,

    1. Community
    2. Data360® Analyze
    3. JSON Node Unexpected characters error

    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+

    1. Data360® DQ+
    2. Tips & Tricks

    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...

    • Gerard Cafaro
    • 1 follower
    • 0 comments
    • 0 votes
  • Avatar

    Gerard Cafaro created an article,

    How to check the driver class of a jdbc driver

    1. General Topics
    2. General Topics

    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...

    • Gerard Cafaro
    • 1 follower
    • 0 comments
    • 0 votes
  • Avatar

    Gerard Cafaro created an article,

    Using Windows Authentication to connect to SQL Server from Linux

    1. Infogix Assure, Insight, Perceive and ER
    2. Tips & Tricks

    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...

    • Gerard Cafaro
    • 1 follower
    • 0 comments
    • 0 votes
  • Avatar

    Gerard Cafaro commented,

    1. Community
    2. Data360® Analyze
    3. Strip HTML

    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,

    1. Community
    2. Data360® Analyze
    3. Strip HTML

    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,

    1. Community
    2. Data360® Analyze
    3. Strip HTML

    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...

    • View comment
    • Gerard Cafaro
    • Edited
    • 0 votes
  • Avatar

    Gerard Cafaro commented,

    1. Community
    2. Data360® DQ+
    3. Extract all Information present in DQ+ users page using REST API

    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...