Following is the jsonSchema. { "$schema": "http://json-schema.org/draft-07/schema#", "type": "array", "items": [ { "type": "object", "properties": { "isMerchant": { "type": "boolean" }, "isAgent": { "type": "boolean" }, "cashLoan": { "type": "boolean" }, "personalDetail": { "type": "string" }, "contact": { "type": "object",…
I am looking for the different ways how within SSIS APIs can be called (e.g. getting data from a JSON file) or by calling APIs objects in SSIS can be accessed or configured (e.g. triggering an SSIS package). Since I'm…
I am not able to parse the below object in C# .NET. I am getting parsing object error. messageBody (in String format - I am getting this below object in string format) { "Type" : "Nti_1", "MessageId" : "c1b7cd5b-3099-532e-9539-91376eea607b", "SequenceNumber"…
I currently have one json file as follows in terms of formatting: { "Comment":"json data", "Changes":[ { "Action":"DELETE", "ResourceRecordSet":{ "Name":"record1", "Type":"CNAME", "SetIdentifier":"record1-ap-northeast", "GeoLocation":{ "CountryCode":"JP" }, "TTL":60, "ResourceRecords":[ { "Value":"record1" } ], "HealthCheckId":"ID" } }, { "Action":"DELETE", "ResourceRecordSet":{ "Name":"record2", "Type":"CNAME", "SetIdentifier":"record2-ap-south",…
I've been trying for a while to get this parser to work correctly but I keep getting the same issue every time. The code is very insistent that the value is null. The issue is this, I have this call…
I have the attached following actions parameter part of my JSON data. 'actions': [{'action_type': 'onsite_conversion.post_save', 'value': '1'}, {'action_type': 'link_click', 'value': '2'}, {'action_type': 'post', 'value': '3'}, {'action_type': 'post_reaction', 'value': '4'}, {'action_type': 'video_view', 'value': '5'}, {'action_type': 'post_engagement', 'value': '6'}, {'action_type': 'page_engagement', 'value':…
I'm new to Jolt Transform and have some EDI data that I want to transform. I want to keep the original data and append a few extracted elements in order to make it easier for a downstream process to get…
I have JSON source array with all values as strings. I'm trying to convert it to another array of typed objects. I'm getting errors. How to properly write this code? Thank you. Error 1: Conversion of type '({ Id: string;…
I have JSON as given below. [ { "users": [ { "name": "alfred", "points": 10 }, { "name": "alice", "points": 11 }, { "name": "emma", "points": 33 } ], "house": "red" }, { "users": [ { "name": "Logan", "points": 20…
I am trying to query using the code below to get the value etoday but it does not return a result. Result = json.loads(json_string) # Next Line works perfect print("The value of msg", "msg", "is: ", Result["msg"]) #Next Line does…