I’m currently getting items in a queue. So I get the queueItems Output and it is IEnumberable
List(6)
{
QueueItem
{
AssignedTo=null,
DeferDate=null,
DueDate=null,
Id=14438,
ItemKey=[15d689a5-6725-45d0-b410-6860ab57a607],
LastProcessingOn=null,
Output=null,
ParentOperationId=null,
Priority=High,
ProcessingException=null,
Progress=null,
QueueDefinitionId=82,
QueueName=“Safe Harbor Re-Entry”,
Reference=“2025-09-12-12.57.59.831940T01”,
RetryNo=0,
ReviewStatus=“None”,
RowVersion=byte[8]
{
0,
0,
0,
0,
0,
1,
51,
143
},
SpecificContent=Dictionary<string, object>(16)
{
{
"Status",
"BOTASSIST"
},
{
"ProcessType",
"PCXSAFEHRBR"
},
{
"SSN",
"853195327"
},
{
"Fund",
"921"
},
{
"AcctNumberPre",
"498742518"
},
{
"PreTaxAmt",
"2500.00"
},
{
"AcctNumberRoth",
"0"
},
{
"RothAmt",
"0"
},
{
"AfterTaxAmt",
"0"
},
{
"RepId",
"123456"
},
{
"PartnerCode",
"PXPEPFO"
},
{
"NewClient",
true
},
{
"NoFeeorCollateral",
false
},
{
"Fee Child Id",
"2025-09-12-12.57.59.831940T01"
},
{
"Fee Parent Id",
"2025-09-12-12.57.59.569940C01"
},
{
"JSON",
"
{
'ProcessType':'PCXSAFEHRBR','Partner_Code':'PXPEPFO','Plan_num':'123456','Plan_name':'ABC Co 401K Plan','social_security_num':' 853195327','participant_first_nam':'EDWARD','participant_mdl_nam':'0','participant_last_nam':'HENLEY','address_1_txt':'PO BOX 56','address_2_txt':'0','city_nam':'BARNARDSVILLE','state_or_province_nam':'NC','zip_cd':'28709','birth_dt':'04-14-1975','phone_num':'0','email':'0','pre_tax_amount':'2500.00','roth_amount':'0','after_tax_amount':'0','total_market_value':'2500.00'
}"
}
},
StartTransactionTime=null,
Status=New
},
QueueItem
{
AssignedTo=null,
DeferDate=null,
DueDate=null,
Id=14435,
ItemKey=[8140adc8-8c55-4621-bb0b-5fc3fc4c745c],
LastProcessingOn=null,
Output=null,
ParentOperationId=null,
Priority=High,
ProcessingException=null,
Progress=null,
QueueDefinitionId=82,
QueueName=“Safe Harbor Re-Entry”,
Reference=“2025-09-12-10.25.09.263940T01”,
RetryNo=0,
ReviewStatus=“None”,
RowVersion=byte[8]
{
0,
0,
0,
0,
0,
1,
51,
89
},
SpecificContent=Dictionary<string, object>(16)
{
{
"Status",
"BOTASSIST"
},
{
"ProcessType",
"PCXSAFEHRBR"
},
{
"SSN",
"568659428"
},
{
"Fund",
"921"
},
{
"AcctNumberPre",
"692358976"
},
{
"PreTaxAmt",
"4000.00"
},
{
"AcctNumberRoth",
"0"
},
{
"RothAmt",
"0"
},
{
"AfterTaxAmt",
"0"
},
{
"RepId",
"123456"
},
{
"PartnerCode",
"PXVRO"
},
{
"NewClient",
true
},
{
"NoFeeorCollateral",
false
},
{
"Fee Child Id",
"2025-09-12-10.25.09.263940T01"
},
{
"Fee Parent Id",
"2025-09-12-10.25.09.002940C01"
},
{
"JSON",
"
{
'ProcessType':'PCXSAFEHRBR','Partner_Code':'PXVRO','Plan_num':'123456','Plan_name':'ABC Co 401K Plan','social_security_num':' 568659428','participant_first_nam':'MICHELLE','participant_mdl_nam':'0','participant_last_nam':'PRATT','address_1_txt':'1699 ROSEMIST LN','address_2_txt':'0','city_nam':'CHINO HILLS','state_or_province_nam':'CA','zip_cd':'91709','birth_dt':'01-12-1966','phone_num':'0','email':'0','pre_tax_amount':'4000.00','roth_amount':'0','after_tax_amount':'0','total_market_value':'4000.00'
}"
}
},
StartTransactionTime=null,
Status=New
},
QueueItem
{
AssignedTo=null,
DeferDate=null,
DueDate=null,
Id=14434,
ItemKey=[4468b6b4-60a2-46e5-aba7-7c351b38de5e],
LastProcessingOn=null,
Output=null,
ParentOperationId=null,
Priority=High,
ProcessingException=null,
Progress=null,
QueueDefinitionId=82,
QueueName=“Safe Harbor Re-Entry”,
Reference=“2025-09-12-10.24.29.921940T01”,
RetryNo=0,
ReviewStatus=“None”,
RowVersion=byte[8]
{
0,
0,
0,
0,
0,
1,
51,
86
},
SpecificContent=Dictionary<string, object>(16)
{
{
"Status",
"BOTASSIST"
},
{
"ProcessType",
"PCXSAFEHRBR"
},
{
"SSN",
"600600552"
},
{
"Fund",
"921"
},
{
"AcctNumberPre",
"692358975"
},
{
"PreTaxAmt",
"114.00"
},
{
"AcctNumberRoth",
"0"
},
{
"RothAmt",
"0"
},
{
"AfterTaxAmt",
"0"
},
{
"RepId",
"123456"
},
{
"PartnerCode",
"PXFOIRA"
},
{
"NewClient",
true
},
{
"NoFeeorCollateral",
false
},
{
"Fee Child Id",
"2025-09-12-10.24.29.921940T01"
},
{
"Fee Parent Id",
"2025-09-12-10.24.29.672940C01"
},
{
"JSON",
"
{
'ProcessType':'PCXSAFEHRBR','Partner_Code':'PXFOIRA','Plan_num':'123456','Plan_name':'ABC Co 401K Plan','social_security_num':' 600600552','participant_first_nam':'ACI','participant_mdl_nam':'TEST','participant_last_nam':'TEST','address_1_txt':'4500 Main St','address_2_txt':'0','city_nam':'Kansas City','state_or_province_nam':'MO','zip_cd':'64111','birth_dt':'06-01-1997','phone_num':'0','email':'0','pre_tax_amount':'114.00','roth_amount':'0','after_tax_amount':'0','total_market_value':'114.00'
}"
}
},
StartTransactionTime=null,
Status=New
},
QueueItem
{
AssignedTo=null,
DeferDate=null,
DueDate=null,
Id=14433,
ItemKey=[de7b39c2-9d53-419f-8b5c-9aa1ebd40e0d],
LastProcessingOn=null,
Output=null,
ParentOperationId=null,
Priority=High,
ProcessingException=null,
Progress=null,
QueueDefinitionId=82,
QueueName=“Safe Harbor Re-Entry”,
Reference=“2025-09-12-10.23.51.396940T01”,
RetryNo=0,
ReviewStatus=“None”,
RowVersion=byte[8]
{
0,
0,
0,
0,
0,
1,
51,
82
},
SpecificContent=Dictionary<string, object>(16)
{
{
"Status",
"BOTASSIST"
},
{
"ProcessType",
"PCXSAFEHRBR"
},
{
"SSN",
"613145274"
},
{
"Fund",
"921"
},
{
"AcctNumberPre",
"692358974"
},
{
"PreTaxAmt",
"1200.00"
},
{
"AcctNumberRoth",
"0"
},
{
"RothAmt",
"0"
},
{
"AfterTaxAmt",
"0"
},
{
"RepId",
"123456"
},
{
"PartnerCode",
"PXPEPVRO"
},
{
"NewClient",
true
},
{
"NoFeeorCollateral",
false
},
{
"Fee Child Id",
"2025-09-12-10.23.51.396940T01"
},
{
"Fee Parent Id",
"2025-09-12-10.23.51.109940C01"
},
{
"JSON",
"
{
'ProcessType':'PCXSAFEHRBR','Partner_Code':'PXPEPVRO','Plan_num':'123456','Plan_name':'ABC Co 401K Plan','social_security_num':' 613145274','participant_first_nam':'MARTIN','participant_mdl_nam':'0','participant_last_nam':'MURILLO','address_1_txt':'5813 e 16TH TER','address_2_txt':'0','city_nam':'Kansas City','state_or_province_nam':'MO','zip_cd':'64126','birth_dt':'09-15-1970','phone_num':'0','email':'0','pre_tax_amount':'1200.00','roth_amount':'0','after_tax_amount':'0','total_market_value':'1200.00'
}"
}
},
StartTransactionTime=null,
Status=New
},
QueueItem
{
AssignedTo=null,
DeferDate=null,
DueDate=null,
Id=14431,
ItemKey=[b4f129f7-5822-49b6-ab7e-8b8f6348115e],
LastProcessingOn=null,
Output=null,
ParentOperationId=null,
Priority=High,
ProcessingException=null,
Progress=null,
QueueDefinitionId=82,
QueueName=“Safe Harbor Re-Entry”,
Reference=“2025-09-12-10.23.07.635940T01”,
RetryNo=0,
ReviewStatus=“None”,
RowVersion=byte[8]
{
0,
0,
0,
0,
0,
1,
51,
72
},
SpecificContent=Dictionary<string, object>(16)
{
{
"Status",
"BOTASSIST"
},
{
"ProcessType",
"PCXSAFEHRBR"
},
{
"SSN",
"867777702"
},
{
"Fund",
"921"
},
{
"AcctNumberPre",
"692358972"
},
{
"PreTaxAmt",
"1300.00"
},
{
"AcctNumberRoth",
"692358973"
},
{
"RothAmt",
"150.00"
},
{
"AfterTaxAmt",
"0"
},
{
"RepId",
"123456"
},
{
"PartnerCode",
"PXPTS7K"
},
{
"NewClient",
true
},
{
"NoFeeorCollateral",
false
},
{
"Fee Child Id",
"2025-09-12-10.23.07.635940T01"
},
{
"Fee Parent Id",
"2025-09-12-10.23.07.327940C01"
},
{
"JSON",
"
{
'ProcessType':'PCXSAFEHRBR','Partner_Code':'PXPTS7K','Plan_num':'123456','Plan_name':'ABC Co 401K Plan','social_security_num':' 867777702','participant_first_nam':'MONTY','participant_mdl_nam':'0','participant_last_nam':'MCDONALD','address_1_txt':'2523 N Shefford Ct','address_2_txt':'0','city_nam':'Wichita','state_or_province_nam':'KS','zip_cd':'67205','birth_dt':'11-11-1975','phone_num':'0','email':'0','pre_tax_amount':'1300.00','roth_amount':'150.00','after_tax_amount':'0','total_market_value':'1450.00'
}"
}
},
StartTransactionTime=null,
Status=New
},
QueueItem
{
AssignedTo=null,
DeferDate=null,
DueDate=null,
Id=14430,
ItemKey=[46966a6f-5098-40c7-83a9-fa2f2bd73ae0],
LastProcessingOn=null,
Output=null,
ParentOperationId=null,
Priority=High,
ProcessingException=null,
Progress=null,
QueueDefinitionId=82,
QueueName=“Safe Harbor Re-Entry”,
Reference=“2025-09-12-10.22.23.994940T01”,
RetryNo=0,
ReviewStatus=“None”,
RowVersion=byte[8]
{
0,
0,
0,
0,
0,
1,
51,
69
},
SpecificContent=Dictionary<string, object>(16)
{
{
"Status",
"BOTASSIST"
},
{
"ProcessType",
"PCXSAFEHRBR"
},
{
"SSN",
"867777702"
},
{
"Fund",
"921"
},
{
"AcctNumberPre",
"692358970"
},
{
"PreTaxAmt",
"1000.00"
},
{
"AcctNumberRoth",
"692358971"
},
{
"RothAmt",
"100.00"
},
{
"AfterTaxAmt",
"0"
},
{
"RepId",
"123456"
},
{
"PartnerCode",
"PXPTS"
},
{
"NewClient",
true
},
{
"NoFeeorCollateral",
false
},
{
"Fee Child Id",
"2025-09-12-10.22.23.994940T01"
},
{
"Fee Parent Id",
"2025-09-12-10.22.23.690940C01"
},
{
"JSON",
"
{
'ProcessType':'PCXSAFEHRBR','Partner_Code':'PXPTS','Plan_num':'123456','Plan_name':'ABC Co 401K Plan','social_security_num':' 867777702','participant_first_nam':'MONTY','participant_mdl_nam':'0','participant_last_nam':'MCDONALD','address_1_txt':'2523 N Shefford Ct','address_2_txt':'0','city_nam':'Wichita','state_or_province_nam':'KS','zip_cd':'67205','birth_dt':'11-11-1975','phone_num':'0','email':'0','pre_tax_amount':'1000.00','roth_amount':'100.00','after_tax_amount':'0','total_market_value':'1100.00'
}"
}
},
StartTransactionTime=null,
Status=New
}
}
It pulls the queue items and then I’m doing a matching to see if it matches a record in SQL and that is working fine.
DataRow
{
HasErrors=false,
ItemArray=object[6]
{
“2025-09-12-10.22.23.994940”,
"ACCTSVCS ",
"SHFEE ",
"BOTREADY ",
“BOTPROC “,
“2025-09-10”
},
RowError=””,
RowState=Unchanged,
Table=
}
After I get the matched rows I’m assigning Fee Child ID, CheckDate–working
Matched Item - ID: 2025-09-12-10.22.23.994940T01, Reference: 2025-09-12-10.22.23.994940T01, Status: New
Fee Child ID: 2025-09-12-10.22.23.994940T01
Check Date: 091025
I have created an updated Content=New Dictionary(Of String, Object)(item.SpecificContent)
that works too.
Updating Status in the queue item in Specific Content
Adding Check Date to the Specific Content
But when I try to add this to the Queue Item I get this:
Add Queue Item Safe Harbor Fee Removal: Could not determine JSON object type for type System.Collections.Generic.KeyValuePair`2[System.String,System.Object].
Any suggestions on this issue?