Hey,
I have a JSON 'template' which has been built out with null values in each of the fields and I'd like to then pull new data from an API and overwrite the fields with the new data but I'm unsure how to do this last piece.
My problem is that the API GET doesn't always show all fields as it doesn't list the fields with no data in them, it will only send data for the fields that have data but I need to be able to push data into a DB with all the fields even if they're empty.
What's the best way to approach this as I'm a bit lost as to how best approach it?
This is what I have so far.
[{"id":"d5aee78c5f83a18e","type":"change","z":"3e4770da4706750f","name":"Template","rules":[{"t":"set","p":"payload","pt":"msg","to":"{\"id\":null,\"summary\":null,\"recordType\":null,\"board\":{\"id\":null,\"name\":null,\"_info\":{\"board_href\":null}},\"status\":{\"id\":null,\"name\":null,\"_info\":{\"status_href\":null}},\"company\":{\"id\":null,\"identifier\":null,\"name\":null,\"_info\":{\"company_href\":null,\"mobileGuid\":null}},\"site\":{\"id\":null,\"name\":null,\"_info\":{\"site_href\":null,\"mobileGuid\":null}},\"siteName\":null,\"addressLine1\":null,\"addressLine2\":null,\"city\":null,\"zip\":null,\"country\":{\"id\":null,\"name\":null,\"_info\":{\"country_href\":null}},\"contact\":{\"id\":null,\"name\":null,\"_info\":{\"mobileGuid\":null,\"contact_href\":null}},\"contactName\":null,\"contactPhoneNumber\":null,\"contactPhoneExtension\":null,\"contactEmailAddress\":null,\"type\":{\"id\":null,\"name\":null,\"_info\":{\"type_href\":null}},\"subType\":{\"id\":null,\"name\":null,\"_info\":{\"subType_href\":null}},\"team\":{\"id\":null,\"name\":null,\"_info\":{\"team_href\":null}},\"owner\":{\"id\":null,\"identifier\":null,\"name\":null,\"_info\":{\"member_href\":null,\"image_href\":null}},\"priority\":{\"id\":null,\"name\":null,\"sort\":null,\"_info\":{\"priority_href\":null,\"image_href\":null}},\"serviceLocation\":{\"id\":null,\"name\":null,\"_info\":{\"location_href\":null}},\"source\":{\"id\":null,\"name\":null,\"_info\":{\"source_href\":null}},\"agreement\":{\"id\":null,\"name\":null,\"_info\":{\"agreement_href\":null}},\"severity\":null,\"impact\":null,\"allowAllClientsPortalView\":null,\"customerUpdatedFlag\":null,\"automaticEmailContactFlag\":null,\"automaticEmailResourceFlag\":null,\"automaticEmailCcFlag\":null,\"closedDate\":null,\"closedBy\":null,\"closedFlag\":null,\"acctualHours\":null,\"approved\":null,\"estimatedExpenseCost\":null,\"estimatedExpenseRevenue\":null,\"estimatedProductCost\":null,\"estimatedProductRevenue\":null,\"estimatedTimeCost\":null,\"estimatedTimeRevenue\":null,\"billingMethod\":null,\"subBillingMethod\":null,\"dateResolved\":null,\"dateResplan\":null,\"dateResponded\":null,\"resolveMinutes\":null,\"resPlanMinutes\":null,\"respondMinutes\":null,\"isInSla\":null,\"resources\":null,\"hasChildTicket\":null,\"hasMergedChildTicketFlag\":null,\"billTime\":null,\"billExpenses\":null,\"billProducts\":null,\"location\":{\"id\":null,\"name\":null,\"_info\":{\"location_href\":null}},\"department\":{\"id\":null,\"identifier\":null,\"name\":null,\"_info\":{\"department_href\":null}},\"mobileGuid\":null,\"sla\":{\"id\":null,\"name\":null,\"_info\":{\"sla_href\":null}},\"slaStatus\":null,\"currency\":{\"id\":null,\"symbol\":null,\"currencyCode\":null,\"decimalSeparator\":null,\"numberOfDecimals\":null,\"thousandsSeparator\":null,\"negativeParenthesesFlag\":null,\"displaySymbolFlag\":null,\"currencyIdentifier\":null,\"displayIdFlag\":null,\"rightAlign\":null,\"name\":null,\"_info\":{\"currency_href\":null}},\"_info\":{\"lastUpdated\":null,\"updatedBy\":null,\"dateEntered\":null,\"enteredBy\":null,\"activities_href\":null,\"scheduleentries_href\":null,\"documents_href\":null,\"configurations_href\":null,\"tasks_href\":null,\"notes_href\":null,\"products_href\":null,\"timeentries_href\":null,\"expenseEntries_href\":null},\"c_non_conformance\":{\"id\":null,\"caption\":null,\"type\":null,\"entryMethod\":null,\"numberOfDecimals\":null,\"value\":null},\"c_change_request\":{\"id\":null,\"caption\":null,\"type\":null,\"entryMethod\":null,\"numberOfDecimals\":null,\"value\":null},\"c_out_of_hours\":{\"id\":null,\"caption\":null,\"type\":null,\"entryMethod\":null,\"numberOfDecimals\":null,\"value\":null},\"c_escalted\":{\"id\":null,\"caption\":null,\"type\":null,\"entryMethod\":null,\"numberOfDecimals\":null,\"value\":null}}","tot":"json"}],"action":"","property":"","from":"","to":"","reg":false,"x":340,"y":360,"wires":[["81e9809a055ae2f5"]]},{"id":"81e9809a055ae2f5","type":"change","z":"3e4770da4706750f","name":"New data","rules":[{"t":"set","p":"payload","pt":"msg","to":"{\"summary\":\"Summary\",\"recordType\":\"ServiceTicket\",\"board\":{\"id\":12,\"name\":\"Assigned\",\"_info\":{\"board_href\":\"URL\"}},\"status\":{\"id\":1234,\"name\":\"Complete\",\"_info\":{\"status_href\":\"URL\"}},\"company\":{\"id\":123,\"identifier\":\"Identifier\",\"name\":\"Name\",\"_info\":{\"company_href\":\"URL\",\"mobileGuid\":\"123\"}},\"site\":{\"id\":1422,\"name\":\"Name\",\"_info\":{\"site_href\":\"URL\",\"mobileGuid\":\"123\"}},\"siteName\":\"Name\",\"city\":\"City\",\"stateIdentifier\":\"Location\",\"country\":{\"id\":7,\"name\":\"United Kingdom\",\"_info\":{\"country_href\":\"URL\"}},\"contact\":{\"id\":2174,\"name\":\"User\",\"_info\":{\"mobileGuid\":\"123\",\"contact_href\":\"URL\"}},\"contactName\":\"User\",\"contactPhoneNumber\":\"123\",\"contactEmailAddress\":\"email\",\"type\":{\"id\":1054,\"name\":\"Name\",\"_info\":{\"type_href\":\"URL\"}},\"subType\":{\"id\":2106,\"name\":\"Configuration\",\"_info\":{\"subType_href\":\"URL\"}},\"item\":{\"id\":94,\"name\":\"Extension\",\"_info\":{\"item_href\":\"URL\"}},\"team\":{\"id\":65,\"name\":\"Service Team\",\"_info\":{\"team_href\":\"URL\"}},\"owner\":{\"id\":184,\"identifier\":\"User\",\"name\":\"User\",\"_info\":{\"member_href\":\"URL\",\"image_href\":\"URL\"}},\"priority\":{\"id\":17,\"name\":\"Priority 5\",\"sort\":10,\"_info\":{\"priority_href\":\"URL\",\"image_href\":\"URL\"}},\"serviceLocation\":{\"id\":4,\"name\":\"Remote\",\"_info\":{\"location_href\":\"URL\"}},\"source\":{\"id\":3,\"name\":\"Internal\",\"_info\":{\"source_href\":\"URL\"}},\"severity\":\"Low\",\"impact\":\"Low\",\"allowAllClientsPortalView\":false,\"customerUpdatedFlag\":false,\"automaticEmailContactFlag\":false,\"automaticEmailResourceFlag\":false,\"automaticEmailCcFlag\":false,\"closedDate\":\"2022-03-25T15:18:56Z\",\"closedBy\":\"User\",\"closedFlag\":true,\"actualHours\":0.5,\"approved\":true,\"estimatedExpenseCost\":0,\"estimatedExpenseRevenue\":0,\"estimatedProductCost\":0,\"estimatedProductRevenue\":0,\"estimatedTimeCost\":0,\"estimatedTimeRevenue\":0,\"billingMethod\":\"ActualRates\",\"subBillingMethod\":\"ActualRates\",\"dateResolved\":\"2022-03-25T15:18:56Z\",\"dateResplan\":\"2022-03-25T14:57:44Z\",\"dateResponded\":\"2022-03-25T14:57:05Z\",\"resolveMinutes\":0,\"resPlanMinutes\":0,\"respondMinutes\":0,\"isInSla\":true,\"resources\":\"User\",\"hasChildTicket\":false,\"hasMergedChildTicketFlag\":false,\"billTime\":\"NoDefault\",\"billExpenses\":\"NoDefault\",\"billProducts\":\"NoDefault\",\"location\":{\"id\":11,\"name\":\"Location\",\"_info\":{\"location_href\":\"URL\"}},\"department\":{\"id\":1,\"identifier\":\"Helpdesk\",\"name\":\"Helpdesk\",\"_info\":{\"department_href\":\"URL\"}},\"mobileGuid\":\"123\",\"sla\":{\"id\":2,\"name\":\"SLA\",\"_info\":{\"sla_href\":\"URL\"}},\"slaStatus\":\"Resolved\",\"currency\":{\"id\":5,\"symbol\":\"Ā£\",\"currencyCode\":\"GBP\",\"decimalSeparator\":\".\",\"numberOfDecimals\":2,\"thousandsSeparator\":\",\",\"negativeParenthesesFlag\":false,\"displaySymbolFlag\":true,\"currencyIdentifier\":\"GBP\",\"displayIdFlag\":true,\"rightAlign\":false,\"name\":\"British Pounds\",\"_info\":{\"currency_href\":\"URL\"}},\"_info\":{\"lastUpdated\":\"2022-03-25T15:19:21Z\",\"updatedBy\":\"User\",\"dateEntered\":\"2022-03-25T14:57:03Z\",\"enteredBy\":\"User\",\"activities_href\":\"URL\",\"scheduleentries_href\":\"URL\",\"documents_href\":\"URL\",\"configurations_href\":\"URL\",\"tasks_href\":\"URL\",\"notes_href\":\"URL\",\"products_href\":\"URL\",\"timeentries_href\":\"URL\",\"expenseEntries_href\":\"URL\"},\"customFields\":[{\"id\":1,\"caption\":\"Non-conformance\",\"type\":\"Checkbox\",\"entryMethod\":\"EntryField\",\"numberOfDecimals\":0,\"value\":false},{\"id\":2,\"caption\":\"Change Request\",\"type\":\"Checkbox\",\"entryMethod\":\"EntryField\",\"numberOfDecimals\":0,\"value\":false},{\"id\":10,\"caption\":\"Out of Hours\",\"type\":\"Checkbox\",\"entryMethod\":\"EntryField\",\"numberOfDecimals\":0,\"value\":false},{\"id\":11,\"caption\":\"Escalated\",\"type\":\"Checkbox\",\"entryMethod\":\"EntryField\",\"numberOfDecimals\":0,\"value\":false}]}","tot":"json"}],"action":"","property":"","from":"","to":"","reg":false,"x":520,"y":360,"wires":[["9f3440c5db5bd116"]]},{"id":"41510ca0d2614fbb","type":"inject","z":"3e4770da4706750f","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":160,"y":360,"wires":[["d5aee78c5f83a18e"]]},{"id":"9f3440c5db5bd116","type":"debug","z":"3e4770da4706750f","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":710,"y":360,"wires":[]},{"id":"da29f1f46ae45229","type":"change","z":"3e4770da4706750f","name":"Required output","rules":[{"t":"set","p":"payload","pt":"msg","to":"{\"id\":null,\"summary\":\"Summary\",\"recordType\":\"ServiceTicket\",\"board\":{\"id\":12,\"name\":\"Assigned\",\"_info\":{\"board_href\":\"URL\"}},\"status\":{\"id\":1234,\"name\":\"Complete\",\"_info\":{\"status_href\":\"URL\"}},\"company\":{\"id\":123,\"identifier\":\"Identifier\",\"name\":\"Name\",\"_info\":{\"company_href\":\"URL\",\"mobileGuid\":\"123\"}},\"site\":{\"id\":1422,\"name\":\"Name\",\"_info\":{\"site_href\":\"URL\",\"mobileGuid\":\"123\"}},\"siteName\":\"Name\",\"city\":\"City\",\"stateIdentifier\":\"Location\",\"country\":{\"id\":7,\"name\":\"United Kingdom\",\"_info\":{\"country_href\":\"URL\"}},\"contact\":{\"id\":2174,\"name\":\"User\",\"_info\":{\"mobileGuid\":\"123\",\"contact_href\":\"URL\"}},\"contactName\":\"User\",\"contactPhoneNumber\":\"123\",\"contactEmailAddress\":\"email\",\"type\":{\"id\":1054,\"name\":\"Name\",\"_info\":{\"type_href\":\"URL\"}},\"subType\":{\"id\":2106,\"name\":\"Configuration\",\"_info\":{\"subType_href\":\"URL\"}},\"item\":{\"id\":94,\"name\":\"Extension\",\"_info\":{\"item_href\":\"URL\"}},\"team\":{\"id\":65,\"name\":\"Service Team\",\"_info\":{\"team_href\":\"URL\"}},\"owner\":{\"id\":184,\"identifier\":\"User\",\"name\":\"User\",\"_info\":{\"member_href\":\"URL\",\"image_href\":\"URL\"}},\"priority\":{\"id\":17,\"name\":\"Priority 5\",\"sort\":10,\"_info\":{\"priority_href\":\"URL\",\"image_href\":\"URL\"}},\"serviceLocation\":{\"id\":4,\"name\":\"Remote\",\"_info\":{\"location_href\":\"URL\"}},\"source\":{\"id\":3,\"name\":\"Internal\",\"_info\":{\"source_href\":\"URL\"}},\"severity\":\"Low\",\"impact\":\"Low\",\"allowAllClientsPortalView\":false,\"customerUpdatedFlag\":false,\"automaticEmailContactFlag\":false,\"automaticEmailResourceFlag\":false,\"automaticEmailCcFlag\":false,\"closedDate\":\"2022-03-25T15:18:56Z\",\"closedBy\":\"User\",\"closedFlag\":true,\"actualHours\":0.5,\"approved\":true,\"estimatedExpenseCost\":0,\"estimatedExpenseRevenue\":0,\"estimatedProductCost\":0,\"estimatedProductRevenue\":0,\"estimatedTimeCost\":0,\"estimatedTimeRevenue\":0,\"billingMethod\":\"ActualRates\",\"subBillingMethod\":\"ActualRates\",\"dateResolved\":\"2022-03-25T15:18:56Z\",\"dateResplan\":\"2022-03-25T14:57:44Z\",\"dateResponded\":\"2022-03-25T14:57:05Z\",\"resolveMinutes\":0,\"resPlanMinutes\":0,\"respondMinutes\":0,\"isInSla\":true,\"resources\":\"User\",\"hasChildTicket\":false,\"hasMergedChildTicketFlag\":false,\"billTime\":\"NoDefault\",\"billExpenses\":\"NoDefault\",\"billProducts\":\"NoDefault\",\"location\":{\"id\":11,\"name\":\"Location\",\"_info\":{\"location_href\":\"URL\"}},\"department\":{\"id\":1,\"identifier\":\"Helpdesk\",\"name\":\"Helpdesk\",\"_info\":{\"department_href\":\"URL\"}},\"mobileGuid\":\"123\",\"sla\":{\"id\":2,\"name\":\"SLA\",\"_info\":{\"sla_href\":\"URL\"}},\"slaStatus\":\"Resolved\",\"currency\":{\"id\":5,\"symbol\":\"Ā£\",\"currencyCode\":\"GBP\",\"decimalSeparator\":\".\",\"numberOfDecimals\":2,\"thousandsSeparator\":\",\",\"negativeParenthesesFlag\":false,\"displaySymbolFlag\":true,\"currencyIdentifier\":\"GBP\",\"displayIdFlag\":true,\"rightAlign\":false,\"name\":\"British Pounds\",\"_info\":{\"currency_href\":\"URL\"}},\"_info\":{\"lastUpdated\":\"2022-03-25T15:19:21Z\",\"updatedBy\":\"User\",\"dateEntered\":\"2022-03-25T14:57:03Z\",\"enteredBy\":\"User\",\"activities_href\":\"URL\",\"scheduleentries_href\":\"URL\",\"documents_href\":\"URL\",\"configurations_href\":\"URL\",\"tasks_href\":\"URL\",\"notes_href\":\"URL\",\"products_href\":\"URL\",\"timeentries_href\":\"URL\",\"expenseEntries_href\":\"URL\"},\"customFields\":[{\"id\":1,\"caption\":\"Non-conformance\",\"type\":\"Checkbox\",\"entryMethod\":\"EntryField\",\"numberOfDecimals\":0,\"value\":false},{\"id\":2,\"caption\":\"Change Request\",\"type\":\"Checkbox\",\"entryMethod\":\"EntryField\",\"numberOfDecimals\":0,\"value\":false},{\"id\":10,\"caption\":\"Out of Hours\",\"type\":\"Checkbox\",\"entryMethod\":\"EntryField\",\"numberOfDecimals\":0,\"value\":false},{\"id\":11,\"caption\":\"Escalated\",\"type\":\"Checkbox\",\"entryMethod\":\"EntryField\",\"numberOfDecimals\":0,\"value\":false}]}","tot":"json"}],"action":"","property":"","from":"","to":"","reg":false,"x":440,"y":440,"wires":[["a5eb492087f4cd1b"]]},{"id":"596cc80d3d182154","type":"inject","z":"3e4770da4706750f","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":160,"y":440,"wires":[["da29f1f46ae45229"]]},{"id":"a5eb492087f4cd1b","type":"debug","z":"3e4770da4706750f","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":710,"y":440,"wires":[]}]
