AIF Service Surrogate foreign key expansion errors

Finance and Operations/AX Developer Forum
1

Hi
I have created a new AIF service using Tools → Application Integration Framework → Create Document service. In the query I have used Ledger JournalTable and LedgerJournalTrans as datasources. I have deployed the service. When I try to use the service in Excel Add in its giving the following error.

6320.error.png
6320.error.png1280×1024 31.9 KB

Please help me on this.
Thanks

2

Hi Ashish,

This may not be the issue with AIF service but an issue with Excel add-in. Just to be double sure, have you tested the AIF service first without using Excel add-in?

3

Hi Harish,

Excel Add in is working fine for the existing standard services, i am able to update the data successfully using standard services.

Thanks!