Hi All
I am trying to use a rest call to get data from the automatic tax proposal just through Postman for the moment.
When I use:
then I get the following JSON coming back
{
"@odata.context": "https://<server>:<port>/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://<server>:<port>/int/ifsapplications/projection/v1/TaxProposalSummaryHandling.svc/Reference_TaxTempFieldCtrlDet(Company='50',ProposalId=1,TemplateId='UK2013',Rownumber=1)
which gives me this JSON:
{
"@odata.context": "https://<server>:<port>/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