Sitecore Powershell script - Mapping JSON into Sitecore Items

 With Sitecore everything seems to be possible. We can convert the Sitecore Items into JSON format and vice versa.

Recently we have received once such requirement of converting third party JSON in Sitecore Items. I would like to share my experience of exploring Conversion of JSON into Item using Sitecore Powershell.

      Given the option for Content authors to choose the file and store in Temp folder of Sitecore CM server(depends on scenario this can be modified).

     Based on the JSON file format, I have created the Sitecore Items.

     Here goes my Sample JSON:

    

    

As per this sample JSON, My field mappings goes little different may not be the same.

Employee Template===>                   

    EmployeeId-->       "emplid"

           EmployeeName -->  "name"    

                   EmployeeAddress--> "address"    

                                                EmployeeContactNumber--> "contact_number"

                                                     EmployeeDept-->  "Node_name" (eg:"IT","CS")

Please find the powershell snippet:

$dataFolder = [Sitecore.Configuration.Settings]::DataFolder

$tempFolder = $dataFolder + "\temp\upload"

$filePath = Receive-File -Path $tempFolder -overwrite

$itemPath ="/sitecore/content/sample-prjct/Content/EmployeeData"

$templateID="{70CD4D36-64AB-4450-8A5A-E0BC18A962E2}"

$a = Get-Content -Path $filePath  | ConvertFrom-Json

$a = $a.psobject.properties | select name,value 

$a | foreach { 

    $_.value =   $_.value.psobject.properties | select name,value 

    try

{

    $item = New-Item -Path $itemPath -Name $_.value.value[1]  -ItemType $templateID

}

catch

{

    write-host "Failed to create Item: " $itemPath                

write-host $_.Exception.Message    

exit

}

if($item){

    

$item.Editing.BeginEdit()

$item["EmployeeId"]= $_.value.value[0]

$item["EmployeeName"]= $_.value.value[1]

$item["EmployeeAddress"]= $_.value.value[2]

$item["EmployeeContactNumber"]= $_.value.value[3]

$item["EmployeeDept"]=$_.Name

$item.Editing.EndEdit()

}

}

Sitecore Template

Powershell Script execution  - Outcomes

                   I have attached the outcomes after the execution of powershell scripts.  

If the items has been created successfully, the response would be true as in the attached snapshot.

     Final Item in Sitecore

Quick Flowchart Representation

Happy Sitecore learning!!!