Processing REST Replies

RLJB

I'm trying to process an XML response. But I get this error:

REST: Object corresponding to Response was not found in the business space version. Ignoring the node

The Response looks like below.

I just want the Status. Any tips on how to set up the Business Objects to accept the response? I have TWO objects at the moment:

Response - which has one ref attribute
Status - which has one plain text attribute called Status.

<Response xmlns:mad:sd="http://www.w3.org/2001/XMLSchema" xmlns:mad:si="http://www.w3.org/2001/XMLSchema-instance">
    <Id>11205321-08b7-4342-8a4d-3ba96fa05fe9</Id>
    <Status>OK</Status>
    <ProviderName>BuildManager</ProviderName>
    <DateTimeUTC>2018-09-16T02:01:18.0523017Z</DateTimeUTC>
    <Invoices>
        <Invoice>
            <Contact>
                <ContactID>614d76c0-30f5-499c-b18a-930b58b179ef</ContactID>
                <ContactStatus>ACTIVE</ContactStatus>
                <Name>TEST C</Name>
                <Addresses>
                    <Address>
                        <AddressType>STREET</AddressType>
                    </Address>
                    <Address>
                        <AddressType>POBOX</AddressType>
                    </Address>
                </Addresses>
                <Phones>
                    <Phone>
                        <PhoneType>DEFAULT</PhoneType>
                    </Phone>
                    <Phone>
                        <PhoneType>DDI</PhoneType>
                    </Phone>
                    <Phone>
                        <PhoneType>FAX</PhoneType>
                    </Phone>
                    <Phone>
                        <PhoneType>MOBILE</PhoneType>
                    </Phone>
                </Phones>
                <UpdatedDateUTC>2018-09-16T02:01:17.363</UpdatedDateUTC>
                <IsSupplier>false</IsSupplier>
                <IsCustomer>true</IsCustomer>
            </Contact>
            <Date>2018-09-15T00:00:00</Date>
            <DueDate>2018-09-20T00:00:00</DueDate>
            <Status>AUTHORISED</Status>
            <LineAmountTypes>Exclusive</LineAmountTypes>
            <LineItems>
                <LineItem>
                    <Description>Consultingservicesasagreed</Description>
                    <UnitAmount>120.00</UnitAmount>
                    <TaxType>OUTPUT</TaxType>
                    <TaxAmount>60.00</TaxAmount>
                    <LineAmount>600.00</LineAmount>
                    <AccountCode>200</AccountCode>
                    <Quantity>5.0000</Quantity>
                    <LineItemID>18900bb2-fc21-4040-a336-563a5ab65560</LineItemID>
                </LineItem>
                <LineItem>
                    <Description>Lots of dev work here</Description>
                    <UnitAmount>108.00</UnitAmount>
                    <TaxType>OUTPUT</TaxType>
                    <TaxAmount>723.60</TaxAmount>
                    <LineAmount>7236.00</LineAmount>
                    <AccountCode>200</AccountCode>
                    <Quantity>67.0000</Quantity>
                    <LineItemID>bf797125-0d93-420e-be69-a6abe0b8d40a</LineItemID>
                </LineItem>
            </LineItems>
            <SubTotal>7836.00</SubTotal>
            <TotalTax>783.60</TotalTax>
            <Total>8619.60</Total>
            <UpdatedDateUTC>2018-09-16T02:01:17.693</UpdatedDateUTC>
            <CurrencyCode>AUD</CurrencyCode>
            <Type>ACCREC</Type>
            <InvoiceID>f5176742-8895-4b1c-9629-58f1d4195ec8</InvoiceID>
            <InvoiceNumber>ABC123</InvoiceNumber>
            <AmountDue>8619.60</AmountDue>
            <AmountPaid>0.00</AmountPaid>
            <SentToContact>true</SentToContact>
            <CurrencyRate>1.000000</CurrencyRate>
        </Invoice>
    </Invoices>
</Response>

Jaymer

You would need a second BO to store the results of invoices. But status is at the top level along with ID and provider. So you just need one BO to get your answer back. The name of it doesn’t matter, just write the XML result into this BO and make sure there is a field for status. I always like to put a couple of fields in there just to be sure that it’s getting the data back correctly. It’s free. You’ll also be able to view the Server Output window to see exactly what’s coming back.

RLJB

Thanks Jaymer.

Curiously, I still couldn't get it to work, but I changed the the BO name to "Response" and it worked. I realise you shouldn't have to. It might be because it is an old BSV (used in 8.1 beta).

Next issue...

Any ideas how to process errors silently? When we get errors the API , throws an error to the user like the one below as a window pop-up. We would prefer to just process them silently (no user knowledge) and carry on - just writing the error to an attribute.

Anyone managed to do this?

Service provider returned the following error: 10 ValidationException A validation exception occurred Item code '101-Consulting' is not valid Item code 'DevH: Development work - per hour rate' is not valid fc436985-4360-4ea0-b6a8-ff0dafc37217 BigCompanyINC 2009-08-30T00:00:00 2009-09-20T00:00:00 AUTHORISED Exclusive 101-Consulting Consultingservicesasagreed 120.00 OUTPUT 60.00 600.00 200 Activity/Workstream Onsiteconsultancy00000000-0000-0000-0000-000000000000 5.0000 DevH: Development work - per hour rate Lots of dev work here 108.00 OUTPUT 723.60 7236.00 200 Activity/Workstream Onsiteconsultancy00000000-0000-0000-0000-000000000000 67.0000 7836.00 783.60 8619.60 AUD ACCREC f5176742-8895-4b1c-9629-58f1d4195ec8 ABC123 true