You need to sign in to do that
Don't have an account?
Yaroslav Pro
JSON sfdx create records
Hi everyone I have used for creating records next script and run next command
sfdx force:data:tree:import -p data\\import-Data-plan.json -u org
The issue is I want to create records with Date__c = current date,
How I can solve this using script for creating records, now date is hardcode and it's wrong, Let me know!
{
"records": [
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef1"
},
"Date__c": "2019-10-01",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 400
},
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef2"
},
"Date__c": "2019-10-02",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 200
},
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef3"
},
"Date__c": "2019-10-03",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 200
},
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef4"
},
"Date__c": "2019-10-04",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 300
},
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef5"
},
"Date__c": "2019-10-05",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 185
},
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef6"
},
"Date__c": "2019-10-06",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 195
},
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef7"
},
"Date__c": "2019-10-07",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 140
},
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef8"
},
"Date__c": "2019-10-08",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 300
},
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef9"
},
"Date__c": "2019-10-09",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 250
},
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef10"
},
"Date__c": "2019-10-10",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 500
},
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef11"
},
"Date__c": "2019-10-11",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 300
},
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef12"
},
"Date__c": "2019-10-12",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 200
},
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef13"
},
"Date__c": "2019-10-13",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 120
}
]
}
sfdx force:data:tree:import -p data\\import-Data-plan.json -u org
The issue is I want to create records with Date__c = current date,
How I can solve this using script for creating records, now date is hardcode and it's wrong, Let me know!
{
"records": [
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef1"
},
"Date__c": "2019-10-01",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 400
},
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef2"
},
"Date__c": "2019-10-02",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 200
},
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef3"
},
"Date__c": "2019-10-03",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 200
},
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef4"
},
"Date__c": "2019-10-04",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 300
},
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef5"
},
"Date__c": "2019-10-05",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 185
},
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef6"
},
"Date__c": "2019-10-06",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 195
},
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef7"
},
"Date__c": "2019-10-07",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 140
},
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef8"
},
"Date__c": "2019-10-08",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 300
},
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef9"
},
"Date__c": "2019-10-09",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 250
},
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef10"
},
"Date__c": "2019-10-10",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 500
},
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef11"
},
"Date__c": "2019-10-11",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 300
},
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef12"
},
"Date__c": "2019-10-12",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 200
},
{
"attributes": {
"type": "TC_UserTimePick__c",
"referenceId": "TC_TimesheetGroup__cRef13"
},
"Date__c": "2019-10-13",
"Activity__c": "@TC_ActivityGroupAssignment__cRef1",
"Minutes__c": 120
}
]
}