+ Start a Discussion
MedhanieHabteMedhanieHabte 

Stuck on Data Integration Specialist Superbage #9

Greetings, I've created my external object for the Data Integration Specalist Superbadge and have configured my external ID as seen below, however, the challenge seems to not pass, indicating that the indirect lookup was not properly created. Here's how I set up the projectRef__c field, which was what I used to push data from the external object into the project object in Salesforce. Are there any steps, I need to take. Hope it helps.
User-added image


User-added image
 
LBKLBK
I guess Editing the related list in Project page layout is part of this challenge. Have you done that?

Also, can post the challenge details here, because I am not able to see the actual challenge details anymore in my trailhead account (since I have completed the challenge).
MedhanieHabteMedhanieHabte
Yep did all that, I'll post details shortly.
MedhanieHabteMedhanieHabte
The details of the challenge #9 are Synchronize external billing data with Salesforce in real time Configure Salesforce Connect to integrate with Square Peg's external billing system to expose invoice information as children of projects as outlined in the requirements.
LBKLBK
Have you Validated and Synced the data?

You should be seeing 80+ records on your external object invoices__x.
MedhanieHabteMedhanieHabte
Yes, I see the 80+ records. In looking at these I noticed the projectRef__c field on records, click it and it takes me to an error message, indicating the record(s) do not exist. Perhaps there is something I may be missing, I will examine further more later.
Shukla YogeshShukla Yogesh
Hi LBK and Medhanie

I am getting below error while validating the challege:

Challenge Not yet complete... here's what's wrong: 
There was an unexpected error in your org which is preventing this assessment check from completing: System.ExternalObjectException: data.api.DataSourceException: The "billDate__c" field is of type date or date/time, but the value from the external system is "2016-12-09-06:24:25-UTC". Contact your administrator for help.


I tried making Bill Date filed as Date & Date Time but no luck. ANy idea how to rectify this error?

Regards
Yogesh
Shukla YogeshShukla Yogesh
Hi LBK and Medhanie

I had updated the Bill Date field to text and it worked. Finally obtained the superbadge. :)

Regards
Yogesh
MedhanieHabteMedhanieHabte
I have my bill date as text as well.
MedhanieHabteMedhanieHabte
changed the name to ProjectRef and I passed! 220 badges and counting.
Sébastien ColladonSébastien Colladon
I have an issue, I hope this is the right thread to discuss about :

Challenge Not yet complete... here's what's wrong:
There was an unexpected error in your org which is preventing this assessment check fromcompleting: System.ExternalObjectException: An error occurred while connecting to the external system. Please try again, or contact your administrator. Attempted to reach thisURL: https://sb-integration-is.herokuapp.com/odata/invoices?$top=2&$inlinecount=allpages&$select=id. Error received from the external system: 500: Internal Server Error
I did the steps 3 times with the same result.
Here is what I did :
  1. Create the external data source
  2. Validate & Sync
  3. Change the label for Bill Amount & Bill Date
  4. Change the field ProjectRef__c to be an indirect lookup on the Project__c.ProjectRef__c field
  5. Execute the Challenge
I would like to know is the service is up and running.
Because when I copy paste the url "https://sb-integration-is.herokuapp.com/odata/invoices?$top=2&$inlinecount=allpages&$select=id" in the browser I receive "500: Internal Server Error" whereas this url display the service catalogue : "https://sb-integration-is.herokuapp.com/odata/"

Is there any issue with the service ?
Sébastien ColladonSébastien Colladon
Is there anybody with the same issue ?
Or with an explanation so I can try to correct my solution and pass the challenge ?
Gowtham Gunnagare HuchegowdaGowtham Gunnagare Huchegowda
Hi,

Challenge Not yet complete... here's what's wrong: 
The Invoices related list does not appear to be on the Projects page layout.

Any Thoughts??
Karthik AriharapakamKarthik Ariharapakam
Hi,
Data Integration Specialist Challenge # 9 -
I have created my external object for the Data Integration Specialist Superbadge and have configured my External ID as seen below. However, the challenge seems not to pass, indicating that the indirect lookup field was not properly created. Please advice if there is anything wrong I am doing. Please share screenshots of steps for  successful challenge completion.
sunil mali 11sunil mali 11
Hi Karthik,
Follow the below steps to pass the challenge:
Goto External Object "invoices" --> Click Edit next to "projectRef" --> Click on button "Change Field Type" --> Select 
Indirect relationship --> Click Next --> Relate to "Project" --> Target object(ProjectRef__c) --> Click Save

Thanks,
Sunil
Qing KeQing Ke
Hi,

I have a similar problem. When I change field type to indirect relationship, and then click next, I cannot find any object on Related To list.
Is there anyone know the reason? Thanks.
balaji malemarpurambalaji malemarpuram
Hi ,
I also have the similar problem as below 

Challenge Not yet complete... here's what's wrong: 
The 'projectRef__c' field is not configured correctly as an Indirect Lookup field.
But i configured correct. Any one have any clue.

Thanks,
Balaji M 
Swaraj Behera 7Swaraj Behera 7
Hi,
Facing the same issue, has anyone resolved this ?
balaji malemarpurambalaji malemarpuram

Hi ,
My challenge is completed.I just tried on another trailhead play ground from the beginnning . You just try once. Sometimes it is happening like that.

Thanks,

Balaji M 

Karthik AriharapakamKarthik Ariharapakam
Thanks Balaji. I did try using another trailhead playground and it worked and I now have my shiny badge. :)
Milind Amin 20Milind Amin 20
What is the solution for this issue? I tried whatever mentioned in this tread but getting the below error. however i have not tried to creating new palyground environment since i don't prefer.

#superbadge_integration 9:
Challenge Not yet complete... here's what's wrong: 
The 'invoices__x' external object does not appear to contain the correct fields.


invoices__x object
Milind Amin 20Milind Amin 20
Ended up creating new enviornment and it worked!
S_RathS_Rath
I  have faced the same issue and giving the proper name to indirect lookup worked for me. Please make sure that the name is same as the external Id name i.e. ProjectRef__c.

Please check the screenshot below
User-added image

And here I got my new badge.
User-added image

Hope this worked for you.

Thanks
 
Shraddha Ingle 8Shraddha Ingle 8
This solution worked for me :

1. Rename the projectRef field on 'invoices' external object to ExternalID (both Field Label and API Name)
2. Create an indirect lookup relationship on 'invoices' external object with field and API name = 'projectRef__c'.
Praneetha MurakondaPraneetha Murakonda
Hi All,
Please help me to resolve the issue. I have created fields mentioned in the thread and tried the above mentioned solutions. But didn't worked for me. I'm facing below error:
Challenge Not yet complete... here's what's wrong: 
The 'invoices__x' external object does not appear to contain the correct fields.
User-added image

Thanks!
RaghutrailblazerRaghutrailblazer
@Praneetha,

After creating External Data Sources, click on Validate and Sync button which will create inovice external object and fields in your org.  Then go to invoices external object change datatype of projectRec__c  from text to Indirect lookup relationship and that should help you.

Regards
Raghunandana HS
Saket Ranjan 3Saket Ranjan 3
Create ExternalDataSource(follow the steps given in challange) -> validate and sync "invoices" -> change data type of projectRec__c  from text to Indirect lookup relationship -> add invoices to the page layout of "Project".