{"id":12519,"date":"2018-07-27T15:34:11","date_gmt":"2018-07-27T10:04:11","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=12519"},"modified":"2018-07-27T15:34:11","modified_gmt":"2018-07-27T10:04:11","slug":"use-web-api-batch-request-in-dynamics-365-to-execute-long-fetchxml","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2018\/07\/use-web-api-batch-request-in-dynamics-365-to-execute-long-fetchxml\/","title":{"rendered":"Use WEB API Batch Request in Dynamics 365 to execute long FetchXML"},"content":{"rendered":"

Introduction:<\/strong><\/h2>\n

Recently we had a project where we use WEB API for retrieve the records from Dynamics CRM. In our project, we dynamically create FetchXML to retrieve records but sometimes Fetchxml have a lot of columns and conditions etc so its length get increase and we this the fetchxml in URL which violates the browser URL length rule. So When we try to execute this long length FetchXML and retrieve the records using the GET method, We were getting the error message of \u201cHTTP Error 404 – Not Found\u201d because of WEB API request fails to execute too long FetchXML. When we work on this error message, we find that we need to use WEB API Batch Request to execute the long FetchXML.<\/p>\n

In the below example, we execute the long FetchXML of account entity and use POST request to execute long FetchXML.<\/p>\n

First, we created the simple request body as below:<\/p>\n

\/\/create request body\nvar bodyFetch='';\nbodyFetch = '--batch_recordfetch\\n'\nbodyFetch += 'Content-Type: application\/http\\n'\nbodyFetch += 'Content-Transfer-Encoding: binary\\n'\nbodyFetch += '\\n'\nbodyFetch += 'GET [CRM URL]\/api\/data\/v8.2\/accounts?fetchXml=' + fetch + ' HTTP\/1.1\\n'\nbodyFetch += 'Content-Type: application\/json\\n'\nbodyFetch += 'OData-Version: 4.0\\n'\nbodyFetch += 'OData-MaxVersion: 4.0\\n'\nbodyFetch += 'Prefer: odata.include-annotations=*\\n'\nbodyFetch += '\\n'\nbodyFetch += '--batch_recordfetch--'<\/pre>\n
Note: \u2018fetch\u2019 is the parameter of the long FetchXML.<\/p><\/blockquote>\n
And we pass the created the simple request body as data to Ajax request and we will receive the response of request as success or failure as below:<\/p>\n
\/\/create AJAX request\n$.ajax({\ntype: \"POST\",\ncontentType: \"application\/json; charset=utf-8\",\ndatatype: \"json\",\nasync: true,\nurl: '[CRM URL]\/api\/data\/v8.2\/' + '$batch',\ndata: bodyFetch,\nbeforeSend: function (xhr) {\n\/\/Specifying this header ensures that the results will be returned as JSON.\nxhr.setRequestHeader(\"Accept\", \"application\/json\");\nxhr.setRequestHeader(\"OData-MaxVersion\", \"4.0\");\nxhr.setRequestHeader(\"OData-Version\", \"4.0\");\nxhr.setRequestHeader(\"Prefer\", \"odata.include-annotations=*\");\nxhr.setRequestHeader(\"Content-Type\", \"multipart\/mixed;boundary=batch_recordfetch\");\n},\n\/\/success callback\nsuccess: function (data, textStatus, xhr) {\ndata = JSON.parse(data.substring(data.indexOf('{'), data.lastIndexOf('}') + 1));\nif (data != null) {\nif (data.value == null) {\nalert(\"success\");\n}\n}\n},\n\/\/error callback\nerror: function (xhr, textStatus, errorThrown) {\nalert(\"failed\");                          \n}\n});<\/pre>\n
Conclusion:<\/h2>\n
User can easily execute the long length FetchXML using the WEB API Batch Request.<\/p>\n
To read more about\u00a0FetchXML visit here<\/a>.<\/strong><\/em><\/p>\n
\"Export<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Introduction: Recently we had a project where we use WEB API for retrieve the records from Dynamics CRM. In our project, we dynamically create FetchXML to retrieve records but sometimes Fetchxml have a lot of columns and conditions etc so its length get increase and we this the fetchxml in URL which violates the browser\u2026 Read More: Use WEB API Batch Request in Dynamics 365 to execute\u2026 »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":12520,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,18,19,65],"tags":[795,1813,1815,1817],"class_list":["post-12519","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dynamics-365","category-dynamics-365-v9-2","category-dynamics-crm","category-webapi","tag-fetchxml","tag-web-api","tag-web-api-dynamics-365","tag-web-api-dynamics-crm"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t