RVR-SRVNW-005

1. Issue Summary

   • The error code "RVR-SRVNW-005" indicates an issue with JSON normalization in the ServiceNow data connector on the Rivery platform. This typically occurs when there are inconsistencies or issues with processing JSON data structures within your river configuration. The JSON normalization process involves converting nested JSON data into a format that can be parsed and written into your target data destination.

2. Action Steps:

   1. Check JSON Structure:

      • Review the JSON data being extracted from ServiceNow to ensure it follows a consistent structure. Look for any malformed JSON or unexpected nesting that might be causing issues.

   2. Review Data Mapping:

      • Ensure that your data mapping in Rivery correctly handles JSON data types, especially if you are feeding data into a structured database like SQL, where JSON needs to be flattened or transformed accordingly.

   3. Modify JSON Handling:

      • Consider setting up your river to flatten nested JSON structures into a single table format or configure Rivery to preserve JSON data types if your target database supports JSON columns.

   4. Preserve Raw Data (if applicable):

      • If using a target like Snowflake, consider using the "Preserve Raw Data" toggle to maintain raw JSON data, and handle normalization with Snowflake's semi-structured data processing capabilities.

   5. Verify Data Source Configuration:

      • Double-check your ServiceNow data source configuration to ensure no fields are missing or improperly typed that might affect JSON parsing.

3. External References:

   • ServiceNow API: JSON Response Formats

If the issue persists or you need further assistance, please open a ticket with Rivery support.