Rest API error

Question

Hi AllI am trying to use a rest call to get data from the automatic tax proposal just through Postman for the moment. When I use:https://:/int/ifsapplications/projection/v1/TaxProposalSummaryHandling.svc/Reference_TaxTempFieldCtrlDetthen I get the following JSON coming back{ "@odata.context": "https://:/int/ifsapplications/projection/v1/TaxProposalSummaryHandling.svc/$metadata#Reference_TaxTempFieldCtrlDet", "value": [ { "@odata.etag": "W/\"Vy8iQUFCM09FQUFGQUFCbytIQUFCOjIi\"", "luname": "TaxTempFieldCtrlDet", "keyref": "COMPANY=50^PROPOSAL_ID=1^ROWNUMBER=1^TEMPLATE_ID=UK2013^", "Objgrants": null, "Company": "50", "TemplateId": "UK2013", "ProposalId": 1, "Rownumber": 1, "ReportRow": 6, "TemplateField1": "OUTGOODSTOTAL", "ReportField1": null, "Value1": 0, "TemplateField2": null, "ReportField2": null, "Value2": null, "TemplateField3": null, "ReportField3": null, "Value3": null, "FieldTypeDb1": "CalculatedField", "FieldTypeDb2": null, "FieldTypeDb3": null, "CountryCode": "GB" }, { "@odata.etag": "W/\"Vy8iQUFCM09FQUFGQUFCbytIQUFCOjIi\"", "luname": "TaxTempFieldCtrlDet", "keyref": "COMPANY=50^PROPOSAL_ID=1^ROWNUMBER=2^TEMPLATE_ID=UK2013^", "Objgrants": null, "Company": "50", "TemplateId": "UK2013", "ProposalId": 1, "Rownumber": 2, "ReportRow": 8, "TemplateField1": "ECSUPPTOTAL", "ReportField1": null, "Value1": 0, "TemplateField2": null, "ReportField2": null, "Value2": null, "TemplateField3": null, "ReportField3": null, "Value3": null, "FieldTypeDb1": "CalculatedField", "FieldTypeDb2": null, "FieldTypeDb3": null, "CountryCode": "GB" }, { "@odata.etag": "W/\"Vy8iQUFCM09FQUFGQUFCbytIQUFCOjIi\"", "luname": "TaxTempFieldCtrlDet", "keyref": "COMPANY=50^PROPOSAL_ID=1^ROWNUMBER=3^TEMPLATE_ID=UK2013^", "Objgrants": null, "Company": "50", "TemplateId": "UK2013", "ProposalId": 1, "Rownumber": 3, "ReportRow": 9, "TemplateField1": "ECACQUITOTAL", "ReportField1": null, "Value1": 0, "TemplateField2": null, "ReportField2": null, "Value2": null, "TemplateField3": null, "ReportField3": null, "Value3": null, "FieldTypeDb1": "CalculatedField", "FieldTypeDb2": null, "FieldTypeDb3": null, "CountryCode": "GB" } etc….. I have removed some of the data for clarity ]} I want only specific values so I can use:https://:/int/ifsapplications/projection/v1/TaxProposalSummaryHandling.svc/Reference_TaxTempFieldCtrlDet(Company='50',ProposalId=1,TemplateId='UK2013',Rownumber=1)which gives me this JSON:{ "@odata.context": "https://:/int/ifsapplications/projection/v1/TaxProposalSummaryHandling.svc/$metadata#IfsApp.TaxProposalSummaryHandling.TaxTempFieldCtrlDet", "@odata.etag": "W/\"Vy8iQUFCM09FQUFGQUFCbytIQUFCOjIi\"", "luname": "TaxTempFieldCtrlDet", "keyref": "COMPANY=50^PROPOSAL_ID=1^ROWNUMBER=1^TEMPLATE_ID=UK2013^", "Objgrants": null, "Company": "50", "TemplateId": "UK2013", "ProposalId": 1, "Rownumber": 1, "ReportRow": 6, "TemplateField1": "OUTGOODSTOTAL", "ReportField1": null, "Value1": 0, "TemplateField2": null, "ReportField2": null, "Value2": null, "TemplateField3": null, "ReportField3": null, "Value3": null, "FieldTypeDb1": "CalculatedField", "FieldTypeDb2": null, "FieldTypeDb3": null, "CountryCode": "GB"} so far so good but when I try and get the next value, i.e. rownumber=2 I get an error: The original complete data set gave me: { "@odata.etag": "W/\"Vy8iQUFCM09FQUFGQUFCbytIQUFCOjIi\"", "luname": "TaxTempFieldCtrlDet", "keyref": "COMPANY=50^PROPOSAL_ID=1^ROWNUMBER=1^TEMPLATE_ID=UK2013^", "Objgrants": null, "Company": "50", "TemplateId": "UK2013", "ProposalId": 1, "Rownumber": 1, "ReportRow": 6, "TemplateField1": "OUTGOODSTOTAL", }, { "@odata.etag": "W/\"Vy8iQUFCM09FQUFGQUFCbytIQUFCOjIi\"", "luname": "TaxTempFieldCtrlDet", "keyref": "COMPANY=50^PROPOSAL_ID=1^ROWNUMBER=2^TEMPLATE_ID=UK2013^", "Objgrants": null, "Company": "50", "TemplateId": "UK2013", "ProposalId": 1, "Rownumber": 2, "ReportRow": 8, "TemplateField1": "ECSUPPTOTAL", }, { "@odata.etag": "W/\"Vy8iQUFCM09FQUFGQUFCbytIQUFCOjIi\"", "luname": "TaxTempFieldCtrlDet", "keyref": "COMPANY=50^PROPOSAL_ID=1^ROWNUMBER=3^TEMPLATE_ID=UK2013^", "Objgrants": null, "Company": "50", "TemplateId": "UK2013", "ProposalId": 1, "Rownumber": 3, "ReportRow": 9, "TemplateField1": "ECACQUITOTAL", }I would have expected to be able to get Rownumber 1 - 9.Can anyone see what I am doing wrong here?Thanks

Did you find what you're looking for? If not:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded