Happy Business Starts Here

Highlighted
Partner

INVALID_FIELD::invalid field for query: InvoiceItem.productrateplanchargeid

I'm trying to get the invoiceItem.productrateplanchargeid, but an error is returned 

 

INVALID_FIELD::invalid field for query: InvoiceItem.productrateplanchargeid

 

 

Any ideas?

 

Thanks,

Fred

Frontera Consulting
Oracle, Salesforce and Zuora Consultants
Tags (2)
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Zuora Support Moderator

Re: INVALID_FIELD::invalid field for query: InvoiceItem.productrateplanchargeid

@fredkao - I think I understand what you mean. I did a quick query and got the same response.

 

Upon reviewing with documentation for the SOAP InvoiceItem Object, you'll see that there are no actions listed next to the ProductRatePlanCharge field.

My colleague did a quick check with our engineering team and got this clarification: 

 

Only the subscribe() preview and the amend() preview call will return InvoiceItem.ProductRatePlanChargeId with a value.

 

 

I realize our documentation is currently lacking this extra detail so I am working with our doc team to get this updated.

 



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

View solution in original post

3 REPLIES 3
Highlighted
Guru

Re: INVALID_FIELD::invalid field for query: InvoiceItem.productrateplanchargeid

Can you state more of what you are doing and show some code?

Maggie Longshore
Highlighted
Zuora Support Moderator

Re: INVALID_FIELD::invalid field for query: InvoiceItem.productrateplanchargeid

@fredkao - I think I understand what you mean. I did a quick query and got the same response.

 

Upon reviewing with documentation for the SOAP InvoiceItem Object, you'll see that there are no actions listed next to the ProductRatePlanCharge field.

My colleague did a quick check with our engineering team and got this clarification: 

 

Only the subscribe() preview and the amend() preview call will return InvoiceItem.ProductRatePlanChargeId with a value.

 

 

I realize our documentation is currently lacking this extra detail so I am working with our doc team to get this updated.

 



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

View solution in original post

Highlighted
Partner

Re: INVALID_FIELD::invalid field for query: InvoiceItem.productrateplanchargeid

 

@MaggieL

Just a simple query: 

 

select productrateplanid from invoiceitem where id = '2c92a098558231140155938ed8ce5e95'

 

 

@AmyLy  Thanks!

 

Frontera Consulting
Oracle, Salesforce and Zuora Consultants