Epicor Rest Helper (Nuget) Updated V2

Olga · March 9, 2023, 4:06pm

svannimantyber · March 9, 2023, 4:15pm

Many Thanks. Weird thing was a straight copy produced errors. If I typed it out, no errors.

How would one pass in just one portion of the dataset for an UpdateExt on JobEntry? Do I need the entire payload as executed in swagger or Postman? I would assume minimum is to remove quotes from ds, JobHead, Company etc… Still need continueProcessingOnError

{
      "ds": {
          "JobHead": [
              {
                  "Company": "****",
                  "JobEngineered": false,
                  "JobReleased": false,
                  "JobNum": "239825",
                  "UD_SysRevID": "&&&&"
              }
          ]
      },
  "continueProcessingOnError": false,
  "rollbackParentOnChildError": false
}

klincecum · March 9, 2023, 5:38pm

Probably the Open Quote/Closed Quote thing.

“” vs ""

Jeff_Owens · March 17, 2023, 3:28pm

@josecgomez … Hey … I’m getting this JSON error when the session is getting disposed.

 at Newtonsoft.Json.JsonTextReader.ParseValue()
   at Newtonsoft.Json.JsonTextReader.Read()
   at Newtonsoft.Json.JsonReader.ReadForType(JsonContract contract, Boolean hasConverter)
   at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent)
   at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType)
   at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings)
   at EpicorRestAPI.EpicorRest.DynamicPost(String bo, String method, Object postData, Boolean replaceReturn, EpicorRestStatusCode responseStatusCode, CallContextHeader callContextHeader)
   at EpicorRestAPI.EpicorSession.Dispose(Boolean native)
   at EpicorRestAPI.EpicorSession.Dispose()

… it’s happening in EpicorRest, showing [decompiled]:

Newtonsoft version is 11.02 but haven’t made any code changes to the project.

Any ideas?

UPDATE: It doesn’t seem to occur reliably. Can anyone surmise why/what circumstance this might happen?

It’s lonely in here…

tcarlson · March 29, 2023, 3:40pm

I’m having issues getting the EpicorRestAPI to work for me. Im guessing I have something setup incorrectly and that is the issue. If Someone could help with this I would appreciate it.

 Dictionary<string, string> dic = new Dictionary<string, string>();
            CallContextHeader callContext = new CallContextHeader();
            dic.Add("$top", "10");

            EpicorRest.AppPoolHost = "erp.wi.com";
            EpicorRest.AppPoolInstance = "KineticTest";
            EpicorRest.UserName = "UserName";
            EpicorRest.Password = "Password";
            EpicorRest.Company = "Company";
            EpicorRest.APIKey = "Key";
            EpicorRest.APIVersion = EpicorRestVersion.V2;

            var data = EpicorRest.BoGet("Erp.Bo.PartRevSearchSvc", "A14C", dic, callContext);

Jeff_Owens · March 29, 2023, 3:45pm

Hi Tim, welcome. Have you instantiated/initialized the EpicorRest object?

I’m still using V1 but here’s a basic setup:

EpicorRest.AppPoolHost = AppPoolHost;
EpicorRest.AppPoolInstance = AppPoolInstance;
EpicorRest.UserName = UserName;
EpicorRest.Password = Password;
EpicorRest.BearerToken = BearerToken;
EpicorRest.IgnoreCertErrors = false;

if (UseWebServicesLicence) EpicorRest.License = EpicorLicenseType.WebService;
else EpicorRest.License = EpicorLicenseType.Default;

EpicorRest.CallSettings = new CallSettings(CompanyID, String.Empty, String.Empty, String.Empty);

tcarlson · March 29, 2023, 4:29pm

Jeff thanks for the quick response. Mine looks like it’s set up pretty much like yours.

josecgomez · March 29, 2023, 4:48pm

Lot me check those search BOs are funky does it work in swagger??

Though it looks like a REsT Sharp error do you have to r dependencies installed?

tcarlson · March 29, 2023, 4:58pm

Thanks for Responding Jose. I was able to do it in swagger and in postman. I have loaded the libraries for restsharp 109.0.1 and I am using the 2.1.0.3 version of EpicorRestAPI…

klincecum · March 29, 2023, 5:44pm

Yes looks like it can’t find the constructor for RestClient.

I would try removing the dependencies and add them back in case something went haywire.

tcarlson · March 29, 2023, 6:17pm

Kevin I uninstalled and reinstalled restsharp and still get the error is there a different version of restsharp I should be using? when I look at NuGet it shows no dependency’s so I’m not sure which version of RestSharp I’m supposed to be using…

klincecum · March 29, 2023, 6:26pm

I haven’t done a lot of rest calls against Epicor so I actually have not had the opportunity to use @josecgomez tool, so I was just speaking in general.

josecgomez · March 30, 2023, 1:39am

What version of .Net?

tcarlson · March 30, 2023, 12:16pm

.net 4.8

josecgomez · March 30, 2023, 1:23pm

ok yeah you aren’t setting up that call correctly.
PartRevSearch has two ODataEnd Points
/PartRevSearches [GET] [POST]
and
.PartRevSearches(‘Company’,‘Part’,‘Rev’,‘Alt’,‘ProcessMfg’) [Get][Delete][Patch]

You aren’t calling either of these.

You are doing a BO Get on Erp.BO.PartRevSearchSvc/A14C ← which isn’t a valid end point. I’m Assuming you are trying to get the revisions for a Part number Called A14C? In that case the call should be

[GET] Erp.BO.PartRevSearchSvc/PartRevSearches?$filter=PartNum eq ‘A14C’

Which in my LIbrary would be something like

 Dictionary<string, string> dic = new Dictionary<string, string>();
dic.Add("$filter","PartNum eq 'A14c'");

var data = EpicorRest.BoGet("Erp.BO.PartRevSearchSvc", "PartRevSearches", dic, callContext);

Jeff_Owens · March 30, 2023, 1:42pm

(sorry to inject my own question during your flow here Tim)

Anyone… I have a BAQ that accepts a parameter @DataTags that is used in the BAQ Designer in a Table Criteria where the table field is IN clause the @DataTags list.

Because the field is a string, in SQL this would yield something like "…WHERE field IN (‘stringA’, ‘stringB’, ‘stringC’) … " but I don’t know how to pass that parameter so that it will work via the client.

Anyone have any helpful tips here?

josecgomez · March 30, 2023, 1:45pm

Add the same parameter over and over again. (its kind of hard to do with a dictionary though

josecgomez · March 30, 2023, 1:48pm

Let me see I think I have a way stand by doing some testing.

Jeff_Owens · March 30, 2023, 1:49pm

… I could still leave the BAQ Table Criteria as in IN? The IN clause is an OR state, correct? I don’t want a field = ‘string1’ AND field = ‘string2’ AND field = ‘string3’ … is the concern with what you’re suggesting, no?

josecgomez · March 30, 2023, 1:50pm

You don’t ahve to change the BAQ passing the same paramter over and over again fills in that ParamList. Stand by doing some testing.