ERROR: Fatal error

[HiFiPhile]

Hi,

With Excel 365 I can't get work correctly.

Firstly I added=@OCTOPART_SET_APIKEY("xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx") , it says Octopart Add-In is ready!
Then I tried a simple query: =@OCTOPART_DISTRIBUTOR_STOCK("STPM33TR") which gave me:

ERROR: Fatal error. Please email 'contact@octopart.com' with details (data is not of correct type)

[t-monti]

Same error for me on Office Professional Plus 2019.

I wrote to the 'contact@octopart.com', reporting all the data that I thought useful, including the fact that I had downloaded the latest version from github. They asked me if I installed the latest version of the add-in.... !?

[Daniel-Probent]

Hi,

same error for you, Same error for me on Office Professional Plus 206.

I do have the Api keys provided by Octopart, I enter =OCTOPART_SET_APIKEY ("key api") and the price or other search for components does not work.

I used the add-in provided GitHub OctopartXll-AddIn-packed, in 32-bit version because I have a 32bit version but alas with each query I have ERROR: Fatal error. Please email "contact@octopart.com with details (data is not of correct type).

Please help.

thank you.

best regard's

[t-monti]

I made a little progress. If the query contain a real component part number (SKU), I got the previously error. If the SKU is an unexists P/N like "xyzyxyzyxy"; the Add-In return a message like "ERROR: Query did not provide a result. Please widen your search criteria.".

[Daniel-Probent]

Hi t-monti, If you find me the solution, frankly you're too strong Thank you, Best regard’s [PROBENT TECHNOLOGY] Daniel De Freitas Responsable Département Electronique — Campus Innovaparc 2 rue Jean Perrin 14460 Colombelles T 02 31 35 10 02 M 06 45 88 08 17 FAIRE PREUVE | WWW.PROBENT.COM<http://www.probent.com/> De : t-monti ***@***.***> Envoyé : mardi 30 mars 2021 17:57 À : octopart/api-excel-add-in ***@***.***> Cc : Daniel DE FREITAS ***@***.***>; Comment ***@***.***> Objet : Re: [octopart/api-excel-add-in] ERROR: Fatal error (#4) I made a little progress. If the query contain a real component part number (SKU), I got the previously error. If the SKU is an unexists P/N like "xyzyxyzyxy"; the Add-In return a message like "unable to find component. widen the search". — You are receiving this because you commented. Reply to this email directly, view it on GitHub<#4 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ATOLVL2VTDRDIRYEU3PAXULTGHYFHANCNFSM4ZZUKDRA>.

[mgre44]

Hi, i have Excel 2016 Pro Plus and i'm now facing the same problem you all are experiencing.

The problem is that i was using this add-in for an entire morning without any issue and then it suddenly started to behave like this. I don't think it's related but it happened after i reached and surpasse by few P/N the 500 query limit. After that even after upgrading my plan i started having issues.

[ShaQ68]

Hi, I have Excel 2010 and the same problem.
Finally, I've found a function that returns a result (different from fatal error). It is "=OCTOPART_GET_INFO()"
The function returns a "Version: 2.0.0.18908".
After I attempted to contact Octopart they sent me here.

[t-monti]

Hi to all. Unfortunately I can't get support even by contacting octopart. They told me that official support has ended and therefore I assume we won't have a solution. As you can see, no technician answered here. I'm sorry because our company has been an Altium customer for a long time and I would have expected a better support. We have therefore decided to proceed with other solutions. It's incomprehensible.

[Daniel-Probent]

Hi T-monti,
very thank you for this support!!
I'm shocked, I don't understand that Octopart stops this Excel Add-In , which to charge it
I don't understand

Daniel

[CyberCityCircuits]

@t-monti It seems that Octopart is no longer managing a Excel AddIn, but the wonderful opensource community is. Fear not, I believe it shall work again.

[Daniel-Probent]

Hi T-monti,
Yes I hope, it would be great to be able to operate the addin on excel
thank you

[heming18]

Here's what I can found, it maybe not correct:
1, The excel add-in only support following windows OS:
Win8 32-bit / Excel 2010 32-bit
WinXP 32-bit / Excel 2010 32-bit
Win7 32-bit / Excel 2010 32-bit
Win7 32-bit / Excel 2013 32-bit
Win7 64-bit / Excel 2013 64-bit
So we need to find a win8 32-bit machine.

2, The excel add-in don't need APIKEY, the APIKEY is for REST query.

3, I try the APIKEY to REST query, it says "invalid apikey". Seems it's not activated yet.

4, Please also consider win8 OS firewall. It maybe block excel.

Solution 1:
Win8 32-bit / Excel 2010 32-bit, enable 32bit add-in, no need apikey. Just need =OCTOPART_SET_USER("email").

Solution 2:
Contact octopart tor validate our APIKEY.

:)

[vivienwwp]

Hello! Has there been any solutions since? Octopart support point me to this link. I am having exactly the same issue on Excel 365 64 bit. It says Octopart Add-In is ready! but gives me error:
ERROR: Fatal error. Please email 'contact@octopart.com' with details (data is not of correct type)

[ripperus]

Hi
As you can see inside the code Excel Add-In is using REST wrapper on APIv4, with OCTOPART_URL_BASE https://octopart.com/api/v4/rest and OCTOPART_URL_PART_MATCH_ENDPOINT parts/match.
Query code from Excel looks like:

// Query octopart.com

               var client = new RestClient(OCTOPART_URL_BASE);
               var req = new RestRequest(OCTOPART_URL_PART_MATCH_ENDPOINT, Method.GET)
               .AddParameter("apikey", apiKey)
               .AddParameter("queries", queryString)
               .AddParameter("include[]", "datasheets");

Pricing and availability data is included by default but all other types of data must be added to the request. That's why there is additional parameter "include[]", "datasheets" to make Excel formula =OCTOPART_DATASHEET_URL working. So If you are using Api key for Distributors (without Prices and Stock availability) this Excel Add In will not work. Also if you have Basic plan which do not contain access to Datasheets will also not work.