cancel
Showing results for 
Search instead for 
Did you mean: 

SAP CP Integration to SuccessFactors : oData read error [("value") can not be null or empty!]

1a1t1u2y
Explorer
0 Kudos

Hi

I'm trying to create SAP SuceesFactors application by using webIDE.

I set odata model in my view, the Entity name is "FormCompetency", but no data returned when I called oModel.read()

method.

I could read other entities such as "User", "FormHeader" and so on, so destination settings in SAP CP is appropriate.

var formcompetency = this.getOwnerComponent().getModel("FormCompetency");
var tmp;
var Filter3 = new sap.ui.model.Filter({
		filters: [
			new sap.ui.model.Filter("formContentId", "EQ", 11111), //primarykey 1
			new sap.ui.model.Filter("formDataId", "EQ", 22222),    //primarykey 2
			new sap.ui.model.Filter("itemId", "EQ", 33333),        //primarykey 3
			new sap.ui.model.Filter("sectionIndex", "EQ", 1)       //primarykey 4
		],
		and: true
	});
//select single record and store tmp
formcompetency.read("/FormCompetency", {
                filters: [Filter3],
	        success: function (oData) {
		tmp = oData;
	},
	error: function (oData) {
	}
});

I got error message like below image despite I set all primary keys in filters[].


Is query in my controller.js wrong?

Or Should I need to do some settings in my SF environment?

Please give me advise.

Regards,

*Apr 27 Updated*


I've tried '/FormCompetency(formContentId=11111,formDataId=22222,itemId=33333,sectionIndex=1)' , but error wasn't resolved.

I added network trace evidence below.

WouterLemaire
Active Contributor
0 Kudos

Have you tried using double quotes around the value? Can you share the network trace from your development tools? Why not reading the entity with keys ? For example /FormCompetency(formContentId=111,...)

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hello,

I see there is a difference between in your code "sectionIndex" and in error "sectIndex". Correct it and confirm if it works?

Best regards,

Anna.

1a1t1u2y
Explorer
0 Kudos

Thank you for your comment!

I've changed the property name and tried again.

However, error message didn't disappeared.

best regards,

Yuta.