DevClub

Dev Answers & Best Practices rest API v11_1 filter not working with link relation(cases)

Click here to join "DevClub" to engage in the conversation with this group and curate your SugarClub experience.

rest API v11_1 filter not working with link relation(cases)

Ashwani Kumar Rai over 2 years ago

Using below URL

{{url}}/rest/v11_1/Accounts/4bb0263d-257c-4e27-8d37-4fa8c0a507a1/link/cases/filter

And POST following data

{"filter":[{"date_entered":{"$lt":"2018-12-03 07:41:31"}}]}

Result obtained

{
"error": "not_found",
"error_message": "Could not find the related bean"
}

Any one help me what is wrong with this rest call.

Although this api call working {{url}}/rest/v11_1/Accounts/4bb0263d-257c-4e27-8d37-4fa8c0a507a1/link/cases

0 André Lopes over 2 years ago

Hi Ashwani Kumar Rai
You have to remove the string "/filter" from the end of url.
Your url must be:
{{url}}/rest/v11_1/Accounts/4bb0263d-257c-4e27-8d37-4fa8c0a507a1/link/cases
Regards

André Lopes
Lampada Global

Skype: andre.lampada
Cancel
Up 0 Down

Reply

Reject Answer

Cancel
0 Ashwani Kumar Rai over 2 years ago in reply to André Lopes

Hi Lopes,
As I mentioned this link working
{{url}}/rest/v11_1/Accounts/4bb0263d-257c-4e27-8d37-4fa8c0a507a1/link/cases
Now it's working using query string parameter
{{url}}/rest/v11_1/Accounts/4bb0263d-257c-4e27-8d37-4fa8c0a507a1/link/cases?fields=urlencode('id,case_number,name,date_entered,priority,status,sanket_enable_c')&filter[0][date_entered][$gt]=urlencode('2017-08-09 00:00:00')
Thanks for your prompt response
Cancel
Up 0 Down

Reply

Verify Answer

Cancel