JSON Import Mapping produces empty object/field when applied twice in a microflow

0
Hi - I have a JSON file that contains FirstName_Sender, LastName_Sender, Email_Sender and FirstName_ReferredPerson, LastName_ReferredPerson, Email_ReferredPerson. I have a JSON structure reflecting the six fields. I have two import mappings: importMap_Sender ands ImportMap_Receiver. Both with an object "invididual" being lookedup in the database and when not found (via email as a key) it is created. I am trying to use both import-mappings in one microflow, producing two "individual" objects, one $sender, one $referredPerson. It's not happening, the second import-mapping always produces empty fields resulting in an error where 'empty' in a key field (of the import-mapping) causes a crash.   WHY????
asked
3 answers
0

image.png

So don't get confused by the parameter JSONschema. It is an object with a string attribute containing the JSON data as follows:

{
  "FirstName_Sender": "Boris",
  "LastName_Sender": "Scharinger",
  "EmailAddress_Sender": "boris.scharinger@siemens.com",
  "Company_Sender": "Siemens AG",
  "FirstName_ReferredPerson": "Benno",
  "LastName_ReferredPerson": "Blumoser",
  "EmailAddress_ReferredPerson": "Benno.blumoser@siemens.com",
  "Company_ReferredPerson": "Siemens AG"
}
{
  "FirstName_Sender": "Boris",
  "LastName_Sender": "Scharinger",
  "EmailAddress_Sender": "boris.scharinger@siemens.com",
  "Company_Sender": "Siemens AG",
  "FirstName_ReferredPerson": "Benno",
  "LastName_ReferredPerson": "Blumoser",
  "EmailAddress_ReferredPerson": "Benno.blumoser@siemens.com",
  "Company_ReferredPerson": "Siemens AG"
}

the variable "ResultString" takes it from there and carries it forward.

answered
0

JSON Mapping 1:

image.png

answered
0

JSON Mapping 2:

image.png

answered